Database and cube creation failure in Analysis Services
search cancel

Database and cube creation failure in Analysis Services

book

Article ID: 249958

calendar_today

Updated On:

Products

Information Centric Analytics

Issue/Introduction

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)

Environment

Release : 6.x

Component : Microsoft SQL Analysis Server

Cause

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

Resolution

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.

Powered by Wolken Software