My Oracle Support Banner

PX Connection Fails Intermittently Due To JDBC Connection Error (Doc ID 1673920.1)

Last updated on AUGUST 09, 2018

Applies to:

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

Symptoms

On : 9.3.2.0 version, Process Extension

PX connection is failing intermittently with following errors:

AGILE ERROR
-----------------------
java.sql.SQLRecoverableException: ORA-00028: your session has been killed
ORA-00028: your session has been killed

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3593)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3637)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:130)
at com.agile.cs.query.QueryCacheResult.execute(QueryCacheResult.java:790)

 

javax.transaction.SystemException: Heuristic hazard: (AgileContentPool_agileDomain, HeuristicHazard, (javax.transaction.xa.XAException: Two rollbacks failed. The first one threw Closed Connection. The second one threw Closed Connection))
at weblogic.transaction.internal.ServerTransactionImpl.internalRollback(ServerTransactionImpl.java:455)
at weblogic.transaction.internal.ServerTransactionImpl.rollback(ServerTransactionImpl.java:420)
at weblogic.ejb.container.internal.BaseRemoteObject.postInvoke1(BaseRemoteObject.java:324)
at weblogic.ejb.container.internal.StatelessRemoteObject.postInvoke1(StatelessRemoteObject.java:20)
at weblogic.ejb.container.internal.BaseRemoteObject.__WL_postInvokeTxRetry(BaseRemoteObject.java:217)
at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:45)
at com.agile.cs.query.QuerySessionBean_agpljj_EOImpl.executeQuery(Unknown Source)
at com.agile.ipa.pc.CMQuery.loadTable(CMQuery.java:470)
at com.agile.ipa.pc.CMQuery.loadTable(CMQuery.java:436)

DB ERROR
-----------------------
ORA-00600: internal error code, arguments: [15709], [29], [3], [], [], [], [], [], [], [], [], []
ORA-12801: error signaled in parallel query server P003, instance SGLXPLMPDB1:PLMDB1 (1)
ORA-20000: Oracle Text error:
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.DRVPARX", line 44
ORA-00028: your session has been killed
Errors in file /orasys/app/oracle/diag/rdbms/plmdb/PLMDB2/trace/PLMDB2_ora_17303.trc  (incident=279109):
ORA-00600: internal error code, arguments: [15709], [29], [3], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [15709], [29], [3], [], [], [], [], [], [], [], [], []
ORA-12801: error signaled in parallel query server P003, instance SGLXPLMPDB1:PLMDB1 (1)
ORA-20000: Oracle Text error:
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.DRVPARX", line 44
ORA-00028: your session has been killed
Incident details in: /orasys/app/oracle/diag/rdbms/plmdb/PLMDB2/incident/incdir_279109/PLMDB2_ora_17303_i279109.trc



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run PX
2. Check the PX log


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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.