Incremental Load DWH failed on "dwh_inv_idea" violates foreign key constraint "dwh_inv_idea_fk1"

book

Article ID: 208216

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

INFO  2020-10-14 05:19:18,370 [Thread-15428720] dwh.event dwh_dim_load_pg - Job execution finished
ERROR 2020-10-14 05:19:18,442 [dwh_etl_interface_dim_pg UUID: 72fa8603-42ac-4e23-bb2b-e6a7617e8a36] dwh.event set variables - oracle - An error occurred executing this job entry : 
Couldn't execute SQL: CALL DWH_ENABLE_CONSTRAINTS_SP(NULL,NULL);

ERROR: ENCOUNTERED EXCEPTION WHILE ENABLING dwh_inv_idea_fk1.  insert or update on table "dwh_inv_idea" violates foreign key constraint "dwh_inv_idea_fk1"
  Where: PL/pgSQL function dwh_enable_constraints_sp(character varying,character varying) line 43 at RAISE

INFO  2020-10-14 05:19:18,478 [Thread-15419554] dwh.event dwh_etl_master - Job execution finished

Environment

Release : 15.8.1

Component : CA PPM SAAS DATA WAREHOUSE

Postgres

Resolution

DE58703 - fix included in 15.9.1