ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Data Warehouse incremental is failing since the upgrade to 15.9.2

book

Article ID: 216701

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

DWH Full load and incremental Load are failing with 

ERROR: ENCOUNTERED EXCEPTION WHILE MERGING INTO DWH_LOOKUP_LOAD XXXXXXXX.
ON CONFLICT DO UPDATE command cannot affect row a second time

Cause

The lookup hidden key value is not unique. 

Environment

Release : 15.9.2

Component : CA PPM SAAS DATA WAREHOUSE

Resolution

We need to ensure that the Hidden Key of the lookup is unique.