Load Data Warehouse job fails - Missing table DWH_CMN_ERROR_MESSAGE

Products

• Clarity PPM On Premise

Issue/Introduction

• Load Data Warehouse job fails
• Error in bg-dwh.log is as follows:
  • ERROR 1947-09-23 05:00:10,350 [Thread-4584] dwh.event (clarity:none:none:none) () Pre_execution_config_step_orcl - An error occurred executing this job entry : 
Couldn't execute SQL: BEGIN
    DWH_CFG_POP_HISTORY_SP;
    EXECUTE IMMEDIATE 'TRUNCATE TABLE DWH_CMN_ERROR_MESSAGE';
 DWH_CFG_PRE_CONFIG_SP(P_DBLINK => 'PPMDBLINK', P_FULL_RELOAD => 'Y');
 DWH_CFG_RECOMPILE_SP;
    UPDATE DWH_CFG_SETTINGS SET ENABLE_PLAN_ACTUALS = 0.0;
END;
ORA-00942: table or view does not exist
ORA-06512: at "PPM_DWH.DWH_CFG_PRE_CONFIG_SP", line 69
ORA-06512: at line 4

Resolution

Reimport the DWH DB from seeded dump file. This dump file can be found in the Clarity ISO media.