search cancel

Load DWH fails with The server principal "ppm_dwh" is not able to access the database

book

Article ID: 228786

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Load Data Warehouse - Full and Incremental and Load Data Warehouse Access Rights fail with error:

2021/11/01 10:52:41 - ClarityDB - isOracle? - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : An error occurred executing this job entry :
2021/11/01 10:52:41 - ClarityDB - isOracle? - Couldn't execute SQL: DECLARE @V_DBNAME VARCHAR(100);    
2021/11/01 10:52:41 - ClarityDB - isOracle? - SELECT @V_DBNAME = DB_NAME();
2021/11/01 10:52:41 - ClarityDB - isOracle? -
2021/11/01 10:52:41 - ClarityDB - isOracle? - EXEC ('ALTER DATABASE ' + @V_DBNAME  + ' SET RECOVERY BULK_LOGGED;');
2021/11/01 10:52:41 - ClarityDB - isOracle? - EXEC CMN_SAVEDROP_CREATE_MVIEWS_SP 'DWH_FIN_BENEFIT_PERIOD_FACTS', 'SAVE_DROP';
2021/11/01 10:52:41 - ClarityDB - isOracle? -
2021/11/01 10:52:41 - ClarityDB - isOracle? - [CA Clarity][SQLServer JDBC Driver][SQLServer]The server principal "ppm_dwh" is not able to access the database "TEST" under the current security context.

The access rights are correct on the SQL Server database

Environment

Release : Any

Component : CLARITY DATA WAREHOUSE

Resolution

  • The issue is caused by a customization, a trigger inserting audit data to a separate database schema
  • Remove all customizations on the DWH database, they are not supported and could lead to any kinds of issue