Load Data Warehouse job fails with 'Could not remove FK constraint' error
Article ID: 220212
Updated On:
Products
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.
Environment
Release : 15.9.1, 15.9.2
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
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
Feedback
