Error: "ORA-04063: Package Body "ADMUSER.PRM_PAUDIT" Has Errors" Upgrading P6 EPPM Database When Auditing Is Turned On (Doc ID 2214724.1)

Last updated on JANUARY 12, 2017

Applies to:

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

Symptoms

Using Primavera P6 Enterprise Project Portfolio Management (P6 EPPM):

When attempting to upgrade the P6 EPPM database to r16.2.0.0 (from r8.3.x, although other versions may be affected) using dbsetup, the following error occurs when auditing is enabled, causing the upgrade to fail:

ERROR
-----------------------
Could not complete because the job "Run SQL Script orpm_admuser_upgrade.sql" failed.
com.primavera.database.tools.DatabaseToolException: ORA-04063: package body "ADMUSER.PRM_PAUDIT" has errors
ORA-06508: PL/SQL: could not find program unit being called: "ADMUSER.PRM_PAUDIT"
ORA-06512: at "ADMUSER.PRMAUD_QUERYLIB", line 25
ORA-04088: error during execution of trigger 'ADMUSER.PRMAUD_QUERYLIB'


Note, the databasesetup.log (found in the user's profile) returns the following error:
[ERROR] [TIMESTAMP] ORA-04063: package body "ADMUSER.PRM_PAUDIT" has errors
ORA-06508: PL/SQL: could not find program unit being called: "ADMUSER.PRM_PAUDIT"
ORA-06512: at "ADMUSER.PRMAUD_QUERYLIB", line 25
ORA-04088: error during execution of trigger 'ADMUSER.PRMAUD_QUERYLIB'

[ERROR] [TIMESTAMP] Database Error: error number=4063
[ERROR] [TIMESTAMP] Error Message: ORA-04063: package body "ADMUSER.PRM_PAUDIT" has errors
ORA-06508: PL/SQL: could not find program unit being called: "ADMUSER.PRM_PAUDIT"
ORA-06512: at "ADMUSER.PRMAUD_QUERYLIB", line 25
ORA-04088: error during execution of trigger 'ADMUSER.PRMAUD_QUERYLIB'

[WARN] [TIMESTAMP] [USER] Could not complete because the job "Run SQL Script orpm_admuser_upgrade.sql" failed.
com.primavera.database.tools.DatabaseToolException: ORA-04063: package body "ADMUSER.PRM_PAUDIT" has errors
ORA-06508: PL/SQL: could not find program unit being called: "ADMUSER.PRM_PAUDIT"
ORA-06512: at "ADMUSER.PRMAUD_QUERYLIB", line 25
ORA-04088: error during execution of trigger 'ADMUSER.PRMAUD_QUERYLIB'

at com.primavera.database.tools.ScriptRunner.ScriptRunner.runSQL(ScriptRunner.java:209)
at com.primavera.database.tools.ScriptRunner.ScriptRunner.run(ScriptRunner.java:145)
at com.primavera.database.tools.dbmt.workflow.SqlScriptJob.doJob(SqlScriptJob.java:86)
at com.primavera.database.tools.dbmt.AbstractJob.execute(AbstractJob.java:67)
at com.primavera.database.tools.dbmt.WorkflowStepJob.doJob(WorkflowStepJob.java:49)
at com.primavera.database.tools.dbmt.AbstractJob.execute(AbstractJob.java:67)
at com.primavera.database.tools.dbmt.actions.BaseWizardRunner.runJob(BaseWizardRunner.java:206)
at com.primavera.database.tools.dbmt.actions.BaseWizardRunner.commit(BaseWizardRunner.java:215)
at com.primavera.database.tools.dbmt.actions.JobTreeTypeDef$JobRunner.run(JobTreeTypeDef.java:253)
at java.lang.Thread.run(Thread.java:745)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Enable database auditing prior to upgrade:
  - exec auditing_enable(null,3);
2. Upgrade the P6 EPPM database to r16.2.0.0
3. Note the reported error which occurs

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