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

book

Article ID: 125474

calendar_today

Updated On:

Products

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).]

Environment

Release:
Component: PPMDWH

Resolution

DE46399, Fixed in 15.6