DWH_FIN_PLAN_PER_FACTS_LOAD - Load Data Warehouse incremental failure

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

'Load Data Warehouse' incremental jobs fail with the following error occasionally.

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 "DWH_FIN_PLAN_PER_FACTS_LOAD", line 270
ORA-06512: at line 2

Cause

Custom jobs that work on Projects, Teams etc., running in parallel to the incremental 'Load Data Warehouse' job.

Resolution

Set custom jobs that touch Cost Plans, Projects, Teams etc. to be incompatible with the 'Load Data Warehouse' job.