CA PPM: Load Data Warehouse incremental job fails with duplicate key in DWH_INV_PERIOD_FACTS

Document ID : KB000096835
Last Modified Date : 12/06/2018
Show Technical Document Details
Issue:

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. 

Example:
"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"

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.

select period_KEY, period_KEY, COUNT(*) 
from DWH_INV_PERIOD_FACTS
group by period_KEY,period_KEY
having COUNT(*) > 1

Resolution:
Run the full load data warehouse job.
Additional Information:

This is reported as DE37008 and is resolved in 15.4+