Load DWH error DISABLE CONSTRAINT dwh_fin_plan_per_facts_fk3

book

Article ID: 222815

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise STARTER PACK-CLARITY PPM

Issue/Introduction

Load Data Warehouse - Full and Incremental fail with DISABLE CONSTRAINT dwh_fin_plan_per_facts_fk3

 

STEPS TO REPRODUCE:

  1. Schedule the Load Data Warehouse to run (Full and Incremental)
  2. On the environment users may be accessing and editing the Cost plans

Expected Results: The Load Data Warehouse - Full and Incremental to run successfully

Actual Results: The jobs fail intermittently with ENCOUNTERED EXCEPTION WHILE TRYING TO DISABLE CONSTRAINT dwh_fin_plan_per_facts_fk3

 

Environment

Release : 15.9.3

Component : CLARITY DATA WAREHOUSE

Resolution

Workaround: Run the jobs again to completion

This is DE62366, in review by Engineering

Additional Information

Note a similar issue was resolved in 15.9.3 for other tables: DWH Full Load Fails with "Could not remove FK constraint error" (broadcom.com)