ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Load DWH job error: "ORA-30926..." on table DWH_INV_TASK


Article ID: 193039


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


When running the Load Data Warehouse (DWH) job, in the logs you see the below error:

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


A project task is referenced on the baseline details of a different project.

The prj_baseline_details table holds a reference of a project task on two different project baselines: Its project and a non-related project   


Any Clarity release


Contact Broadcom support for assistance

Additional Information

See also: Data Warehouse (DWH) known issues