Load DWH job fails - Error "ORA-30926..." on a custom lookup unchecked from DWH

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

The Load Data Warehouse (DWH) intermittently fails with the below error:

[CA Clarity][Oracle JDBC Driver][Oracle]ORA-20100: ENCOUNTERED EXCEPTION IN DWH_LOOKUP_LOAD (DWH_LKP_TEST). SQLERRM : ORA-30926: unable to get a stable set of rows in the source tables
ORA-06512: at line 23

Environment

Release: All

Resolution

The lookup and attribute for this lookup are unchecked from the Data Warehouse and not in DWH_META_COLUMNS. However, the reference remains in DWH_META_TABLES, and has to be removed from there.

1. Confirm the column is not in DWH_META_COLUMNS and it's still in DWH_META_TABLES on the Clarity (PPM) database after running a Full Load. If this is the cause of your issue, proceed to step 2 below.
2. Run the query on the database (replacing the table name and column name with correct values accordingly):
   
   delete from dwh_meta_tables
   where dwh_table_name ='dwh_lkp_test'
   and dwh_display_column ='dig_op_testt'

commit 
    
3. Run the Load Data Warehouse - Full Load

Additional Information

See also Data Warehouse (DWH) known issues