The DWH Incremental Job fails indicating there is no unique or exclusion constraint matching the ON CONFLICT specification.
Steps to Reproduce:
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.
Release : 16.0.2, 16.0.3
Workaround: Run the Full Load DWH.
This is fixed in 16.1.0