SCI(SAP cloud integration) db connection always failed when try to call db operation.

[scar]

Hi Experts,

When try to use " define data store operation", it always failed as below which indicates db connection is not available.

It once works but not works as expected recently, I've tried to delete the operation and add new one. I also tried to create one simple iFlow only try to save data with a "write". Both of the test results shows the db connection is not working.

Is there anything I need to do?

Error info:

com.sap.it.rt.adapter.http.api.exception.HttpResponseException: An internal server error occured: it-db-rt.cx-holidays-tests-na4xzf6x - Connection is not available, request timed out after 30000ms..

SAP help doc

"https://help.sap.com/docs/CLOUD_INTEGRATION/368c481cd6954bdfa5d0435479fd4eaf/79f63a4bf5a44b5996aa34c51e2f187f.html?locale=en-US&q=write%20operation"

[anboeh1 · Accepted solution]

This seems to be a know issue with limitation of DB connections to the CPI-internal database. Please have a look at SAP KBA 2492017 - SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object

• Avoid scheduling many iflows, which use persistency steps, to run at the same time. The following documentation is the official recommendation by SAP about the IFlow design: Control the Number of Simultaneously Opened Database Connections
• Avoid using JDBC transaction handling with long running iflows which use persistency steps (re-design the flow to work with JDBC Transaction Handling deactivated)
• The default JDBC connection pool size value is 8. If it is necessary to increase it, create an incident in BC-CP-IS-OPS