Errors in the CA PPM app log after upgrading to 15.4.1

book

Article ID: 103923

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS - Application Clarity PPM On Premise

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