Load Data Warehouse Job fails in incremental mode

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.