The RiskFabric Processing job is failing on step 16 (RiskFabric cube processing) and the following error message is logged in the SQL Server Agent job 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.
The same failure and error messages may also occur while processing steps 13 (Process DIM Measures and Dimensions) and 15 (Process Event Scenario Measures and Dimensions) of the RiskFabric Intraday Processing job.
In addition to this error, if the RiskFabric cube has not been processed post-installation, job steps 17, 18, 19, 20, and 24 of the nightly job will also fail because the unprocessed cube cannot be queried. These job steps are:
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".
Release : 6.x
Component : RiskFabric Processing, RiskFabric Intraday Processing
The impersonation information used by SQL Server Analysis Services (SSAS) to connect to the RiskFabric
relational database hosted on the SQL Server (MSSQL) database engine is incorrect. This can be due to any of the following reason:
RiskFabric
OLAP cube's data source connection string is pointing at an incorrect instance of the RiskFabric
relational databaseRiskFabric
OLAP cube host serverTo enable SSAS to connect to the RiskFabric
relational database during cube processing, follow this procedure:
RiskFabric
OLAP cubesysadmin
role in SQL ServerIf, after updating the impersonation credential, the processing failure persists, first confirm the correct credential has been entered by following this procedure:
RiskFabric
OLAP cubeIf processing completed successfully, this confirmed the newly entered impersonation credentials are correct.
If processing failed, first follow the procedure in the Resolution section of the article OLE DB data source connection error during Risk Fabric cube processing job step to confirm the cube's data source connection string is pointed at the correct server and RiskFabric
relational database. If the connection string is correct, follow this procedure:
RiskFabric
relational databaseRiskFabric
OLAP cube