Load Data Warehouse Incremental fails with duplicate key if the Incremental job before has failed

book

Article ID: 208273

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS STARTER PACK-CLARITY PPM

Issue/Introduction

Our Load Data Warehouse - Incremental has failed because of a field. We corrected the issue and ran Incremental, but it failed with duplicates. Why does this happen?

2021/02/01 08:54:27 -  - Error for table 'DWH_INV_TASK_PERIOD_FACTS' - Error Number 1505 'The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'ppm_dwh.DWH_INV_TASK_PERIOD_FACTS' and the index name 'DWH_INV_TASK_PER_FACTS_U1'. The duplicate key value is (7625096, 2007338).'

Environment

Release : Any

Component : CA PPM DATA WAREHOUSE

Resolution

Always run a Full Load after an Incremental Load has failed. This is a requirement due to the current Load Data Warehouse job design. If Full Load hasn't run, an Incremental ran after a failure may fail with duplicates.