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.