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..."


Article ID: 221628


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


The Load Data Warehouse (DWH) job full load 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


Release : Any


  1. Uncheck the object (and any of its subobjects if needed) from the Data Warehouse
  2. Run the Load Data Warehouse job- Full load
  3. Include the object(s) you unchecked back
  4. Run the Load Data Warehouse job - Full load again

Additional Information

Reference also: