DWH incremental job Fails due to duplicate keys in the fact table

Article Id: 125474

Status: Published

Updated On: 10-04-2019 07:55

Products:

CLARITY PPM FOR ITG , Clarity PPM On Premise , CLARITY PPM FEDERAL , Clarity PPM SaaS , Clarity PPM SaaS - Application , Clarity PPM SaaS - Application , 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).]

Environment:

Release:
Component: PPMDWH

Resolution:

DE46399, Fixed in 15.6