Skip to Content

SOAP to JDBC scenario is taking 15 minutes time to execute

Dear Experts,

I need help on one of the scenario, where SOAP sender is used and the JDBC receiver.

My issue is very often one of the message is taking abnormal time to update data to database. It is around 15 minutes. we raised the query to SAP as well they asked to add the poolwaitingtime parameter which did not fix the issue.

Let me know if you need any other information.

Scenario related parameters: In our complete set up. We do have 5 scenarios to be executed and each scenario is picking data from JDBC and updating back the response to JDBC.

We are using 6 different sender channels to pick data and 6 different receiver channels to update data back to JDBC. 

In sender channel we do have 5 seconds poll interval. 

In receiver channel we have max concurrency as 7 and poolwaitingtime is 180000 so it is going to waiting status after every 15 minutes. 


In log viewer I can see that the connection is getting closed with JDBC and that's the reason for delay. I've attached the required screenshots please help me if you have any idea. 

Regards,
Vidhya

capture.jpg (62.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 09 at 01:51 PM

    Hi Vidhya,

    May be the DB is overloaded and need more resources. Have you tried to set under Advanced JDBC tab the option. Disconnect from Database After Processing Each Message. In this way you can avoid delay if the PI DB session is hung, but if you do a lot of calls in a few time, it can be a bad idea.

    Regards.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 09 at 07:18 PM

    Hi,

    Instead of using six jdbc receiver channels why can't you use single same receiver jdbc for all scenarios as it reduces connections.

    Regards

    Pavan

    Add comment
    10|10000 characters needed characters exceeded