search cancel

The incremental Load DWH fails after the 15.9.3 upgrade

book

Article ID: 229624

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

The Incremental Load DWH consistently fails after the 15.9.3 upgrade

no Records to Process? - An error occurred executing this job entry : Couldn't execute SQL: DO $$BEGIN    CALL DWH_GATHER_TABLE_STATS_SP( 'DWH_CMN_PERIOD');    CALL DWH_GATHER_TABLE_STATS_SP( 'DWH_FIN_BENEFIT_PLAN');    CALL DWH_GATHER_TABLE_STATS_SP( 'DWH_FIN_PLAN');    CALL DWH_GATHER_TABLE_STATS_SP( 'DWH_INV_ASSIGNMENT');    CALL DWH_GATHER_TABLE_STATS_SP( 'DWH_INV_INVESTMENT');    CALL DWH_GATHER_TABLE_STATS_SP( 'DWH_INV_TASK');    CALL DWH_GATHER_TABLE_STATS_SP( 'DWH_INV_TEAM');    CALL DWH_GATHER_TABLE_STATS_SP( 'DWH_RES_RESOURCE');    CALL DWH_GATHER_TABLE_STATS_SP( 'DWH_TME_SHEET');    CALL DWH_GATHER_TABLE_STATS_SP( 'DWH_TME_ENTRY');    CALL DWH_GATHER_TABLE_STATS_SP( 'DWH_TME_PERIOD');    UPDATE DWH_CFG_AUDIT SET DW_LOAD_START_DATE = (SELECT LOCALTIMESTAMP FROM DUAL) WHERE TABLE_NAME = 'DWH_INV_TASK_HIERARCHY';    CALL DWH_INV_TASK_HIERARCHY_SP();    UPDATE DWH_CFG_AUDIT SET DW_UPDATED_DATE = (SELECT DWH_DIM_START_DATE FROM DWH_CFG_SETTINGS),

Environment

Release : 15.9.2

Component : Postgres specific DWH and GCP post db refresh or an upgrade

Resolution

Please open a support case for assistance on this issue.