org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object, cause: java.util.NoSuchElementException: Timeout waiting for idle object
Error 2:
Inbound processing in endpoint at /quote_createupdate failed with message "Fault:javax.script.ScriptException: java.lang.Exception: com.sap.it.api.asdk.exception.DataStoreException: java.sql.SQLException: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object@ line 35 in Write_Data Store.groovy", caused by "NoSuchElementException:Timeout waiting for idle object"
Error 3:
We found some messages also in
"Abandoned"
status.
We see this weird behavior and all these errors occurred only during 1 to 1.5 hour time span. After that, CPI tenant was back to normal and we don't find the issues.
Please find the below from CPI system trace logs:
1.) #Persistence##anonymous#AvatarThreadLOW51####na#na#na#na#[Persistence][SYS][PERSISTENCE_NOT_AVAILABLE]:The persistence is not available! Details Time until last persistence status update has exceeded maximum timeout.
2.) Database connection pool RUNTIME is exhausted. Borrowed connections:
What will be the root cause for these errors? Was CPI tenant unstable or CPI instance had some issues only during that that time span?
Could anyone came across these errors in your CPI tenant?
Thanks.!
Regards,
Devaraj
Hi
devaraj.r1
,
These kind of exception occurs when the database connection pool is exhausted and this happens when your integration flows have flow steps that involves data base connectivity like DataStore, Aggregator, etc. is not modelled properly and there are number of simultaneously opened database connections.
Kindly check the following documentation to understand this in detail: