JDBC sender adapter is polling but not picking up any data
We are using PI 7.1 and for some reson our JDBC Sender Adapter has stopped picking up data. It was working previously.
In the Communication Channel Monitoring I can see that at the regular poll intervals it says "Processing Started" but nothing else happens.
I ran the same SQL Select and Update Queries in TOAD and they work perfectly.
I also tried creating a new JDBC sender comm channel but it behaves the same way.
Can anyone help me out on this?