Load Data Warehouse - Duplicate Key

Document ID : KB000096835
Last Modified Date : 12/06/2018
Show Technical Document Details
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).'
CA PPM 15.3 SaaS (Patch 02)
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.
Run the full load data warehouse job.