load Data Warehouse failed on ERROR: query string argument of EXECUTE is null - PL/pgSQL function dwh_cfg_foreign_tables_sp() line 30

Products

• Clarity PPM SaaS

Issue/Introduction

2022/08/02 02:16:40 - Pre-Execution Config PG - ERROR (version 9.1.0.0-324, build 9.1.0.0-324 from 2020-09-07 05.09.05 by buildguy) : An error occurred executing this job entry : 
2022/08/02 02:16:40 - Pre-Execution Config PG - Couldn't execute SQL: CALL DWH_CFG_LONG_RUN_QUERY_SP();
2022/08/02 02:16:40 - Pre-Execution Config PG - CALL DWH_CFG_POP_HISTORY_SP();
2022/08/02 02:16:40 - Pre-Execution Config PG - CALL DWH_CFG_TRUNCATE_TABLE_SP('DWH_CMN_ERROR_MESSAGE');
2022/08/02 02:16:40 - Pre-Execution Config PG - CALL DWH_CFG_PRE_CONFIG_SP('Y');
2022/08/02 02:16:40 - Pre-Execution Config PG - CALL DWH_CFG_FOREIGN_TABLES_SP();
2022/08/02 02:16:40 - Pre-Execution Config PG - UPDATE DWH_CFG_SETTINGS SET ENABLE_PLAN_ACTUALS = 0;
2022/08/02 02:16:40 - Pre-Execution Config PG - 
2022/08/02 02:16:40 - Pre-Execution Config PG - ERROR: query string argument of EXECUTE is null
2022/08/02 02:16:40 - Pre-Execution Config PG -   Where: PL/pgSQL function dwh_cfg_foreign_tables_sp() line 30 at EXECUTE
2022/08/02 02:16:40 - Pre-Execution Config PG - ERROR (version 9.1.0.0-324, build 9.1.0.0-324 from 2020-09-07 05.09.05 by buildguy) : An error occurred executing this job entry : 
2022/08/02 02:16:40 - Pre-Execution Config PG - Couldn't execute SQL: CALL DWH_CFG_LONG_RUN_QUERY_SP();

Environment

Release : 16.0.2

Component : PPMDWH

Resolution

Restore the Out of the Box Data Warehouse schema and run a Full Load Data Warehouse job