While Running SDK Application, Connection Fails Intermittently Due to JDBC Connection Pool Limit Reached (Doc ID 1265537.1)

Last updated on FEBRUARY 13, 2017

Applies to:

Oracle Agile PLM Framework - Version 9.3.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 23-Dec-2014***

Symptoms

Running Agile PLM 9.3.0.1 on WebLogic

SDK based Custom Report fails intermittently.

Custom SDK application incurs many transactions and is run frequently.

Error in the weblogic logs:

####<Sep 13, 2010 12:32:34 PM PDT> <Notice> <EJB> <server name> <server name> <[ACTIVE] ExecuteThread: '23' for queue: 'weblogic.kernel.Default (self-tuning)'> <zk2admin> <> <> <1284406354504> <BEA-010014> <Error occurred while attempting to rollback transaction: javax.transaction.SystemException: Heuristic hazard: (weblogic.jdbc.wrapper.JTSXAResourceImpl, HeuristicHazard, (javax.transaction.xa.XAException: Closed Connection))
javax.transaction.SystemException: Heuristic hazard: (weblogic.jdbc.wrapper.JTSXAResourceImpl, HeuristicHazard, (javax.transaction.xa.XAException: Closed Connection))
at weblogic.transaction.internal.ServerTransactionImpl.internalRollback(ServerTransactionImpl.java:413)
at weblogic.transaction.internal.ServerTransactionImpl.rollback(ServerTransactionImpl.java:378)
at weblogic.ejb.container.internal.BaseRemoteObject.handleSystemException(BaseRemoteObject.java:854)
at weblogic.ejb.container.internal.BaseRemoteObject.handleSystemException(BaseRemoteObject.java:809)
at weblogic.ejb.container.internal.BaseRemoteObject.postInvoke1(BaseRemoteObject.java:514)
at weblogic.ejb.container.internal.StatelessRemoteObject.postInvoke1(StatelessRemoteObject.java:60)
at weblogic.ejb.container.internal.BaseRemoteObject.postInvokeTxRetry(BaseRemoteObject.java:441)
at com.agile.pc.cmserver.pcmhelper.PCMHelperSessionBean_9xz6y2_EOImpl.logout(PCMHelperSessionBean_9xz6y2_EOImpl.java:1606)
at com.agile.pc.cmserver.pcmhelper.PCMHelperSessionBean_9xz6y2_EOImpl_WLSkel.invoke(Unknown Source)
[...]

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms