Errors in the CA PPM app log after upgrading to 15.4.1

Article Id: 103923
Status: Published
Updated On: 05-07-2018 06:38
Products:
CLARITY PPM FOR ITG , CA Project & Portfolio Management , CLARITY PPM FEDERAL , CA Project & Portfolio Management SAAS , STARTER PACK-CLARITY PPM
Issue/Introduction:

After upgrading ppm to 15.4.1, we found the following string of errors in the app log:

Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-04068: existing state of packages has been discarded 
ORA-04061: existing state of package "PPMDB.CMN_SECURITY_PKG" has been invalidated 
ORA-04065: not executed, altered or dropped package "PPMDB.CMN_SECURITY_PKG" 
ORA-06508: PL/SQL: could not find program unit being called: "PPMDB.CMN_SECURITY_PKG" 
ORA-06512: at "PPMDB.CMN_SEC_CHK_CLS_INST_RIGHT_FCT", line 18 
ORA-06512: at line 1 

Cause:

These errors are caused by invalid objects in the database.

Environment:

Release:
Component: ODPRD

Resolution:

For On-Premise Customers:
1. Run the CA PPM Health Report
2. Look for any invalid database objects
3. Provide the list of invalid objects to your DBA and request for those to be recompiled and validated
4. Run the CA PPM Health Report again to check if those objects are now valid

For SaaS Customers:
1. Run the CA PPM Health Report
2. Look for any invalid database objects
3. Open a case with CA Support, and provide the output of the CA PPM Health Report
4. The CA Support team will work with the SaaS DBA team to have those invalid objects recompiled
5. Once you are notified via your case that the objects have been recompiled, run the CA PPM Health Report again to check if any objects are showing as invalid