Hi Support,
When I am trying to upgrade octopus from 2018.4.0 to 2019.3.1, I got below error
Executing .NET Database Server script ‘Octopus.Core.UpgradeScripts.Script0180BuiltInFeedMigration.cs’
Moving the existing built in packages feed into the Default space
Finding a suitable location for temporary package storage, trying for F:\Octopus\Packages/…/PackagesTemp
Found parent directory F:\Octopus
Ensuring Package Feed Location Exists F:\Octopus\Packages\Spaces-1\feeds-builtin
The destination F:\Octopus\Packages\Spaces-1\feeds-builtin already exists, probably because this migration has been attempted before. Attempting to move the individual files and sub directories instead. This might take a bit longer.
Moving subdirectories and files from F:\Octopus\Packages to F:\Octopus\Packages\Spaces-1\feeds-builtin
Moving subdirectory F:\Octopus\Packages\Spaces-1 to F:\Octopus\Packages\Spaces-1\feeds-builtin\Spaces-1
Moving the built in package feed failed. Unable to access a directory while moving: Access to the path ‘F:\Octopus\Packages\Spaces-1’ is denied… You can still move packages manually from F:\Octopus\Packages into the new location for the built in feed: F:\Octopus\Packages\Spaces-1\feeds-builtin, and then use the re-index feature as required. There may also be packages in F:\Octopus\PackagesTemp
Error occured when executing scripts, transaction will be rolled back
Error: Upgrade failed due to an unexpected exception:
Error: System.IO.IOException: Access to the path ‘F:\Octopus\Packages\Spaces-1’ is denied.
Error: at System.IO.DirectoryInfo.MoveTo(String destDirName)
Error: at Octopus.Core.UpgradeScripts.Script0180BuiltInFeedMigration.MovePackagesAndFiles(String sourceDirectory, String destinationDirectory)
Error: at Octopus.Core.UpgradeScripts.Script0180BuiltInFeedMigration.MoveSubdirectoriesAndFiles(String sourceDirectory, Maybe1 tempPackagesDirectory, String destinationDirectory) Error: at Octopus.Core.UpgradeScripts.Script0180BuiltInFeedMigration.Execute(IDbCommandExecutor commandExecutor, IUpgradeLog log) Error: at Octopus.Core.Initialization.DbCommandUpgradeScriptResolver.Execute(Func
1 commandFactory, IUpgradeLog log)
Error: at Octopus.Core.Initialization.DatabaseUpgrader.OctopusUpgradeScriptExecutor.<>c__DisplayClass6_0.b__0(Func1 commandFactory) Error: at DbUp.Engine.Transactions.SingleTrasactionStrategy.Execute(Action
1 action)
Error: at Octopus.Core.Initialization.DatabaseUpgrader.OctopusUpgradeScriptExecutor.ExecuteDbCommandUpgradeScript(IConnectionManager connectionManager, IJournal journal, IUpgradeLog log, IDbCommandUpgradeScript upgradeScript)
Error: at Octopus.Core.Initialization.DatabaseUpgrader.OctopusUpgradeScriptExecutor.Execute(SqlScript script, IDictionary2 variables) Error: at DbUp.Engine.UpgradeEngine.PerformUpgrade() Error: We encountered an error during the schema upgrade. The schema upgrade was stopped and rolled back. Don't worry, this means we haven't made any changes to your data, and you should be able to get back up and running quickly. Error: Here is the summary of the problems we encountered: Error: ----------------------------------------- Error: Access to the path 'F:\\Octopus\\Packages\Spaces-1' is denied. Error: System.IO.IOException Error: at System.IO.DirectoryInfo.MoveTo(String destDirName) Error: at Octopus.Core.UpgradeScripts.Script0180BuiltInFeedMigration.MovePackagesAndFiles(String sourceDirectory, String destinationDirectory) Error: at Octopus.Core.UpgradeScripts.Script0180BuiltInFeedMigration.MoveSubdirectoriesAndFiles(String sourceDirectory, Maybe
1 tempPackagesDirectory, String destinationDirectory)
Error: at Octopus.Core.UpgradeScripts.Script0180BuiltInFeedMigration.Execute(IDbCommandExecutor commandExecutor, IUpgradeLog log)
Error: at Octopus.Core.Initialization.DbCommandUpgradeScriptResolver.Execute(Func1 commandFactory, IUpgradeLog log) Error: at Octopus.Core.Initialization.DatabaseUpgrader.OctopusUpgradeScriptExecutor.<>c__DisplayClass6_0.<ExecuteDbCommandUpgradeScript>b__0(Func
1 commandFactory)
Error: at DbUp.Engine.Transactions.SingleTrasactionStrategy.Execute(Action1 action) Error: at Octopus.Core.Initialization.DatabaseUpgrader.OctopusUpgradeScriptExecutor.ExecuteDbCommandUpgradeScript(IConnectionManager connectionManager, IJournal journal, IUpgradeLog log, IDbCommandUpgradeScript upgradeScript) Error: at Octopus.Core.Initialization.DatabaseUpgrader.OctopusUpgradeScriptExecutor.Execute(SqlScript script, IDictionary
2 variables)
Error: at DbUp.Engine.UpgradeEngine.PerformUpgrade()
Error: -----------------------------------------
Error: Beginning transaction
Error: Checking whether journal table exists…
Error: Executing .NET Database Server script ‘Octopus.Core.UpgradeScripts.Script0001RemoveTaskViewLogPermissionAgain.cs’
Error: Checking whether journal table exists…
Error: 0 User Roles will be upgraded to remove the TaskViewLog permission…
Error: 0 User Roles successfully upgraded to remove the TaskViewLog permission
Error: Executing .NET Database Server script ‘Octopus.Core.UpgradeScripts.Script0111AddDynamicInfrastructureFlagToEnvironments.cs’
Error: Adding Dynamic Infrastructure flag to Deployment Environments
Error: Executing .NET Database Server script ‘Octopus.Core.UpgradeScripts.Script0112DeleteOrphanedTenantTagsFromCertificates.cs’
Error: Deleting orphaned tenant tags from certificates.
Error: Executing TSQL Database Server script ‘Octopus.Core.UpgradeScripts.Script0113 - Add Worker Pools.sql’
Error: Executing .NET Database Server script ‘Octopus.Core.UpgradeScripts.Script0115AddFeatureToTurnOffBuiltinWorker.cs’
Error: Adding feature option to turn Built-in Worker on/off.
Error: Setting Built-in Worker to on.
Error: Executing TSQL Database Server script ‘Octopus.Core.UpgradeScripts.Script0116 - Add Machine Columns.sql’
Error: Creating new Machine table columns
Error: Setting CommunicationStyle column for Cloud Region
Error: Setting CommunicationStyle column for Tentacle
Error: Setting CommunicationStyle column for SSH
Error: Setting CommunicationStyle column for Offline
Error: Setting CommunicationStyle column for Azure
Error: Extracting Thumbprint to a column
Error: Extracting FingerPrint to a column
Error: Extracting RelatedDocumentIds to a column (Part 1/2)
Error: Extracting RelatedDocumentIds to a column (Part 2/2)
Error: Executing TSQL Database Server script ‘Octopus.Core.UpgradeScripts.Script0117 - Add RelatedDocuments.sql’
Error: Executing TSQL Database Server script ‘Octopus.Core.UpgradeScripts.Script0118 - Add Machine.DataVersion.sql’
Error: Executing TSQL Database Server script ‘Octopus.Core.UpgradeScripts.Script0118 - Rename RelatedDocuments Column.sql’
Error: Caution: Changing any part of an object name could break scripts and stored procedures.
Error: Caution: Changing any part of an object name could break scripts and stored procedures.
Error: Executing .NET Database Server script ‘Octopus.Core.UpgradeScripts.Script0118AddWorkerPermissionstoEnvironmentRoles.cs’
Error: Executing .NET Database Server script ‘Octopus.Core.UpgradeScripts.Script0118DeleteOrphanedVariableSetSnapshots.cs’
Error: Deleting orphaned library variable set snapshots.
Error: There are 1226 releases to check.
Error: Processed releases batch #1 out of 1
Error: No orphaned library variable set snapshots were found
Error: Phase 2, looking for orphaned project variables set snapshots
Error: No orphaned project variable snapshots were found
Error: Executing .NET Database Server script ‘Octopus.Core.UpgradeScripts.Script0118MigrateAzureWebAppTargetToNewSlotFormat.cs’
Error: Executing .NET Database Server script ‘Octopus.Core.UpgradeScripts.Script0118MigrationEnumSubTypes.cs’
Error: Migrating Account to string based subtyping
Error: Migrating DeploymentTarget endpoints to string based subtyping
Error: Migrating Worker endpoints to string based subtyping
Error: Migrating FeedType to string based subtyping
Error: Executing .NET Database Server script ‘Octopus.Core.UpgradeScripts.Script0118MoveFeedUriToJSON.cs’
Error: Processing feeds-builtin
Error: Processing feeds-builtin-releases
Error: Executing TSQL Database Server script ‘Octopus.Core.UpgradeScripts.Script0119 - AddClonedByProjectIdColumnToProjects.sql’
Error: Executing TSQL Database Server script ‘Octopus.Core.UpgradeScripts.Script0119 - DropFeedUri.sql’
Error: Executing TSQL Database Server script ‘Octopus.Core.UpgradeScripts.Script0119 - Release to VariableSet RelatedDocument.sql’
Error: Executing .NET Database Server script ‘Octopus.Core.UpgradeScripts.Script0120ConvertPackagePropertiesToPackagesCollection.cs’
Error: Converting deployment-action package properties into packages collection
Error: Processed 100 of 696
Error: Processed 200 of 696
Error: Processed 300 of 696
Error: Processed 400 of 696
Error: Processed 500 of 696
Error: Processed 600 of 696
Error: Converting action-template package properties into packages collection
Error: Executing .NET Database Server script ‘Octopus.Core.UpgradeScripts.Script0120PopulateRelatedDocumentTable.cs’
Error: 1246 rows in VariableSet (27.11MB)
Error: 0 rows in TenantVariable (0.00MB)
Error: 696 rows in DeploymentProcess (18.54MB)
Error: Extracting related document references. This will take about 1 minute(s) depending on server size.
Can you please help with the upgrade and advise how to proceed the upgrade.
Thanks & Regards,
Edmond