DWH failing related to ON CONFLICT specification

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

The DWH Incremental Job fails indicating there is no unique or exclusion constraint matching the ON CONFLICT specification. 

 

Steps to Reproduce: 

1. Schedule the Incremental Load Data Warehouse to run hourly 

Expected Results: Incremental Load Data Warehouse completes and handles a missing unique constraint. 

 

Actual Results: Incremental Load Data Warehouse fails on missing unique constraint. BG Log shows: ERROR: ENCOUNTERED EXCEPTION WHILE MERGING INTO DWH_CMN_HIERARCHY_NODE. there is no unique or exclusion constraint matching the ON CONFLICT specification Where: PL/pgSQL function inline_code_block line 22 at RAISE.

Environment

Release : 16.0.2, 16.0.3

Resolution

Workaround: Run the Full Load DWH.

This is fixed in 16.1.0