ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Full Load DWH job fails with error "CALL DWH_FIN_PLAN_SUM_FACTS_LOAD();ERROR: Could not remove FK constraint dwh_fin_plan_sum_facts_fk3"

book

Article ID: 226264

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

The Full Load Data Warehouse (DWH) is failing with the error below.

CALL DWH_FIN_PLAN_SUM_FACTS_LOAD();ERROR: Could not remove FK constraint dwh_fin_plan_sum_facts_fk3

Full error message below:

Fin Transactions? - An error occurred executing this job entry : Couldn't execute SQL: CALL DWH_FIN_PLAN_SUM_FACTS_LOAD();ERROR: Could not remove FK constraint dwh_fin_plan_sum_facts_fk3 on table dwh_fin_plan_summary_facts. Aborting DWH load. Where: PL/pgSQL function dwh_disable_constraints_sp(character varying,character varying) line 66 at RAISESQL statement "CALL DWH_DISABLE_CONSTRAINTS_SP('DWH_FIN_PLAN_SUMMARY_FACTS','FK')"PL/pgSQL function dwh_fin_plan_sum_facts_load() line 70 at CALL

Cause

Defect DE62736

Environment

Release : 15.9.3, 16.0

Component : CLARITY DATA WAREHOUSE

Resolution

Fixed in 16.0.1 and also patched in 16.0.0.1

Workaround:

  1. Run the Full Load DWH again and it will be successful.
  2. Schedule runs of the Incremental Load DWH frequently, so the impact is mitigated until a fix is created