Hi,
Now I am not sure that I downloaded the correct version. When I looked at the file name it said Octopus.2018.10.4-x64.msi which seemed odd so I went to download it again and got 2019.9.12-x64 which seems more reasonable.
I went to run that one and got the following errors instead:
Using database connection string from configuration file: data source=(local)\SQLEXPRESS;initial catalog=Octopus;integrated security=True
========== SQL Database Connection Details ========
SQL Server: (local)\SQLEXPRESS
SQL Database: Octopus
Authentication Type: Windows Integrated Security
User: EC2AMAZ-7160HGQ\Administrator
===================================================
Preparing to upgrade the database âOctopusâ on SQL Server at â(local)\SQLEXPRESSâ to the expected schema running as âEC2AMAZ-7160HGQ\AdministratorââŚ
Making sure itâs safe to upgrade the database schemaâŚ
Checking to see if database schema upgrade is requiredâŚ
Database schema changes are required. Execution plan:
Planned pre-upgrade scripts (non-transactional):
- Octopus.Core.UpgradeScriptsPre.Script0000 - Database options.sql
Planned schema upgrade scripts (single transaction for all scripts):
- Octopus.Core.UpgradeScripts.Script0188 - Delete Artfifact RelatedDocumentIds.sql
- Octopus.Core.UpgradeScripts.Script0191 - PackageMetadata - Create table.sql
- Octopus.Core.UpgradeScripts.Script0192AddPackageMetadataPushPermission.cs
- Octopus.Core.UpgradeScripts.Script0194ConvertMachinePolicies.cs
- Octopus.Core.UpgradeScripts.Script0194NormalizeVCSRootURLs.cs
- Octopus.Core.UpgradeScripts.Script0195 - Add DataVersion column to spaces.sql
- Octopus.Core.UpgradeScripts.Script0195SetWorkerPoolType.cs
- Octopus.Core.UpgradeScripts.Script0196 - Team and UserRole DataVersion.sql
- Octopus.Core.UpgradeScripts.Script0197PreSeedFeedKeyAllocationTable.cs
- Octopus.Core.UpgradeScripts.Script0198 - Remove ProjectGroupId from DeploymentResource.sql
- Octopus.Core.UpgradeScripts.Script0200 - Add BlockConcurrentDeployments to interruption.sql
- Octopus.Core.UpgradeScripts.Script0201EnsureSystemAndSpacePermissionAreCorrect.cs
- Octopus.Core.UpgradeScripts.Script0202EnsureArtifactScopesAreConsistent.cs
- Octopus.Core.UpgradeScripts.Script0202EnsureMachineHealthCheckPoliciesAreNotNull.cs
- Octopus.Core.UpgradeScripts.Script0203 - Add OS details to machine table.sql
- Octopus.Core.UpgradeScripts.Script0203 - AddClonedFromTenantIdColumnToTenants.sql
- Octopus.Core.UpgradeScripts.Script0204CopyOSDetailsFromHealthCheckJson.cs
- Octopus.Core.UpgradeScripts.Script0205 - Add OS details to worker table.sql
- Octopus.Core.UpgradeScripts.Script0206CopyOSDetailsFromWorkerHealthCheckJson.cs
- Octopus.Core.UpgradeScripts.Script0207 - Set OS Detail Columns To Unknown When Null.sql
- Octopus.Core.UpgradeScripts.Script0208AddLTSLicenseHashColumnToMachines.cs
Planned post-upgrade scripts (non-transactional):
- Octopus.Core.UpgradeScriptsPost.Script0001 - Rebuild indexes.sql
- Octopus.Core.UpgradeScriptsPost.Script0002 - Refresh IdsInUse view.sql
Ensuring pre-conditions for upgrading the database are satisfiedâŚ
Searching for indexes that might upset the database upgrade processâŚ
- PASS: All columns use the default collation.
- PASS: Your Octopus Server will be compliant with your license after upgrading.
- PASS: Weâve done our best to remove any unexpected database indexes.
====================================================================================
Starting database schema upgradeâŚ
====================================================================================
Executing pre-upgrade scriptsâŚ
Executing TSQL Database Server script âOctopus.Core.UpgradeScriptsPre.Script0000 - Database options.sqlâ
Enabling read committed snapshot isolation on Octopus
Read committed snapshot isolation is already on
Executing schema upgrade scriptsâŚ
Beginning transaction
Checking whether journal table existsâŚ
Executing TSQL Database Server script âOctopus.Core.UpgradeScripts.Script0188 - Delete Artfifact RelatedDocumentIds.sqlâ
Checking whether journal table existsâŚ
Executing TSQL Database Server script âOctopus.Core.UpgradeScripts.Script0191 - PackageMetadata - Create table.sqlâ
Executing .NET Database Server script âOctopus.Core.UpgradeScripts.Script0192AddPackageMetadataPushPermission.csâ
Error occured when executing scripts, transaction will be rolled back
Error: Upgrade failed due to an unexpected exception:
Error: System.ArgumentNullException: Value cannot be null.
Error: Parameter name: value
Error: at Newtonsoft.Json.Linq.Extensions.Value[T,U](IEnumerable1 value) Error: at Octopus.Core.UpgradeScripts.Script0192AddPackageMetadataPushPermission.UserRoleData.get_GrantedSpacePermissions() in C:\buildAgent\work\abb2fbfce959a439\source\Octopus.Core\UpgradeScripts\Script0192 - Add PackageMetadataPush Permission.cs:line 71 Error: at Octopus.Core.UpgradeScripts.Script0192AddPackageMetadataPushPermission.RoleNeedsUpgrading(UserRoleData role) in C:\buildAgent\work\abb2fbfce959a439\source\Octopus.Core\UpgradeScripts\Script0192 - Add PackageMetadataPush Permission.cs:line 36 Error: at System.Linq.Enumerable.WhereListIterator
1.MoveNext()
Error: at System.Collections.Generic.List1..ctor(IEnumerable
1 collection)
Error: at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source) Error: at Octopus.Core.UpgradeScripts.Script0192AddPackageMetadataPushPermission.Execute(IDbCommandExecutor commandExecutor, IUpgradeLog log) in C:\buildAgent\work\abb2fbfce959a439\source\Octopus.Core\UpgradeScripts\Script0192 - Add PackageMetadataPush Permission.cs:line 24 Error: at Octopus.Core.Initialization.DbCommandUpgradeScriptResolver.Execute(Func
1 commandFactory, IUpgradeLog log) in C:\buildAgent\work\abb2fbfce959a439\source\Octopus.Core\Initialization\DbCommandUpgradeScriptResolver.cs:line 25
Error: at Octopus.Core.Initialization.DatabaseUpgrader.OctopusUpgradeScriptExecutor.<>c__DisplayClass6_0.b__0(Func1 commandFactory) in C:\buildAgent\work\abb2fbfce959a439\source\Octopus.Core\Initialization\DatabaseUpgrader.cs:line 319 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) in C:\buildAgent\work\abb2fbfce959a439\source\Octopus.Core\Initialization\DatabaseUpgrader.cs:line 307
Error: at Octopus.Core.Initialization.DatabaseUpgrader.OctopusUpgradeScriptExecutor.Execute(SqlScript script, IDictionary2 variables) in C:\buildAgent\work\abb2fbfce959a439\source\Octopus.Core\Initialization\DatabaseUpgrader.cs:line 287 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: Value cannot be null. Error: Parameter name: value Error: System.ArgumentNullException Error: at Newtonsoft.Json.Linq.Extensions.Value[T,U](IEnumerable
1 value)
Error: at Octopus.Core.UpgradeScripts.Script0192AddPackageMetadataPushPermission.UserRoleData.get_GrantedSpacePermissions() in Script0192 - Add PackageMetadataPush Permission.cs:line 71
Error: at Octopus.Core.UpgradeScripts.Script0192AddPackageMetadataPushPermission.RoleNeedsUpgrading(UserRoleData role) in Script0192 - Add PackageMetadataPush Permission.cs:line 36
Error: at System.Linq.Enumerable.WhereListIterator1.MoveNext() Error: at System.Collections.Generic.List
1âŚctor(IEnumerable1 collection) Error: at System.Linq.Enumerable.ToList[TSource](IEnumerable
1 source)
Error: at Octopus.Core.UpgradeScripts.Script0192AddPackageMetadataPushPermission.Execute(IDbCommandExecutor commandExecutor, IUpgradeLog log) in Script0192 - Add PackageMetadataPush Permission.cs:line 24
Error: at Octopus.Core.Initialization.DbCommandUpgradeScriptResolver.Execute(Func1 commandFactory, IUpgradeLog log) in DbCommandUpgradeScriptResolver.cs:line 25 Error: at Octopus.Core.Initialization.DatabaseUpgrader.OctopusUpgradeScriptExecutor.<>c__DisplayClass6_0.<ExecuteDbCommandUpgradeScript>b__0(Func
1 commandFactory) in DatabaseUpgrader.cs:line 319
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) in DatabaseUpgrader.cs:line 307 Error: at Octopus.Core.Initialization.DatabaseUpgrader.OctopusUpgradeScriptExecutor.Execute(SqlScript script, IDictionary
2 variables) in DatabaseUpgrader.cs:line 287
Error: at DbUp.Engine.UpgradeEngine.PerformUpgrade()
Error: -----------------------------------------
Error: Beginning transaction
Error: Checking whether journal table existsâŚ
Error: Executing TSQL Database Server script âOctopus.Core.UpgradeScripts.Script0188 - Delete Artfifact RelatedDocumentIds.sqlâ
Error: Checking whether journal table existsâŚ
Error: Executing TSQL Database Server script âOctopus.Core.UpgradeScripts.Script0191 - PackageMetadata - Create table.sqlâ
Error: Executing .NET Database Server script âOctopus.Core.UpgradeScripts.Script0192AddPackageMetadataPushPermission.csâ
Error: Error occured when executing scripts, transaction will be rolled back
Error: Upgrade failed due to an unexpected exception:
Error: System.ArgumentNullException: Value cannot be null.
Error: Parameter name: value
Error: at Newtonsoft.Json.Linq.Extensions.Value[T,U](IEnumerable1 value) Error: at Octopus.Core.UpgradeScripts.Script0192AddPackageMetadataPushPermission.UserRoleData.get_GrantedSpacePermissions() in C:\buildAgent\work\abb2fbfce959a439\source\Octopus.Core\UpgradeScripts\Script0192 - Add PackageMetadataPush Permission.cs:line 71 Error: at Octopus.Core.UpgradeScripts.Script0192AddPackageMetadataPushPermission.RoleNeedsUpgrading(UserRoleData role) in C:\buildAgent\work\abb2fbfce959a439\source\Octopus.Core\UpgradeScripts\Script0192 - Add PackageMetadataPush Permission.cs:line 36 Error: at System.Linq.Enumerable.WhereListIterator
1.MoveNext()
Error: at System.Collections.Generic.List1..ctor(IEnumerable
1 collection)
Error: at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source) Error: at Octopus.Core.UpgradeScripts.Script0192AddPackageMetadataPushPermission.Execute(IDbCommandExecutor commandExecutor, IUpgradeLog log) in C:\buildAgent\work\abb2fbfce959a439\source\Octopus.Core\UpgradeScripts\Script0192 - Add PackageMetadataPush Permission.cs:line 24 Error: at Octopus.Core.Initialization.DbCommandUpgradeScriptResolver.Execute(Func
1 commandFactory, IUpgradeLog log) in C:\buildAgent\work\abb2fbfce959a439\source\Octopus.Core\Initialization\DbCommandUpgradeScriptResolver.cs:line 25
Error: at Octopus.Core.Initialization.DatabaseUpgrader.OctopusUpgradeScriptExecutor.<>c__DisplayClass6_0.b__0(Func1 commandFactory) in C:\buildAgent\work\abb2fbfce959a439\source\Octopus.Core\Initialization\DatabaseUpgrader.cs:line 319 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) in C:\buildAgent\work\abb2fbfce959a439\source\Octopus.Core\Initialization\DatabaseUpgrader.cs:line 307
Error: at Octopus.Core.Initialization.DatabaseUpgrader.OctopusUpgradeScriptExecutor.Execute(SqlScript script, IDictionary`2 variables) in C:\buildAgent\work\abb2fbfce959a439\source\Octopus.Core\Initialization\DatabaseUpgrader.cs:line 287
Error: at DbUp.Engine.UpgradeEngine.PerformUpgrade()
Error:
Error: -----------------------------------------
Error: You have two options from this point:
Error: OPTION 1: Re-run the installer for the version of Octopus Server you were using just before trying this upgrade. Your data hasnât been changed and everything will go back to how it was beforehand. Please send this log to support@octopus.com and we will work with you to get you upgraded.
Error: OPTION 2: If you know what the problem is and how to fix it, please fix the problem and then try the upgrade again by running C:\Program Files\Octopus Deploy\Octopus\Octopus.Server.exe database --upgrade
Error:
Error: The previous command returned a non-zero exit code of: 1
Error: The command that failed was: âC:\Program Files\Octopus Deploy\Octopus\Octopus.Server.exeâ database --instance âOctopusServerâ --upgrade