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.

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

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, 16.0.0

Component : CLARITY DATA WAREHOUSE

Resolution

Workaround: Run the jobs again to completion

This is DE62366, fixed in 16.0.1

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)