DWH error on custom object

book

Article ID: 221628

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise STARTER PACK-CLARITY PPM

Issue/Introduction

We run Load Data Warehouse - Full and hit the error message on a custom object:

ERROR: ENCOUNTERED EXCEPTION WHILE MERGING INTO DWH_ODF_TEST. there is no unique or exclusion constraint matching the ON CONFLICT specification
  Where: PL/pgSQL function inline_code_block line 24 at RAISE

Environment

Release : Any

Component : CLARITY DATA WAREHOUSE

Resolution

1. Uncheck the object (and any of its subobjects if needed) from Data Warehouse

2. Run Load Data Warehouse - Full Load

3. Now include the object(s) you unchecked back

4. Run Load Data Warehouse - Full Load again