Load Data Warehouse job failing in TEST environment
Article ID: 129152
CLARITY PPM FOR ITGCLARITY PPM FEDERALClarity PPM SaaS - ApplicationClarity PPM On Premise
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
Release: Component: PPMDWH
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.