The SQL Server Analysis Services service crashes during cube processing

Products

• Information Centric Analytics

Issue/Introduction

While running the Risk Fabric cube processing step (16) of the RiskFabric Processing job, or when processing the RiskFabric cube and related dimensions manually, the processing task abruptly fails and errors similar to the following error are written to the msmdsrv.log file on the SQL Server Analysis Services (SSAS) host:

(3/8/2023 10:32:01 PM) Message: OLE DB error: OLE DB or ODBC error: Operation canceled; HY008. (Source: \\?\H:\Program Files\Microsoft SQL Server\MSAS15.MSSQLSERVER\OLAP\Log\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210003)

(3/8/2023 10:32:01 PM) Message: OLE DB error: OLE DB or ODBC error: Operation canceled; HY008. (Source: \\?\H:\Program Files\Microsoft SQL Server\MSAS15.MSSQLSERVER\OLAP\Log\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210003)

(3/8/2023 10:32:02 PM) Message: The file '\\?\H:\Program Files\Microsoft SQL Server\MSAS15.MSSQLSERVER\OLAP\Data\RiskFabric.0.db\Risk Fabric.0.cub\CVEs.0.det\CVEs.0.prt\3.Authentication Event Individual Behavior.Individual Normality Rating.fact.map.hdr' could not be opened. Please check the file for permissions or see if other applications locked it. (Source: \\?\H:\Program Files\Microsoft SQL Server\MSAS15.MSSQLSERVER\OLAP\Log\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210023)

(3/8/2023 10:33:03 PM) Message: An error occurred at critical stage of transaction; we intercepted it, but have to terminate the process. (Source: \\?\H:\Program Files\Microsoft SQL Server\MSAS15.MSSQLSERVER\OLAP\Log\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210058)

Environment

Release : 6.x

Cause

The drive on which the RiskFabric cube database's data files are stored has run out of free space during processing.

Resolution

Note: Broadcom Support will not assist with reconfiguring SSAS. The following procedure is provided as general guidance only; if assistance is required, contact your DBA or Microsoft.

To resolve this issue, either increase free space on the drive hosting the cube data files or move the data files to a new drive. To move the files, follow this general procedure:

1. Detach the cube database per instructions from Microsoft documented here:
   https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/attach-and-detach-analysis-services-databases?view=asallproducts-allversions
2. Update the SSAS server configuration settings for the database files in the msmdsrv.ini file on the SSAS server host to reflect the new location of the cube database data, backup, temp, and log files as needed:

   <ConfigurationSettings>
     <DataDir></DataDir>
     <LogDir></LogDir>
     <BackupDir></BackupDir>
     ...
     <TempDir></TempDir>

3. Copy the database folder (RiskFabric.0.db) to the new path specified in the 
4. Attach the database per the procedure in the guide provided by Microsoft and referenced in step 1 above