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

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

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

Environment

Release : Any

Resolution

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:

• Load DWH job failures - troubleshooting
• Data Warehouse (DWH) known issues
• Load DWH Full - When to run to prevent failures