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
Release : 15.5.1
Component : CA PPM SAAS APPLICATION
Run the Load Data Warehouse job in full mode and if successful validate by running a subsequent load data warehouse job in incremental mode.