Load Data Warehouse job kept failing the past 2 runs for incremental run. The following errors can be found in the BG 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 "DWHDB.DWH_FIN_PLAN_PER_FACTS_LOAD", line 196
ORA-06512: at line 2
2022/03/01 03:12:01 - - Error for table 'DWH_FIN_PLAN_PERIOD_FACTS' - Error Number 1505 'The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'ppm_dwh.DWH_FIN_PLAN_PERIOD_FACTS' and the index name 'DWH_FIN_PLAN_PER_FACTS_U3'. The duplicate key value is (5006005, 5000005).'
Run the Load Data Warehouse job in full mode and if successful validate by running a subsequent load data warehouse job in incremental mode.