When running Load Data Warehouse (DWH) job you are getting the below error:
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_TEST_OBJECT_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
Release: Any
Component: Clarity Data Warehouse
Note this error is for a specific custom object, you will need to review the error log to see which object/attribute it is complaining about.