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).'
Release : Any
Component : CA PPM DATA WAREHOUSE
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.