Load DWH Job fail with error on table dwh_cmn_scenario_facts

book

Article ID: 209109

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

DWH job fails with the following error message in the bg-dwh log

ERROR: Could not remove FK constraint dwh_cmn_scenario_facts_fk1 on table dwh_cmn_scenario_facts.  Aborting DWH load.
  Where: PL/pgSQL function dwh_disable_constraints_sp(character varying,character varying) line 66 at RAISE
SQL statement "CALL DWH_DISABLE_CONSTRAINTS_SP('ALL_DWH')"
PL/pgSQL function dwh_cfg_pre_config_sp(character varying) line 16 at CALL

 

Cause

The Update Aggregated Data job is running at the same time as the Load Dataware House Job.

Resolution

Set the Update Aggregated Data job as incompatible with the Load Data Warehouse Job.

1. Go to Administration - Data Administration - Reports & Jobs
2. In Job Definition Name - select the Load Data Warehouse
3. Click the incompatible Jobs tab
4. Search for Update Aggregated Data & add it to the list
5. Click on Return