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
The DBLink between the Data Warehouse database and the Clarity database is broken
Release : 15.9
Component : CA PPM SAAS DATA WAREHOUSE
The DBLink needs to be recreated to resolve this error.
This documentation provides the steps to perform this task:
Look for the section: Set Up a Database Link for the Data Warehouse