DWH Load failure: ERROR: relation "dwh_project_v" does not exist

Products

• Clarity PPM SaaS

Issue/Introduction

Data Warehouse Load job are failing on Dev & Prod environments with Following is the message getting in the logs:

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_existsFROM  (SELECT COUNT(1) record_count       FROM   DWH_PROJECT_V src	   WHERE (LAST_UPDATED_DATE::TIMESTAMP IS NULL OR LAST_UPDATED_DATE::TIMESTAMP >= to_timestamp('1910/01/01 00:00:00', 'yyyy/MM/dd HH24:mi:ss'))) aERROR: relation "dwh_project_v" does not exist  Position: 121	at org.pentaho.di.core.database.Database.openQuery(Database.java:1641)	at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:233)	at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:143)	at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)	at java.base/java.lang.Thread.run(Thread.java:834)Caused by: org.postgresql.util.PSQLException: ERROR: relation "dwh_project_v" does not exist  Position: 121	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2468)	at org.

Environment

Clarity Release 15.9.1

 

Resolution

The problem related to LOOKUP (LOOKUP ID= OPD_PROG_IMP) which was referencing an object (ODF_CA_OPD_PROG_INC ) that was deleted in the system while having dependencies still active in the system.

Object : Project

Attribute ID = opd_prog_inc

Workaround: XOG OUT the lookup and XOG IN with updated valid code,  and unchecking the attribute from Datwarehouse processing.