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
book
Article ID: 103923
calendar_today
Updated On:
Products
Clarity PPM SaaSClarity 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