:Relation does not exist" error on DWH Jobs

book

Article ID: 210729

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

 When attempting to run a Data Warehouse job, an error is received:

ERROR: ENCOUNTERED EXCEPTION WHILE DELETING FROM TABLE DWH_TRD_TREND. relation "dwh_trd_ppm_trends" does not exist

Cause

The DBLink between the Data Warehouse database and the Clarity database is broken

Environment

Release : 15.9

Component : CA PPM SAAS DATA WAREHOUSE

Resolution

The DBLink needs to be recreated to resolve this error.

This documentation provides the steps to perform this task:

https://techdocs.broadcom.com/us/en/ca-enterprise-software/business-management/clarity-project-and-portfolio-management-ppm-on-premise/15-9-1/installing-and-upgrading/install-clarity-ppm/install-and-configure-the-data-warehouse.html

Look for the section: Set Up a Database Link for the Data Warehouse