Event Code PRMDB-####-A, Message "PRMDB Access Error: ORA-00060: deadlock detected while waiting for resource" When Two Users Are Deleting A Project (Different Projects) At The Same Time (Doc ID 2057138.1)

Last updated on MAY 19, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 15.1.0.0 and later
Information in this document applies to any platform.

Symptoms

When two users are deleting projects (not the same project) at the same time, the following error occurs:

ERROR
---------------------------
Event code PRMDB-####-A

Message:
Application Exception EprmDBSQLExecutionFailure
PRMDB-####-A PRMDB Access Error: ORA-00060: deadlock detected while waiting for resource


STEPS TO REPRODUCE:
---------------------------
1. Connected to P6 Professional with two users
2. Deleted two unique projects, one from each connected session
3. Note the reported error which can occur

ADDITIONAL SYMPTOM #1:

When attempting to save activity data in P6, activities page, the following error occurs:

ERROR
-----------------------
java.lang.reflect.undeclaredthrowableexception

The P6WebAccess.html log file generates the following error when the above exception occurs:

ERROR
-----------------------
SEVERE: Failed updating values with query: insert into task ($COLUMNS) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
parms: $VALUES
com.primavera.PhoenixException: DBEngine.executeUpdate: IO Error: Socket read timed out
at com.primavera.bo.base.DBEngineImpl.executeUpdate(Unknown Source)
at com.primavera.bo.base.LDBEngineImpl.a(Unknown Source)
...
Caused by: java.sql.SQLRecoverableException: IO Error: Socket read timed out
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1065)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
... 50 more
Caused by: oracle.net.ns.NetException: Socket read timed out
at oracle.net.ns.Packet.receive(Packet.java:339)
at oracle.net.ns.DataPacket.receive(DataPacket.java:106)
...

SEVERE: Failed to roll back transaction.@#$%/BO (User Id: ### DB Id: #)
com.primavera.PhoenixException: PTransaction.rollbackTransaction:
at com.primavera.bo.base.DBEngineImpl.rollbackTransaction(Unknown Source)
...
Caused by: com.primavera.infr.db.ConnectionRecycledException: Connection has been recycled. Database $NAME Pool PMT
at com.primavera.infr.db.PConnection.a(Unknown Source)

ADDITIONAL SYMPTOM #2:

When performing various tasks in Primavera (Professional Client and Web), various error messages are thrown.

Example: When adding an Activity, the P6 Professional Client freezes (the Event Viewer logs an 1002 - App Hang Error).

ERRORS:
-----------
TCVirtualTable.ExistInDB: table=(User Session), sql=(), Exception=(HTTP/1.1 504 Gateway Time-out)

Event Code: PRMDB-2920-0
Description: PRM DBAccess Error: HTTP/1.1 503 Service Unavailable
Executable: PM.exe

Changes

 

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