Starting with Clarity 188.8.131.52 patch and Clarity 13.2, the 'Datamart Extraction' job generates this error only in ORACLE RAC configuration.
SQL error code: 4068
Error message: [CA Clarity][Oracle JDBC Driver][Oracle] ORA-04068: existing state of packages has been discarded
ORA-04065: not executed, altered or dropped stored procedure "CLARITYPROD.NBI_EXTR_RF_SP"
ORA-06508: PL/SQL: could not find program unit being called: "CLARITYPROD.NBI_EXTR_RF_SP"
ORA-06512: at "CLARITYPROD.NBI_EXTRACT_SP", line 227
ORA-06512: at line 1
CLRT-72144 : This issue is caused by the introduction of a new feature in Oracle 11g RAC configuration.
The error message is generated when an index is dropped and recreated through the stored procedure.
The Datamart Job failed to run on Oracle RAC databases ONLY due to a known issue with Oracle. (Oracle Bug Number:16748831)
The Datamart procedure is modified to work-around this problem. The Oracle user(CLARITY) needs to have 'alter session' privilege if not given already.
Resolved in Clarity 13.1 Generic Patch
Resolved in Clarity 13.2 Generic Patch
Resolved in Clarity 13.3
Manually grant the privilege to the Oracle Clarity User : grant alter session to <schema>;
Reference TEC581256 : PPM 13.1 Generic Patch available to resolve reported issues
Reference TEC599354 : PPM 13.2 Generic Patch available to resolve reported issues
Reference TEC603462 : Datamart Extraction job fails with message 'no data found' after upgrade to Clarity 13.2 or applying patch 184.108.40.206 for 13.1
Release: ESPCLA99000-13.2-Clarity-Extended Support Plus