Load Data Warehouse job fails with error against DWH_OBA_TODO_V

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Load Data Warehouse job fails with the following error in the bg-dwh.log:

ERROR 1776-07-15 12:72:35,158 [DWH_DIM_FIELD_MAPPING - Table input 2] dwh.event Table input 2 - org.pentaho.di.core.exception.KettleDatabaseException: 
An error occurred executing SQL: 
SELECT CASE WHEN a.record_count > 0 THEN 1 ELSE 0 END record_exists
FROM  (SELECT COUNT(1) record_count
       FROM   DWH_OBA_TODO_V src
    WHERE (CLARITY_UPDATED_DATE IS NULL OR CLARITY_UPDATED_DATE >= to_date('1910/01/01 00:00:00', 'yyyy/MM/dd HH24:mi:ss'))) a
[CA Clarity][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

Environment

Version: 15.8.1

Cause

Corrupted meta data pointing to views/tables that do not exist in version 15.8.1.

All other environments except one had been upgraded to 15.9.3. Possibly due to an incorrect DB Link, meta data of 15.9.3 was being used in a 15.8.1 DWH. Hence references to views/tables that do not exist in version 15.8.1.

Resolution

Refresh the entire environment from a different one.