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.

Load DWH Full and Incremental Fails With Error Missing View

book

Article ID: 237400

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

The BG DWH logs show the view (dwh_project_v) is missing.
In the database it is not under the views.

 

Resolution

As many objects could be missing, it is best practice to restore/refresh from backup / PROD
and rebuild from the stock DWH schema.