DWH Failure After Database Restore

book

Article ID: 206676

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

The Load Data Warehouse (DW / DWH) full load is failing with the below error since the refresh of prod, dev, test, etc.

 

Couldn't execute SQL: CALL DWH_CFG_POP_HISTORY_SP();

TRUNCATE TABLE DWH_CMN_ERROR_MESSAGE;

CALL DWH_CFG_PRE_CONFIG_SP('Y');

CALL DWH_CFG_FOREIGN_TABLES_SP();

 

ERROR: schema "*DB_HOST" does not exist

  Where: importing foreign table "crv_sql_curves"

Environment

Release : 15.9

Component : CA PPM SAAS APPLICATION

Resolution

Recreate the DBLink

Additional Information

Install and Configure the Data Warehouse