DWH incremental job Fails due to duplicate keys in the fact table
Article ID: 125474
Updated On:
Products
CLARITY PPM FOR ITG
CLARITY PPM FEDERAL
Clarity PPM SaaS
Clarity PPM On Premise
Issue/Introduction
When running Load Data Warehouse job in Incremental mode we get below error
2018/12/17 13:06:31 - Error Message Variables.0 - Set variable ERROR_MESSAGE to value [Cannot insert duplicate key row in object 'ppm_dwh.DWH_X_RES_AVAIL_PER_FACTS' with unique index 'DWH_X_RES_AVAIL_PER_FACTS_U1'. The duplicate key value is (5004087, 3006971).]
2018/12/17 13:06:31 - Error Message Variables.0 - Set variable ERROR_MESSAGE to value [Cannot insert duplicate key row in object 'ppm_dwh.DWH_X_RES_AVAIL_PER_FACTS' with unique index 'DWH_X_RES_AVAIL_PER_FACTS_U1'. The duplicate key value is (5004087, 3006971).]
Environment
Release:
Component: PPMDWH
Component: PPMDWH
Resolution
DE46399, Fixed in 15.6
Feedback
Yes
No
Powered by
