Load Data Warehouse job fails-column does not exist

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

The Load Data Warehouse is failing. 

Error in bg-dwh.log file 

ERROR: ENCOUNTERED EXCEPTION WHILE MERGING INTO DWH_INV_INVESTMENT. column "<name>" does not exist

Error in app-ca.log file

Error inserting/updating attribute <attribute_name> object inv message is com.niku.union.persistence.PersistenceException: SQL error code: 0 Error message: ERROR: current transaction is aborted, commands ignored until end of transaction block Executed:

Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "<name>"

Cause

A query for a lookup attribute on the investment object is not formatted correctly.

Resolution

The app-ca.log file will also include the incorrect query and the position causing the error. 

You can use this to find the lookup that needs to be corrected.