Load DWH error DISABLE CONSTRAINT dwh_fin_plan_per_facts_fk3

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)