JDBC Sender not polling Data (Channel in Green Status)
We are facing an issue in production XI system where in JDBC sender channel is not polling any data from the table. Business and DB technical guy confirmed that there is new data which matches select query of XI JDBC sender channel. However XI jdbc channel is not able to poll any data.
The channel is in green status for all server nodes. But no log (as polling) in communication channel monitoring. We tried the following.
1. general JDBC locks in VA (But no JDBC locks)
2. stopped and started the channel, but no luck
3. deactivated and reactivated the JDBC channel in ID.
DB system: Oracle (not sure about version)
SAP PI 7.0 service pack 21