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

book

Article ID: 193039

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

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

Cause

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   

Environment

Any Clarity release

Resolution

Contact Broadcom support for assistance

Additional Information

See also: Data Warehouse (DWH) known issues