search cancel

DE58513 Load Data Warehouse Incremental job fails on DWH_INV_TASK_PERIOD_FACTS

book

Article ID: 202229

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

STEPS TO REPRODUCE:

1. Schedule the Load Data Warehouse Full Load to run once weekly

2. Schedule the Load Data Warehouse Incremental Load to run every day multiple times

Expected Results: The Incremental job to run without an issue

Actual Results: The Incremental job fails with error:

CA Clarity][Oracle JDBC Driver][Oracle]ORA-20100: ENCOUNTERED EXCEPTION WHILE INSERTING INTO DWH_INV_TASK_PERIOD_FACTS_LOAD. SQLERRM : ORA-20100: ENCOUNTERED EXCEPTION WHILE INSERTING INTO DWH_INTERNAL_MD. SQLERRM : ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
2020/10/20 01:40:48 - ClarityDB - isOracle? - ORA-06512: at "PPM_DWH.DWH_INV_TASK_PERIOD_FACTS_LOAD", line 76

Note: this only happens on Incremental Load

Environment

Release : 15.8.1

Component : CA PPM DATA WAREHOUSE

Resolution

This is logged as DE58513(DE55977), fixed in 15.9 and 15.9.1