Error loading cube definition in the Analyzer

Products

• Information Centric Analytics

Issue/Introduction

The following error message is displayed when attempting to open the Analyzer in the Risk Fabric console:

Your request failed. Click 'OK' to close this window or 'Refresh' to refresh the page.
Try again or contact the site administrator.

Error ID: <ID>

Superimposed over the error message is a progress indicator displaying the message Loading Cube Definition...

Environment

Version : 6.x

Component : Analyzer

Cause

The SQL Server Analysis Services (SSAS) service is not running, or the cube's metadata is corrupted.

Resolution

If the SSAS service is not running on the server hosting the RiskFabric OLAP cube, start the service by running a command prompt as an administrator and executing the following command:

net start MSSQLServerOLAPService

NOTE: If the RiskFabric OLAP cube has been installed in a named instance of SSAS, append the instance name in this manner:

net start MSSQLServerOLAPService$<instance-name>

If the SSAS service is running, check for cube corruption by following these steps:

1. Open SQL Server Management Studio (SSMS)
2. Connect to the Database Engine hosting the RiskFabric relational database
3. From the File menu, select New > Query with Current Connection
   A new query editor window opens
4. Copy the following query and paste it in the new query editor window:

   SELECT *
   FROM   OPENQUERY
          (
            [RiskFabric_ASDB],
            '
            SELECT [CATALOG_NAME] AS [Database_Name],
                   [LAST_DATA_UPDATE] AS Last_Process_Date,
                   [BASE_CUBE_NAME] AS Base_Cube_Name
            FROM $system.mdschema_cubes
            WHERE CUBE_SOURCE = 1
            '
          );

5. Execute the query by pressing the F5 key, clicking the Execute button in the SQL Editor toolbar, or selecting Execute from the Query menu

If the query returns an error message similar to the following, the cube is corrupted and must be re-created:

OLE DB provider "MSOLAP" for linked server "RiskFabric_ASDB" returned message "OLE DB error: OLE DB or ODBC error: Errors in the metadata manager. An error occurred when loading the 'Risk Fabric' cube, from the file, '\\?\E:\OLAP\Data\RiskFabric.0.db\Risk Fabric.19980.cub.xml'..".
Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing the query "
 SELECT [CATALOG_NAME] AS [Database_Name],
 [LAST_DATA_UPDATE] AS Last_Process_Date,
 [BASE_CUBE_NAME] AS Base_Cube_Name
 FROM $system.mdschema_cubes
 WHERE CUBE_SOURCE = 1
 " for execution against OLE DB provider "MSOLAP" for linked server "RiskFabric_ASDB".

For assistance with re-creating the cube, contact Broadcom support.

If the query above does not return an error, check the integrity of the RiskFabric OLAP database by following these steps:

1. Open SQL Server Management Studio (SSMS)
2. Connect to the Analysis Services server hosting the RiskFabric OLAP cube
3. From the File menu, select New > Analysis Services XMLA Query
   A new query editor window opens
4. Copy the following query and paste it in the new query editor window:

   <DBCC xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
       <Object>
           <DatabaseID>RiskFabric</DatabaseID>
           <CubeID>Risk Fabric</CubeID>
       </Object>
   </DBCC>

5. Execute the query by pressing the F5 key, clicking the Execute button in the SQL Editor toolbar, or selecting Execute from the Query menu

Contact Broadcom support and provide the output of the XMLA query from the Messages tab.

Additional Information

Microsoft: Start, stop, pause, resume, and restart SQL Server services

Microsoft: Database Consistency Checker (DBCC) for Analysis Services