When doing the SQL upgrade we get the following error.
Error: Executing .NET Database Server script ‘Octopus.Core.UpgradeScripts.Script0127FixUpDeploymentProcessRelatedDocuments.cs’
Error: You have many projects and releases, this may take some time
Error: Processed 100 of 1854
Error: Processed 200 of 1854
Error: Processed 300 of 1854
Error: Processed 400 of 1854
Error: Processed 500 of 1854
Error: Processed 600 of 1854
Error: Processed 700 of 1854
Error: Processed 800 of 1854
Error: Processed 900 of 1854
Error: Processed 1000 of 1854
Error: Processed 1100 of 1854
Error: Processed 1200 of 1854
Error: Processed 1300 of 1854
Error: Processed 1400 of 1854
Error: Processed 1500 of 1854
Error: Processed 1600 of 1854
Error: Processed 1700 of 1854
Error: Processed 1800 of 1854
Error: Executing .NET Database Server script ‘Octopus.Core.UpgradeScripts.Script0127MigrateStepPackageReferences.cs’
Error: Converting references to deployment-steps (where the step is assumed to be 1:1 with a package) to use DeploymentActionPackage
Error: Versioning Strategy for project ‘Platform.Reporting.FileProcessor’ could not be migrated, and will have to be reconfigured manually. Could not find deployment action with ID a0263aa8-993d-42f9-99f8-b806397ce354
Error: Processed 100 of 129 projects
Error: Versioning Strategy for project ‘Communication AppServer’ could not be migrated, and will have to be reconfigured manually. Could not find deployment action with ID 3a047f44-45c7-4e64-8225-e3293ed36e3a
Error: Versioning Strategy for project ‘Framework.Foundation’ could not be migrated, and will have to be reconfigured manually. Could not find deployment action with ID a0263aa8-993d-42f9-99f8-b806397ce354
Error: Versioning Strategy for project ‘Product.ReimbursementAccounts.BalanceService’ could not be migrated, and will have to be reconfigured manually. Could not find deployment action with ID a0263aa8-993d-42f9-99f8-b806397ce354
Error: Versioning Strategy for project ‘Platform.Communication’ could not be migrated, and will have to be reconfigured manually. Could not find deployment action with ID 9ce8eb5d-688f-4869-90f0-b1654e5e13cf
Error: Executing .NET Database Server script ‘Octopus.Core.UpgradeScripts.Script0128MoveK8SAccountToSubClass.cs’
Error: Executing TSQL Database Server script ‘Octopus.Core.UpgradeScripts.Script0129 - Release and Event DataVersion.sql’
Error: SQLException has occured in statement #0 of this TSQL script: ‘Octopus.Core.UpgradeScripts.Script0129 - Release and Event DataVersion.sql’; Line: 5; Procedure: ; Error Number: 42029; Excerpt: ‘ALTER TABLE dbo.Event ADD DataVersion timestamp’; Message: An internal error happened while generating a new DBTS for database “OctoDB”. Please retry the operation.
Error: The statement has been terminated.
Error: Error occured when executing scripts, transaction will be rolled back
Error: Upgrade failed due to an unexpected exception:
Error: System.Data.SqlClient.SqlException (0x80131904): An internal error happened while generating a new DBTS for database “OctoDB”. Please retry the operation.
Error: The statement has been terminated.
Error: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) Error: at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) Error: at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) Error: at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() Error: at System.Data.SqlClient.SqlDataReader.get_MetaData() Error: at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) Error: at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) Error: at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource
1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
Error: at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
Error: at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
Error: at DbUp.Support.ScriptExecutor.ExecuteAndLogOutput(IDbCommand command)
Error: at Octopus.Core.Initialization.DatabaseUpgrader.OctopusUpgradeScriptExecutor.<>c__DisplayClass7_0.b__0(Func1 commandFactory) Error: at DbUp.Engine.Transactions.SingleTrasactionStrategy.Execute(Action
1 action)
Error: at Octopus.Core.Initialization.DatabaseUpgrader.OctopusUpgradeScriptExecutor.Execute(SqlScript script, IDictionary`2 variables)
Error: at DbUp.Engine.UpgradeEngine.PerformUpgrade()
Error: ClientConnectionId:aeed8433-4d50-4c5a-a500-1b6e23df1824
Error: Error Number:42029,State:1,Class:16
I understand that it’s a quite outdated version we’re trying to move from. If there’s an upgrade path that’s more incremental I can follow, I’ll take that route, I just haven’t been able to find anything.