DWH Incremental Load Failing with Duplicate Key error on DWH_FIN_PLAN_PERIOD_FACTS table

Document ID : KB000117103
Last Modified Date : 08/10/2018
Show Technical Document Details
Issue:
The incremental DWH load job is failing with the following error in the DWH log:

[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 "PPM_DWH.DWH_FIN_PLAN_PER_FACTS_LOAD", line 141
Environment:
CA PPM 15.2, 15.3
Resolution:
This is a known defect (DE41718) which is resolved in 15.4.1 and above.  As a workaround, the FULL Load Data Warehouse job can be run, which will temporarily resolve the issue for some time, however the issue may return.