dwh_rdm_roadmap_ln - Load Data Warehouse job fails

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

The Load Data Warehouse job fails with the below error stack in the bg-dwh.log:

ERROR: ENCOUNTERED EXCEPTION WHILE INSERTING INTO DWH_RDM_ROADMAP_LN. insert or update on table "dwh_rdm_roadmap_ln" violates foreign key constraint "dwh_rdm_roadmap_ln_fk1"
  Where: PL/pgSQL function inline_code_block line 24 at RAISE

Environment

Version: 16.1.1

Resolution

Selecting 'English' in the System Options -> Data Warehouse section, against the languages to be loaded into the DWH, solved the issue.