Load DWH error: relation "dwh_project_v" does not exist

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

While doing some maintenance on currently used/unused custom attributes and objects, a few attributes and objects have been deleted.

Since the cleanup activity was performed, the Load DWH job has been failing with the following error:

org.postgresql.util.PSQLException: ERROR: relation "dwh_project_v" does not exist

What could be the cause?

Environment

Any supported Clarity release

Cause

The  dwh_project_v view did not get recreated automatically after the attribute deletion

Resolution

Follow the steps below to force the dwh_project_v view recreation

• Go to Classic PPM > Studio > Objects
• On the attributes tab, edit any custom field
• If the Include in the Data Warehouse checkbox is on, uncheck it. If unchecked, then check it and save. This should recreate the view
• Run a full Load DWH job afterwards