OLE DB or ODBC error during RiskFabric cube processing

Products

• Information Centric Analytics

Issue/Introduction

The RiskFabric Processing job fails on step 16 (RiskFabric cube processing) and the following error is logged in the SQL Server Agent history:

<Error ErrorCode="3238068224" Description="The following system error occurred:  The user name or password is incorrect. " Source="Microsoft Analysis Services" HelpFile="" />
<Error ErrorCode="3239182436" Description="Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'RiskFabric', Name of 'RiskFabric'." Source="Microsoft Analysis Services" HelpFile="" />

Other error messages follow, referencing attributes and dimensions that failed to process. These errors are cascading errors triggered by the initial error above.

In addition to this error, if the RiskFabric cube has not been processed post-installation, job steps 17, 18, 19, 20, and 24 will also fail because the cube cannot be queried. These job steps are:

• Process Risk Models (17)
• Process Collections and Scenarios and Risk Models Measure Groups (18)
• Calculate Risk Scores (19)
• Process Risk Vectors Measure Group (20)
• Update Data Refresh Date (24)

The error messages returned for these job steps may include any of the following:

OLE DB provider "MSOLAP" for linked server "RiskFabric_ASDB" returned message "OLE DB error: OLE DB or ODBC error: The Risk Fabric cube does not exist..".

<Error ErrorCode="3239313431" Description="Errors in the metadata manager. The process type specified for the <name> dimension is not valid since it is not processed." Source="Microsoft Analysis Services" HelpFile="" />

ErrorDesc=Error Msg: An error occurred while preparing the query "SELECT NON EMPTY{<MDX query> FROM[Risk Fabric]))))" for execution against OLE DB provider "MSOLAP" for linked server "RiskFabric_ASDB".

Environment

Release : 6.5.4

Component : RiskFabric Processing

Cause

The impersonation information used by SQL Server Analysis Services (SSAS) to connect to the RiskFabric database hosted on the SQL Server (MSSQL) database engine is incorrect.

Resolution

To enable SSAS to connect to the RiskFabric database during cube processing, follow this procedure:

1. Open SQL Server Management Studio (SSMS) while logged-in to Windows using a local admin account that has also been assigned the sysadmin role in SQL Server (e.g., the ICA service account)
2. Connect to the Analysis Services server hosting the RiskFabric cube
3. In Object Explorer, navigate to Databases > RiskFabric > Data Sources
4. Right-click the RiskFabric data source and select Properties
5. In the Data Source Properties - RiskFabric window under Security Settings, ensure Impersonation Info is set to Default
   1. If it's not, edit this setting and select the option Inherit
   2. Click the OK button to close the Impersonation Information window
6. Click the OK button to close the Data Source Properties - RiskFabric window
7. In Object Explorer, navigate to Databases
8. Right-click the RiskFabric database and select Properties
9. In the Database Properties - RiskFabric window under Security Settings, edit the setting Data Source Impersonation Info
10. In the Impersonation Information window, select the impersonation option Use a specific Windows user name and password and enter the credentials of the ICA service account that has been assigned the sysadmin role in SQL Server
11. Click the OK button to save the credential and close the Impersonation Information window
12. Click the OK button to close the Database Properties - RiskFabric window