Unable to create ICA Database in SQL Analysis Server during installation.
search cancel

Unable to create ICA Database in SQL Analysis Server during installation.

book

Article ID: 249958

calendar_today

Updated On:

Products

Information Centric Analytics

Issue/Introduction

When installing ICA application, the installer fails when creating DB in SQL Analysis Server. The error message appear in the install logs as 

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)

Environment

Release : 6.x

Component : Microsoft SQL Analysis Server

Cause

The Analysis server instance is installed in Tabular mode. To confirm:

  1. Using SQL Server Management Studio, connect to the Analysis Services server.
  2. In Object Explorer, right-click the SSAS hostname and select Properties.
  3. In the Analysis Server Properties window, note the Server mode:

Resolution

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