Load DWH job fails with ORA-30926: unable to get a stable set of rows on a custom lookup UNCHECKED from DWH

book

Article ID: 110882

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

The Load Data Warehouse intermittently fails with error as below:
[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

How to remedy this?

Environment

Release: MSPPPM99000-15.5-PPM-Core License-MSP
Component: Clarity Data Warehouse

Resolution

Upon checking we see that the lookup and attribute for this lookup are actually unchecked from Data Warehouse and not in DWH_META_COLUMNS. However the reference remains in DWH_META_TABLES, and has to be removed from there.

  1. Check to ensure you are facing the same issue, confirm column is not in DWH_META_COLUMNS and it's still in DWH_META_TABLES on PPM database after running a Full Load.
  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 Load Data Warehouse - Full Load