DWH Failure After Database Restore
Article ID: 206676
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
Feedback
Yes
No
Powered by
