OLE DB error: Username or password is incorrect
search cancel

OLE DB error: Username or password is incorrect

book

Article ID: 247167

calendar_today

Updated On:

Products

Information Centric Analytics

Issue/Introduction

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:

  • 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.x

Component : RiskFabric Processing, RiskFabric Intraday Processing

Cause

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:

  • The ICA service account password has expired, rotated, or otherwise been reset
  • The RiskFabric OLAP cube's data source connection string is pointing at an incorrect instance of the RiskFabric relational database
  • The failing RiskFabric Processing or RiskFabric Intraday Processing job step is not pointed at the correct RiskFabric OLAP cube host server

Resolution

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

  1. Open SQL Server Management Studio (SSMS)
  2. Connect to the Analysis Services server hosting the RiskFabric OLAP cube
  3. In Object Explorer, navigate to Databases > RiskFabric > Data Sources
  4. Right-click the RiskFabric data source and select Properties
    The Data Source Properties - RiskFabric window opens
  5. In the Data Source Properties - RiskFabric window under Security Settings, ensure Impersonation Info is set to Default
    1. If it's not, click the Edit button
      The Impersonation Information window opens
    2. Select the option Inherit
    3. 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 OLAP database and select Properties
    The Database Properties - RiskFabric window opens
  9. In the Database Properties - RiskFabric window under Security Settings, edit the setting Data Source Impersonation Info
    The Impersonation Information window opens
  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

If, after updating the impersonation credential, the processing failure persists, first confirm the correct credential has been entered by following this procedure:

  1. Open SSMS
  2. Connect to the Analysis Services server hosting the RiskFabric OLAP cube
  3. In Object Explorer, navigate to Databases > RiskFabric > Dimensions
  4. Right-click the Action Plan dimension and select Process
    The Process Dimension - Action Plan window opens
  5. Click the OK button to initiate processing of the Action Plan dimension

If 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:

  1. Open SSMS
  2. Connect to the Database Engine hosting the RiskFabric relational database
  3. In Object Explorer, navigate to SQL Server Agent > Jobs
  4. Right-click the RiskFabric Processing job (or RiskFabric Intraday Processing job, depending upon which job is failing) and select Properties
    The Job Properties - RiskFabric Processing window opens
  5. Click on the Steps page
  6. Select step 16 and click the Edit button
    The Job Step Properties - Risk Fabric cube processing window opens
  7. Verify the Server specified above the Command is the correct SSAS server hosting the RiskFabric OLAP cube
    1. If the server name or IP address is incorrect, correct it and click the OK button to close the Job Step Properties - Risk Fabric cube processing window, then click the OK button to close the Job Properties - RiskFabric Processing window
    2. If the server name or IP address is correct, contact Broadcom support for assistance