Skip to Content

Records are updating slowly in DB by receiver JDBC channel.

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.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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.



    Add comment
    10|10000 characters needed characters exceeded

    • 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.