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 Data Warehouse job fails with 'Could not remove FK constraint' error

book

Article ID: 220212

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

The Load Data Warehouse job fails when run in full and incremental load mode with the following error message in the bg-dwh.log log file;

ERROR: Could not remove FK constraint dwh_inv_assign_per_facts_fk5 on table dwh_inv_assign_period_facts.  Aborting DWH load.

ERROR: Could not remove FK constraint dwh_inv_assign_per_facts_fk1 on table dwh_inv_assign_period_facts.  Aborting DWH load.

Cause

This error can occur if a user is executing queries directly on the Data Warehouse database whiles the Load Data Warehouse job is running

Environment

Release : 15.9.1, 15.9.2

Component : CLARITY DATA WAREHOUSE

Resolution

Do not use Odata or any other Database tool to query Data Warehouse database whiles the Load Data Warehouse job is running

Check if there are locks or long running queries on Data Warehouse database and clear them