Problem with the job "Load Data Warehouse" after delete attributes (DEV environment)

Products

• Clarity PPM SaaS

Issue/Introduction

While performing maintenance on unused attributes that were created for previous needs encountered an error.

Here are the documented steps followed in "Studio objects options":

-  unchecked the “Data warehouse” fields 

-  run a DW sync: everything is working well

-  destroyed the object attributes (6)

-  run again a DW sync: the job crashes with the error (Unexpected error):

ERROR: relation "dwh_project_v" does not exist

  Position: 119

Environment

Release : 16.1.1

Resolution

While running maintenance on the Data Warehouse data base the "dwh_project_v" for some reason did not get recreated automatically as it should, as a result the Load Datawarehouse job failed with error: org.postgresql.util.PSQLException: ERROR: relation "dwh_project_v" does not exist Position: 119

Steps to fix issue:
1- Uncheck/recheck to include any attribute on the Project object in the Datawarehouse. For example we unchecked/rechecked Estimated Effort attribute. This will recreate the dwh_project_v on the database
2- Run the full load DWH job (it may fail on the Jaspersoft Domains and then need to run the Restore Domains job).
3-Lastly run the full load DWH job and should complete.