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

book

Article ID: 129152

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

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

Environment

Release: Any
Component: Clarity Data Warehouse

Resolution

  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: