Load Data Warehouse - Duplicate Key

Document ID : KB000096835
Last Modified Date : 12/06/2018
Show Technical Document Details
Issue:
Hello, When running Load data warehouse - incremental - Monday thru Friday we are receiving the following error in the bg-dwh.log file about a duplicate key. 

Error for table 'DWH_INV_PERIOD_FACTS' - Error Number 2601 'Cannot insert duplicate key row in object 'ppm_dwh.DWH_INV_PERIOD_FACTS' with unique index 'DWH_INV_PER_FACTS_U1'. The duplicate key value is (5084796, 2006589).'
Environment:
CA PPM 15.3 SaaS (Patch 02)
Cause:
The incremental job does not create any records it just merges updates with the existing dwh records. So when a duplicate key occurs, the incremental will repeatedly and consistently fail until the full load data warehouse job is run.
Resolution:
Run the full load data warehouse job.