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
The Update Aggregated Data job is running at the same time as the Load Dataware House Job.
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