Installation Blocking Error: Completed: SourceCode.Data.SmartBroker.inject.sql, Success: False

  • 22 October 2021
  • 1 reply
  • 56 views

When I tried to install K2 on-premises I face the following issue:

 

45:39:>> <>c__DisplayClass27_1.<ExecuteRetryableTransactionalScript>b__0: Executing scriptFile...
02:45:43:>> <>c__DisplayClass27_1.<ExecuteRetryableTransactionalScript>b__0: Logged Error: Finished executing scripts. Exception occurred. Successfully rolled back.
02:45:43:>> <>c__DisplayClass27_1.<ExecuteRetryableTransactionalScript>b__0: Logged Error: XML parsing: line 575, character 138, semicolon expected
02:45:43:>> IOHelper.DeleteFile: Delete file: C:Usersk2adminAppDataLocalTempK2 Setup LogSnapshotsSourceCode.Data.SmartBroker.inject.sql
02:45:43:>> IOHelper.DeleteFile: End Delete File. Success: True
02:45:43:>> DBQuery.ExecuteRetryableTransactionalScript: Finished executing scriptFile. Result = False
02:45:43:>> ExecuteSqlScript.Execute: Logged Error: Script execute failed: System.Exception: Script execution exception: System.Data.SqlClient.SqlException (0x80131904): XML parsing: line 575, character 138, semicolon expected
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 SourceCode.Data.ReliableDbConnection.<>c__DisplayClass44_0`1.<ExecuteCommand>b__0(IDbConnection connection)
at SourceCode.Data.ReliableDbConnection.<>c__DisplayClass46_0.<ExecuteDelegate>b__1()
at SourceCode.Data.Logging.IDataLoggingProviderExtensions.<>c__DisplayClass0_0.<ExecuteAction>b__0()
at SourceCode.Data.Logging.IDataLoggingProviderExtensions.ExecuteAction[TResult](IDataLoggingProvider provider, RetryPolicy retryPolicy, Func`1 func)
at SourceCode.Data.Logging.IDataLoggingProviderExtensions.<>c__DisplayClass0_0.<ExecuteAction>b__0()
at SourceCode.Data.Logging.IDataLoggingProviderExtensions.ExecuteAction[TResult](IDataLoggingProvider provider, RetryPolicy retryPolicy, Func`1 func)
at SourceCode.Data.ReliableDbConnection.ExecuteDelegate(Func`2 action)
at SourceCode.Data.ReliableDbConnection.ExecuteCommand[T](ReliableDbCommand command, CommandBehavior behavior)
at SourceCode.Data.Dac.ExecuteNonQuery(CommandType commandType, String commandText, IEnumerable`1 parameters)
at SourceCode.Install.SQL.DBQuery.<>c__DisplayClass27_1.<ExecuteRetryableTransactionalScript>b__0(IReliableDbTransaction transaction)
ClientConnectionId:7b69594a-1ae6-476a-9c71-2e3f83f1203b
Error Number:9411,State:1,Class:16
at SourceCode.Install.Package.Actions.Database.ExecuteSqlScript.Execute()
02:45:43:>> AnalyzableAction.PopulateValidateAndExecute: End execute standard action: DataScript OutputSourceCode.Data.SmartBroker.inject.sql: SourceCode.Data.SmartBroker.inject.sql, result: False
02:45:43:>> Target.Execute: !Completed: SourceCode.Data.SmartBroker.inject.sql, Success: False
02:45:43:>> Component.Execute: Logged Error: Internal error has caused the install to terminate:
02:45:43:>> Executor.ExecuteComponent: Logged Error: Blocking execution exception occurred, install cannot continue:
02:45:43:>> Store.EncryptSensitiveVariables: Start.
02:45:43:>> Store.EncryptSensitiveVariables: Done.
02:45:43:>> DefaultFolderPaths.get_InstallDir: Install dir: C:Program FilesK2
02:45:43:>> Execution.SaveInstallState: Move log to folder: C:Program FilesK2SetupLog
02:45:43:>> Executor.Execute: Logged Error: Unable to complete install, termination exception thrown:
02:45:43:>> Global.ShowAdvancedMsgBox: ==========================================
02:45:43:>> Global.ShowAdvancedMsgBox:
02:45:43:>> Global.ShowAdvancedMsgBox: Type: Failure
02:45:43:>> Global.ShowAdvancedMsgBox: Title: Blocking Error
02:45:43:>> Global.ShowAdvancedMsgBox: Content:

 

Any solution please ?


1 reply

Badge +6

What version of K2 you are trying to install?


Is this a new install or an upgrade?

Reply