Load Data Warehouse job failing in TEST environment

book

Article ID: 129152

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS - Application Clarity PPM On Premise

Issue/Introduction

When running Load Data Warehouse job I am getting below error. Can you please help us resolve it?

ERROR 2019-03-05 19:45:31,866 [DWH_DIM_FIELD_MAPPING - Table input 2] dwh.event Table input 2 - Unexpected error
ERROR 2019-03-05 19:45:31,872 [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_SAP_TS_ACTIVITIES_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

Release:
Component: PPMDWH

Resolution

Based on the error observed you need to include object in SAP_TS_ACTIVITIES (custom) in DWH along with at least 1 attribute from that object and run DWH with Full sync option. Note this error was for specific custom object, you will need to review error log to see which object/attribute it is complaining about.