Hello Experts,
We have configured a JDBC look up channel which is activated and started polling the records from a MySQL table. Recently there was a huge number of records are loaded in to table and this adapter tried to pull all of them at a time. As a result it turned PI Java in Out of Memory error.
we tried to restart the Java engine , but as soon as we start I believe the channel also starts polling and causing the same error. It is a kind of never ending loop.
can you please advise how to handle this situation ? is there a way we can stop or inactive the JDBC adapter service before starting the J2EE?
this is in development box. PI version in PI 7.31 Dual stack.
Thanks in advance
Sugata B