JDBC Sender Channel polling before polling interval is complete

[Former Member]

Hi all,

On our Production Server, we have found that a few JDBC Sender Channels are polling multiple times within one polling interval.

Eg: Suppose for one channel, the polling interval is 7200 secs. It polls once and the polling interval starts. But it polls again 1 or 2 times more maybe just 5 secs later before its next scheduled poll in 7200 secs.

Unfortunately, our scenarios are such that when there are multiple polls within a short span of time, there are data anomolies, causing inconsistancies on Receiver side DB. Hence this is a serious uissue.

Please Help. FYI, all the affected channels run on the same schedule. I am not sure if that can be causing this abnormality.

[Former Member]

H Varun

I have not come across this behavior earlier. But if you are polling same data base using multiple channel at same time data inconsistency can be there. We always prefer to poll the same data base tables with different timings. Setting up poll timings always consider peak loads. Try to change the polls and see if the same behavior exists.

For performance and JDBC issues

Check https://service.sap.com/sap/support/notes/831162

Specially Q 14

Thanks

Gaurav