My Oracle Support Banner

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

Last updated on FEBRUARY 21, 2019

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 15.1.0.0 to 15.2.1.0 [Release 15.1 to 15.2]
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

NOTE: The actual error code numeric code can differ from system to system, the important portion is to review the entire error please review the Document referenced at the bottom of this Document, Process for Gathering and Submitting Complete "Event Code" Error Information.  

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: "<User Id>"DB 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 "<Database>" 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

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


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