Error:"PLS-00905: Object ADMUSER.SYSTEM_MONITOR Is Invalid" When Trying to Initialize Background Jobs (Doc ID 1982313.1)

Last updated on JUNE 29, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 7.0 SP1 and later
Information in this document applies to any platform.
Affected Database: Oracle

Symptoms

On : 7.0 SP2 version, Project Management, Oracle Database

When attempting to manually run the background jobs against the Project Management database, the following error occurs:

ERROR
-----------------------

 

STEPS TO REPRODUCE:
---------------------------
1.  Connect to the database as the Administrative user (Example:  Admuser).
2.  Attempt to run the following scripts:

begin system_monitor; end;
/
Begin data_monitor; end;
/

3.  Observe the reported error.

 

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, it is not possible to manually run the background jobs.

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