Database and cube creation failure in Analysis Services
search cancel

Database and cube creation failure in Analysis Services


Article ID: 249958


Updated On:


Information Centric Analytics


When installing Information Centric Analytics (ICA), the installation logs an error when attempting to create the OLAP database and cube in the Microsoft SQL Server Analysis Services (SSAS) instance specified in the Symantec ICA Installation Wizard. The error message is logged as follows: 

Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Either the user, '<domain>\<account>', does not have access to the 'RiskFabric' database, or the database does not exist.
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.Discover(String requestType, String requestNamespace, IDictionary restrictions, InlineErrorHandlingType inlineErrorHandling)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet(String schemaName, String schemaNamespace, IDictionary adomdRestrictions, Boolean throwOnInlineErrors)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet(String schemaName, String schemaNamespace, AdomdRestrictionCollection restrictions, Boolean throwOnInlineErrors)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet(String schemaName, AdomdRestrictionCollection restrictions)
   at BayDynamics.DatabaseUtilities.AnalysisServices.DatabaseServices.XmlaDocumentFactory.FromConnection(String connectionString, String database)
   at BayDynamics.DatabaseUtilities.AnalysisServices.DatabaseServices.SsasDatabaseContext.Connect(DbConnectionStringBuilder builder)
   at RiskFabric.Installer.Services.InstallServices.InstallSteps.SsasSteps.CreateSsasDatasource.Install(InstallConfig config)
   at RiskFabric.Installer.Services.InstallServices.InstallStepRunner.Run(IInstallStep step, InstallConfig config)
Error - Analysis Services - Create Database
Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Cannot set StorageEngineMode property of database 'RiskFabric' to 'Traditional' because Analysis Services is in Tabular mode.
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider.ExecuteAny(ICommandContentProvider contentProvider, AdomdPropertyCollection commandProperties, IDataParameterCollection parameters)
   at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteNonQuery()
   at BayDynamics.DatabaseUtilities.AnalysisServices.AnalysisServicesCommandService.Execute(String connectionString, String xmla)
   at RiskFabric.Installer.Services.InstallServices.InstallStepRunner.Run(IInstallStep step, InstallConfig config)

Post-installation, the following error is displayed when attempting to load the Data Loss Prevention dashboard in the ICA console, or while loading any other MDX-based dashboard widget:

An error has occurred while executing MDX Query.

The SQL Server Agent history log also captures the following error while processing step 19 (Calculate Risk Scores) of the RiskFabric Processing job:

Error Msg: Cannot initialize the data source object of OLE DB provider "MSOLAP" for linked server "RiskFabric_ASDB". Line  Number: 2| Error Msg: Cannot initialize the data source object of OLE DB provider "MSOLAP" for linked server "RiskFabric_ASDB".

An error similar to the following will also be logged on steps 16, 18, and 20:

<Exception xmlns="urn:schemas-microsoft-com:xml-analysis:exception" /><Messages xmlns="urn:schemas-microsoft-com:xml-analysis:exception"><Error ErrorCode="3239313412" Description="Either the dimension with the ID of 'Exception Risk Classification' does not exist in the database with the ID of 'RiskFabric', or the user does not have permissions to access the object." Source="Microsoft Analysis Services" HelpFile="" /></Messages>

NOTE: The dimension named in the second error message may vary. This error will appear on the following job steps:

  • Risk Fabric cube processing (16)
  • Process Collections and Scenarios and Risk Models Measure Groups (18)
  • Process Risk Vectors Measure Group (20)


Release : 6.x

Component : Microsoft SQL Analysis Server


The Analysis server instance is installed in Tabular mode. Per the Microsoft SQL Server Analysis Services Settings for Symantec ICA section of the Symantec ICA Administrator Guide, SSAS must be installed in multidimensional mode. To confirm the mode in your environment, follow this procedure:

  1. Using SQL Server Management Studio (SSMS), connect to the Analysis Services server hosting the RiskFabric OLAP cube
  2. In Object Explorer, right-click the SSAS hostname and select Properties
    The Analysis Server Properties window will open
  3. In the Analysis Server Properties window, note the Server mode


To change the mode of the SSAS instance hosting the RiskFabric OLAP cube, uninstall the existing instance and re-install SSAS in multidimensional mode. Other methods for changing the mode without removing the installed instance exist but are not supported by Broadcom.

Before uninstalling SSAS, uninstall ICA. For guidance uninstalling ICA, refer to the Broadcom knowledgebase article Manually uninstalling Information Centric Analytics. Reinstall ICA after SSAS has been reinstalled in multidimensional mode.