We have an interface in Production which download records from a SQL database staging table and sends it to SAP.
Our polling interval is currently set to pick records every 2 minutes. Below is the configuration of our sender JDBC channel in PO system (version is 7.5).
Select * from dbo.mytable where flag IS NULL
Update dbo.mytable set flag-CURRENT_TIMESTAMP where flag IS NULL
Transaction Isolation Level: Serializable
Database Auto-Commit-Enabled: Yes
Disconnect from Database After Processing Each Message: Yes
Problem is this:
There are instances when our PO system updates the flag of the record which it did not actually pick.
Example. PO system had updated the flag of rows # 1-10 but the XML file in PO workbench only contains rows # 1-9. Hence, it is missing the last row (row # 10) in the XML file.
Anyone had this similar issue? Any suggestions on how to avoid this?