The Load Data Warehouse and Load Data Warehouse access rights jobs are failing with following messages:
Oracle? - An error occurred executing this job entry : Couldn't execute SQL: BEGINMERGE INTO dwh_cfg_object_type s USING (SELECT o.object_key, o.object_code, o.table_name, o.is_investment FROM ppmdblinkdevitcd.ITCD_PPM_DEV.niku.dwh_cfg_object_type o) a ON (s.object_key = a.object_key)WHEN MATCHED THEN UPDATE SET object_code = a.object_code, table_name = a.table_name, is_investment = a.is_investmentWHEN NOT MATCHED THEN INSERT (object_key, object_code, table_name, is_investment) VALUES (a.object_key, a.object_code, a.table_name, a.is_investment);END;[CA Clarity][SQLServer JDBC Driver][SQLServer]An error occurred during decryption.
Release : 15.8.1
Component : CA PPM DATA WAREHOUSE
Recreate the dblink for DWH