My Oracle Support Banner

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

Last updated on JANUARY 20, 2021

Applies to:

Oracle Agile PLM Framework - Version 9.3.0.1 and later
Information in this document applies to any platform.

Symptoms

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)
[...]

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.