Load DWH jobs Fail with [SQLServer]An error occurred during decryption error

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

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.

Environment

Release : 15.8.1

Component : CA PPM DATA WAREHOUSE

Cause

[CA Clarity][SQLServer JDBC Driver][SQLServer]An error occurred during decryption.

Resolution

Recreate the dblink for DWH