The SQL Server Analysis Services service crashes during cube processing
search cancel

The SQL Server Analysis Services service crashes during cube processing

book

Article ID: 261644

calendar_today

Updated On:

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:

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)

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)

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)

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