Symptom
The following error stacktrace message displayed in the workflow execution result:
Message: java.sql.SQLRecoverableException: Closed Connection: OraclePooledConnection.getConnection() - SQLException Ocurred:Invalid or Stale Connection found in the Connection Cache.
Execution time 236ms
Stack Trace:
java.sql.SQLRecoverableException: Closed Connection: OraclePooledConnection.getConnection() - SQLException Ocurred:Invalid or Stale Connection found in the Connection Cache
at oracle.jdbc.pool.OraclePooledConnection.getConnection:327
at oracle.jdbc.pool.OracleImplicitConnectionCache.getConnection:412
at oracle.jdbc.pool.OracleDataSource.getConnection:678
at oracle.jdbc.pool.OracleDataSource.getConnection:254
at oracle.jdbc.pool.OracleDataSource.getConnection:236
at com.digitalroute.misc.jdbc.OracleConnectionFactory.getConnection:133
at com.digitalroute.wfc.sql.forw.SQLForwExec.initialize:155
at com.digitalroute.wf.agent.BatchController.initializeImpl:109
at com.digitalroute.wf.agent.BatchProcessorController.initializeImpl:378
at com.digitalroute.wf.agent.ComponentController.initialize:103
at com.digitalroute.wf.agent.AgentController.initialize:157
at com.digitalroute.wf.WorkflowBatchController.initialize:597
at com.digitalroute.wf.WorkflowBatchController.startComponentThreads:496
at sun.reflect.GeneratedMethodAccessor551.invoke
at sun.reflect.DelegatingMethodAccessorImpl.invoke:43
at java.lang.reflect.Method.invoke:498
at com.digitalroute.rcp.DRRCPCommunicationProtocolImpl.handleRemoteInvocation:412
at com.digitalroute.rcp.DRRCPRequestWorkerPool$RemoteInvocationRequestWorker.run:200
at java.lang.Thread.run:750
Read more...
Environment
SAP Convergent Mediation 4.x or above
Product
Keywords
Convergent Mediation, batch workflow, Oracle DB, IDLE_TIME, oracle.pool.inactivitytimeout, JDBC connection pool , KBA , XX-PART-DRT , DigitalRoute , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview