Incremental Load Data Warehouse Job Fails On Table DWH_FIN_PLAN_PERIOD_FACTS

Products

• Clarity PPM SaaS

Issue/Introduction

Load Data Warehouse job kept failing the past 2 runs for incremental run. The following errors can be found in the BG DWH log:

--Oracle
[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

OR

--MSSQL
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).'

 

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.