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
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.
delete from dwh_meta_tables
where dwh_table_name ='dwh_lkp_test'
and dwh_display_column ='dig_op_testt'
See also Data Warehouse (DWH) known issues