DWH failing related to ON CONFLICT specification
search cancel

DWH failing related to ON CONFLICT specification

book

Article ID: 245918

calendar_today

Updated On:

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