ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Errors in the CA PPM app log after upgrading to 15.4.1
Article ID: 103923
Clarity PPM SaaSClarity PPM On Premise
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
These errors are caused by invalid objects in the database.
Release: Component: ODPRD
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