Cube processing failure due to locked account

Products

• Information Centric Analytics

Issue/Introduction

The Risk Fabric cube processing step of the nightly RiskFabric Processing job fails and logs the following error message:

<Error ErrorCode="3238068224" Description="The following system error occurred:  The referenced account is currently locked out and may not be logged on to. " 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="" />

Environment

Release : 6.x

Component : RiskFabric Processing

Resolution

Unlock the ICA service account with the assistance of your Active Directory (AD) administrator and follow these steps:

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
4. Right-click RiskFabric and select Properties
   The Database Properties window opens
5. In the Database Properties window under the Security Settings heading, edit the Data Source Impersonation Info
   The Impersonation Information window opens
6. In the Impersonation Information window, update the Password
7. Click the OK button to save the password and close the Impersonation Information window
8. Click the OK button to close the Database Properties window
9. In Object Explorer, navigate to Databases > RiskFabric > Data Sources
10. Right-click RiskFabric and select Properties
    The Data Source Properties window opens
11. In the Data Source Properties window under the Security Settings heading, edit the Impersonation Info
    The Impersonation Information window opens
12. In the Impersonation Information window, select the Inherit impersonation option
13. Click the OK button to close the Impersonation Information window
14. Restart the SQL Server Analysis Services (msmdsrv) service using any of the following methods:
    1. In Object Explorer, right-click the SSAS hostname and select Restart
    2. From the Windows menu, open Services (services.msc), right-click the service SQL Server Analysis Services (<Instance-Name>), and select Restart
    3. From a command prompt run as an administrator, execute the following commands:

       net stop MSSQLServerOLAPService[$instancename]

       net start MSSQLServerOLAPService[$instancename]