Load DWH job fails on missing Materialized View
search cancel

Load DWH job fails on missing Materialized View

book

Article ID: 368498

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Load Data Warehouse job fails repeatedly with error:

2024/05/20 08:40:10.189 | Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'DWH_X_INV_TEAM_PER_FACTS_MV'.

Note the MV (Materialized view) name may vary

Cause

The Materialized view is no longer present in the DWH database

The DWH job drops and recreates some views. This issue happens when the view was not recreated. It can occur sometimes when there have been DWH job interruptions, server reboots etc.

Resolution

  1. Connect to another Clarity environment
  2. Get the DDL for the MV that is mentioned in the log
  3. Create the same view on the DWH database in the affected environment
  4. Run a Full Load of Data Warehouse job
Powered by Wolken Software