Load Data Warehouse job failing in TEST environment

Article Id: 129152

Status: Published

Updated On: 12-03-2019 06:14

Products:

CLARITY PPM FOR ITG , Clarity PPM On Premise , CLARITY PPM FEDERAL , Clarity PPM SaaS , Clarity PPM SaaS - Application , 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.