DWH incremental job Fails due to duplicate keys in the fact table
book
Article ID: 125474
calendar_today
Updated On:
Products
CLARITY PPM FOR ITGCLARITY PPM FEDERALClarity PPM SaaS - ApplicationClarity 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).]