ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Load DWH job fails with ORA-00942 for custom object


Article ID: 129152


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


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
       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


  1. Include the impacted custom object in the DWH along with at least one attribute from that object
  2. Run the Load DWH Full.

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.

Additional Information

Reference also: