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.

DWH error on custom object: ""there is no unique or exclusion constraint matching..."

book

Article ID: 221628

calendar_today

Updated On:

Products

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

Issue/Introduction

The Load Data Warehouse (DWH) job - full fails with the below 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 the Load Data Warehouse job- Full Load
  3. Now include the object(s) you unchecked back
  4. Run the Load Data Warehouse job - Full Load again

Additional Information

Reference also: