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.

DWH job failure: relation "dwh_odf_my_object_00" does not exist

book

Article ID: 240187

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

After an upgrade to 16.0.1 the Load DWH job fails with:
ERROR: relation "dwh_odf_my_object_00" does not exist

APPEND_COL_SQL - org.pentaho.di.core.exception.KettleStepException: 
Error while running this step!

Couldn't execute SQL: ALTER TABLE DWH_ODF_MY_OBJECT_00 ADD MYATTRIBUTE_KEY NUMERIC(32)

ERROR: relation "dwh_odf_my_object_00" does not exist

 at org.pentaho.di.trans.steps.sql.ExecSQL.processRow(ExecSQL.java:236)
 at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
 at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 
Couldn't execute SQL: ALTER TABLE DWH_ODF_MY_OBJECT_00 ADD MYATTRIBUTE_KEY NUMERIC(32)

Cause

Querying the DWH_META_TABLES table the dwh_odf_my_object_00 entry does not exist.

select * from DWH_META_TABLES where dwh_table_name like 'dwh_odf_my_object_%'

In the affected environment, a similar one exists: dwh_odf_my_object_01

Environment

Clarity 16.0.1

Resolution

1. Uncheck the object from DWH
2. Run the Full Load DWH job
3. Entries will be removed from the DWH_META_TABLES and DWH_META_COLUMNS tables
4. Run a Full Load of DWH job

Additional Information

Please also see:

DWH job fails after including a custom investment with "relation "dwh_odf_test_track_02" does not exist"