ORA-04068: existing state of packages has been discarded - Datamart Job in Oracle RAC

Document ID : KB000020340
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue:

Starting with Clarity 13.1.0.4 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

Cause:

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) 

Resolution:  

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

Workaround:  

Manually grant the privilege to the Oracle Clarity User :  grant alter session to <schema>;   

Additional Information:  

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 13.1.0.5 for 13.1