SAP Knowledge Base Article - Preview

3426666 - SAP CM workflow SQLRecoverableException from Oracle JDBC connection pool

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

SAP Convergent Mediation by DigitalRoute all versions

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.