My Oracle Support Banner

Error 'Event Code PRMDB-2073-C' / 'trigger 'ADMUSER.PROJECT_UPDATE_DELETE' is invalid and failed re-validation' When Updating a Baseline or Adding a Project After P6 Upgrade (Doc ID 2530234.1)

Last updated on DECEMBER 04, 2019

Applies to:

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

Symptoms

After P6 is upgraded to 17.12, when attempting update a baseline or add a project, the following event code is received:

Event Code PRMDB-2073-C
PRM DBAccess Error - ORA-04098 trigger ADMUSER.ACTIVITY_UPDATE is invalid and failed validation.

This event code also occurs for trigger TASK.ACTIVITY_UPDATE.

If the triggers are disabled, baseline update / project creation works.

 

The issue can be reproduced when using the steps below to add a project:

  1. Upgrade the P6 environment to 17.12.
  2. Login to P6 Professional.
  3. Navigate to Enterprise > Projects and step through the process to add a new project.
  4. The message "New Project has been accepted" displays; click Finish.
  5. View the reported error.

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!


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