ICA's database components and cube aren't created during installation
search cancel

ICA's database components and cube aren't created during installation


Article ID: 229717


Updated On:


Information Centric Analytics


When installing Information Centric Analytics (ICA) for the first time, an error similar to the following is logged during installation:

Error - SQL Credentials
System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '5'.
Unclosed quotation mark after the character string ';
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at BayDynamics.DatabaseUtilities.SqlServices.SqlCommandService.Execute(String server, String database, String cmd)
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at RiskFabric.Installer.Services.InstallServices.InstallStepRunner.Run(IInstallStep step, InstallConfig config)
Error Number:102,State:1,Class:15

After installation, the RiskFabric database, jobs, proxies, and credentials are not installed on the SQL Server, and the RiskFabric cube may not be installed on the Analysis Services server.


Release : 6.5.4

Component : Microsoft SQL Server


The password for the account specified in the installer for connecting to the SQL Server and/or SQL Server Analysis Services server contains a special reserved SQL character (e.g., a single quotation mark, or ' ). This is interpreted by SQL Server to indicate it has read the entire password being passed to it, resulting in an authentication failure.


Change the password of the account to be used to install ICA's database components and cube to not include a single quotation mark character ( ' ).