Invalid object name 'DWH_CFG_LOG' - Data Warehouse job failure

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

A non-production system is refreshed from the Production system. After this, when running the 'Load Data Warehouse' or the 'Load Data Warehouse Access Rights' job, the following error message is logged, in the bg-dwh.log. The jobs fail.

Invalid object name 'DWH_CFG_LOG'

Environment

SQL Server DB

Cause

The DB User account used to login to the DWH DB, has a different DB marked as default. For example, if 'ppm_dwh' is the user and the DWH DB is named 'ppm_dwh', then the default DB pointer is set for 'dbo'.

Resolution

The DB user account used to login to the DWH DB, should have the default DB pointing to the DWH DB. For example, 'ppm_dwh' user should have default DB as 'ppm_dwh' DB.