Exception Exception in module PM.EXE at 000000000118614B. GET_SAFETY_DATE -54: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired".

Applies to: Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 18.8 and later. Information in this document applies to any platform.

Symptoms: When attempting to log into P6 Professional, the following error occurs.

Error: Exception Exception in module PM.EXE at 000000000118614B. GET_SAFETY_DATE -54: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired".

Cause: A bug in the GET_SAFETY_DATE PACKAGE causes error
"Exception Exception in module PM.EXE at 000000000118614B. GET_SAFETY_DATE -54: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired" to occur.

Solution

This issue has been resolved, and the fix has been included as part of the following patch sets:

• Primavera P6 Project and Portfolio Management (EPPM and PPM) release 19.12.2
• Primavera P6 Project and Portfolio Management (EPPM and PPM) release 20.3 (Cloud-hosted customers)

To review and download the latest patchset, please refer to the following document:

• What are the Latest Patch Sets for Primavera P6 Release 19 (Both PPM and EPPM Releases)? (Doc ID 2629038.1)

To implement the solution, please execute the following steps:

1. Download and review the README documentation and pre-requisites for the Patch Set.
2. Ensure that you have taken a backup of your system before applying the recommended Patch Set.
3. Apply the Patch Set in a test environment.
4. Re-test the issue.
5. Implement the solution as appropriate in other environments.

Cloud-hosted Customers

1. Enter an SR for the appropriate Solution and reference this KM as a solution to the issue.
2. Work with Support to apply the workaround (or patch when available).
3. Approve closure of SR when the fix has been applied and verified.

Workaround available:

This workaround is appropriate for other releases of P6 or when it is not yet possible to apply the patchset.

1. Download script (adjusted2.sql) from this article.
2. Run adjusted.sql script as the "admuser" (Oracle database) to re-create the package..

Oracle database:

• Use SQLPLUS or SQLDeveloper
• Connect as the admuser.
• Run the adjusted2.sql script.