Load Data Warehouse Job fails in incremental mode

Article Id: 143329

Status: Published

Updated On: 21-01-2020 14:49

Products:

Clarity PPM SaaS

Issue/Introduction:

Load Data Warehouse job kept failing the past 2 runs for incremental run. Following error encountered:

[CA Clarity][Oracle JDBC Driver][Oracle]ORA-20100: ENCOUNTERED EXCEPTION WHILE INSERTING INTO DWH_FIN_PLAN_PERIOD_FACTS. SQLERRM : ORA-20100: ENCOUNTERED EXCEPTION WHILE INSERTING INTO DWH_INTERNAL_MD. SQLERRM : ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

ORA-06512: at "MUN1708PDWH.DWH_FIN_PLAN_PER_FACTS_LOAD", line 196

ORA-06512: at line 2

Environment:

Release : 15.5.1

Component : CA PPM SAAS APPLICATION

Resolution:

Run the Load Data Warehouse job in full mode and if successful validate by running a subsequent load data warehouse job in incremental mode.