I have a scenario in which i need to poll data from two tables in same DB and then merge it and put a single file in File server.
I have implemented it using BPM with constant correletion.The scenario was working fine.
Since the JDBC adapter is polling data based on dates(client req) some days data wont be there for a particular date and file may not get generated.If both files are not getting generated then it is fine. But sometimes only one file will be generated and fork steps hangs indefenitely.So my entire design fails here.
Could someone thelp me in a better solution.
Thanks & Regards,
Picking data based on Date and Time is not recommended, because when your sender jdbc channel encouters some exception while connecting to Database, then this poll interval will skip so for this time interval data will never pick. So try change your where condition without time and date. Where condition with time and dates will be used mannually to check the data when ever we need.
You are using the fork step so it needs all inputs then only it process the messages further.
Now you have to kill that message (which is not having the data) when nothing data is there, for this you need to define the deadline time.
Based on the specific time it waits for input later it process the messages.