Skip to Content

Records are updating slowly in DB by receiver JDBC channel.

Jul 31, 2017 at 01:57 PM


avatar image

Dear All,

My Scenario is JDBC to RFC synchronous scenario. we have used "RequestResponseBean" in Sender Jdbc channel for syncronous. So we have used 2 jdbc channles 1 for selecting the records from DB and 2nd for updating the response in DB.

The select query is working fine and it is selecting the records properly with in time,but while updating the response in DB coming from ECC is taking time .

The other scenarios with same configurations are working fine. we are getting issue with only for one plant.

for your reference am attaching the screen shots for both plants please find.

Is it PI issue or DB issue?

Kindly help me how to check and resolve this issue.



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Apu Das Jul 31, 2017 at 02:09 PM

Hi Ramu,

I believe it's insert query issue.

If it is your Test system then separately perform one direct insert query as you are sending in the response through PI. It may happen that system is taking more times to filter data for a particular plant.



Show 2 Share
10 |10000 characters needed characters left characters exceeded

Dear Das,

Thanks for quick reply.

It is production issue. Is there any way to check this.


If it's in production, then testing insertion query is definitely not possible. In this case, I will suggest you to reach to the team supporting the Oracle database and ask then if they have any log which contains db access data.

You may check that and have an idea of data processing time.