Welcome to the Inedo Forums! Check out the Forums Guide for help getting started.
If you are experiencing any issues with the forum software, please visit the Contact Form on our website and let us know!
Best way to upgrade Proget from 3.7.6.2 to latest (5.3.33)
-
Do we just download the legacy installer and run it?
We have Proget 3.7.6.2 installed on a windows 2008R2 and in proget we have just one nuget legacy feed defined.The best would be to upgrade so that all the configuration are retained and external project using the server would not need to upgrade their configuration also.
-
I did a try and I've got an error. It looks like it goes up to a certain version and then stops with an exception on the DB...
Debug: Product = ProGet (5.3.33) Debug: OS = Microsoft Windows NT 6.1.7601 Service Pack 1 Debug: Edition = Express Debug: TargetPath = C:\Program Files\ProGet Debug: WebAppPath = C:\Program Files\ProGet\WebApp Debug: ServicePath = C:\Program Files\ProGet\Service Debug: PackagesPath = C:\ProgramData\ProGet\Packages Debug: ASPNETTempPath = C:\ProgramData\ProGet\Temporary ASP.NET Files Debug: ConnectionString = Data Source=localhost\SQLEXPRESS; Initial Catalog=ProGet; Integrated Security=True; Debug: Port = 8624 Debug: UseIntegratedWebServer = True Debug: WebServerPrefixes = http://*:8624/ Debug: InstallSqlExpress = False Debug: UserAccount = NetworkService Debug: WebAppUserAccount = NetworkService Debug: ServiceUserAccount = NetworkService Debug: LicenseKey = xxxxxxxxxxxxxxxxx Debug: EmailAddress = Debug: FullName = Debug: ConfigureIIS = False Debug: BackupDatabase = True Debug: DatabaseBackupPath = C:\ProGetBackups Debug: ExtensionsPath = C:\ProgramData\ProGet\Extensions Debug: ExtensionsTempPath = C:\ProgramData\ProGet\ExtensionsTemp Debug: LogFile = C:\Users\Administrator\AppData\Local\Temp\2\tmp43D3.tmp.txt Debug: Upgrade = True Information: Stopping ProGet service... Debug: Stopping service INEDOPROGETSVC... Debug: INEDOPROGETSVC service stopped. Information: Stopping the ProGet web server service... Debug: Stopping service INEDOPROGETWEBSVC... Warning: Could not start service: Service INEDOPROGETWEBSVC was not found on computer '.'. Information: Backing up database to C:\ProGetBackups... Debug: Backup file: C:\ProGetBackups\ProGet-Pre5.3.33.bak Debug: Backup completed. Information: Removing previous version... Debug: Staging C:\Program Files\ProGet\Service for delete... Debug: Attempting to rename C:\Program Files\ProGet\Service to C:\Program Files\ProGet\4d8f57223875443783bebe68440b20e8... Debug: Attempting to rename C:\Program Files\ProGet\Service to C:\Program Files\ProGet\4d8f57223875443783bebe68440b20e8... Debug: C:\Program Files\ProGet\4d8f57223875443783bebe68440b20e8\ renamed. Debug: Attempting to hide C:\Program Files\ProGet\4d8f57223875443783bebe68440b20e8... Debug: Directory staged for delete. Debug: Staging C:\Program Files\ProGet\WebApp for delete... Debug: Attempting to rename C:\Program Files\ProGet\WebApp to C:\Program Files\ProGet\2a21e037287648aeb3f15982030ad0c8... Debug: Attempting to rename C:\Program Files\ProGet\WebApp to C:\Program Files\ProGet\2a21e037287648aeb3f15982030ad0c8... Debug: C:\Program Files\ProGet\2a21e037287648aeb3f15982030ad0c8\ renamed. Debug: Attempting to hide C:\Program Files\ProGet\2a21e037287648aeb3f15982030ad0c8... Debug: Directory staged for delete. Debug: Deleting old start menu items... Information: Updating database schema... Debug: Launching process "C:\Users\ADMINI~1\AppData\Local\Temp\2\ProGetSetup\SqlScripts\inedosql.exe" update SqlScripts.zip --connection-string="Data Source=localhost\SQLEXPRESS; Initial Catalog=ProGet; Integrated Security=True;"... Debug: Database uses old change script schema; upgrading... Debug: Script DDL-DML/v5.0-5.2/0212. 5.1.3/More asset hashes.sql is missing a legacy ID. Debug: Script DDL-DML/v5.0-5.2/0213. 5.1.8/Add Feeds_UnlistPackage task.sql is missing a legacy ID. Debug: Script DDL-DML/v5.0-5.2/0214. 5.1.19/10. Drop Connector Password Constraint.sql is missing a legacy ID. Debug: Script DDL-DML/v5.0-5.2/0220. 5.2.0/00. Alter Connector Filter Column.sql is missing a legacy ID. Debug: Script DDL-DML/v5.0-5.2/0220. 5.2.0/01. Connector Name Constraint.sql is missing a legacy ID. Debug: Script DDL-DML/v5.0-5.2/0220. 5.2.0/10. Create DebianPackages.sql is missing a legacy ID. Debug: Script DDL-DML/v5.0-5.2/0220. 5.2.0/20. Create PypiPackages.sql is missing a legacy ID. Debug: Script DDL-DML/v5.0-5.2/0220. 5.2.0/30. Add FeedTypes.sql is missing a legacy ID. Debug: Script DDL-DML/v5.0-5.2/0220. 5.2.0/40. Add Licenses_Manage task.sql is missing a legacy ID. Debug: Script DDL-DML/v5.0-5.2/0220. 5.2.0/50. Add FeedReplicationMode.sql is missing a legacy ID. Debug: Script DDL-DML/v5.0-5.2/0220. 5.2.0/51. Add FeedReplication_Configuration.sql is missing a legacy ID. Debug: Script DDL-DML/v5.0-5.2/0220. 5.2.0/60. Create HelmCharts.sql is missing a legacy ID. Debug: Script DDL-DML/v5.0-5.2/0220. 5.2.0/61. Add Helm FeedType.sql is missing a legacy ID. Debug: Script DDL-DML/v5.0-5.2/0220. 5.2.0/70. Add Columns to FeedRetentionRules.sql is missing a legacy ID. Debug: Script DDL-DML/v5.0-5.2/0220. 5.2.0/71. Create ProGetLicensingViolations.sql is missing a legacy ID. Debug: Script DDL-DML/v5.0-5.2/0220. 5.2.0/80. Remove MyGet FeedSync.sql is missing a legacy ID. Debug: Script DDL-DML/v5.0-5.2/0221. 5.2.1/10. Connector Name Constraint.sql is missing a legacy ID. Debug: Script DDL-DML/v5.0-5.2/0222. 5.2.5/10. Increase Package_Versions length.sql is missing a legacy ID. Debug: Script DDL-DML/v5.0-5.2/0222. 5.2.6/10. Webhooks Constraint Change.sql is missing a legacy ID. Debug: Script DDL-DML/v5.0-5.2/0224. 5.2.8/10. Index NuGet v2 Package Size.sql is missing a legacy ID. Debug: Script DDL-DML/v5.0-5.2/0225. 5.2.12/10. Add Docker blob media type.sql is missing a legacy ID. Debug: Script DDL-DML/v5.0-5.2/0226. 5.2.14/10. Update ServiceUrls Configuration.sql is missing a legacy ID. Debug: Script DDL-DML/v5.0-5.2/0227. 5.2.14/10. Create ExternalUsers.sql is missing a legacy ID. Debug: Script DDL-DML/v5.0-5.2/0227. 5.2.15/10. Create PackageDependents.sql is missing a legacy ID. Debug: Script DDL-DML/v5.0-5.2/0228. 5.2.16/Create FeedAlternateNames.sql is missing a legacy ID. Debug: Script DDL-DML/v5.0-5.2/0240. 5.2.25/10. Add RPM FeedType.sql is missing a legacy ID. Debug: Script DDL-DML/v5.0-5.2/0240. 5.2.25/10. Add RPM Packages.sql is missing a legacy ID. Debug: Script DDL-DML/v5.0-5.2/0240. 5.2.25/10. Add RPM RepoData.sql is missing a legacy ID. Debug: Script DDL-DML/v5.0-5.2/0241. 5.2.27/10. Alter DockerBlobs.sql is missing a legacy ID. Debug: Script DDL-DML/v5.0-5.2/0241. 5.2.27/10. Alter DockerBlobUploads.sql is missing a legacy ID. Debug: Script DDL-DML/v5.0-5.2/0241. 5.2.27/10. Alter Vulnerabilities Add Blob_Digest.sql is missing a legacy ID. Debug: Script DDL-DML/v5.0-5.2/0241. 5.2.28/change UQ on package dependents.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/01. Container Layer Visibility/10. Add DockerRepositories.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/01. Container Layer Visibility/11. Add ContainerConfigBlob_Id.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/01. Container Layer Visibility/12. Alter DockerImages.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/01. Container Layer Visibility/13. Create DockerRepositoryTags.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/01. Container Layer Visibility/14. Remove old data.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/01. Container Layer Visibility/20. Add DockerImageLayers.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/01. Container Layer Visibility/30. Add ImageTypeCode.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/02. Container Versioning/1. Add Columns to Docker Tags Table.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/02. Container Versioning/1. Add LastDownload to Images.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/02. Container Versioning/1. Add Repository ImageUrl to Docker Repository.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/03. Helm Chart Visibility/10. Create HelmChartDockerImages.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/04. Container and Package Usage/10. Create PackageContainerUsage.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/04. Container and Package Usage/11. Create FeedScanners.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/04. Container and Package Usage/12. Update PackageDependent.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/04. Container and Package Usage/13. Update PackageUsage.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/04. Container and Package Usage/14. AddGrouptToPackageUsage.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/05. Various Refactoring/10. Drop FeedAdapters.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/05. Various Refactoring/10. Drop NuGetQuirks.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/05. Various Refactoring/20. Fix upack versions.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/05. Various Refactoring/22. Expand upack versions.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/05. Various Refactoring/30. Alter Connectors.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/05. Various Refactoring/40. Drop NpmConnectorPackages.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/06. ManualVulnerabilityRefactoring/10. AddFeedIdAndContraintToVulnerabilitiesTable.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/06. ManualVulnerabilityRefactoring/20. MigrateManualVulnerabilities.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/07. OOBEUpgrade/10.DisableOOBEOnUpgrade.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/09. Remove Bad BaseUrl.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/10. Clean Directory Providers.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/10. Delete Anonymous User.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/10. Make Anonymous an Admin for OOB.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/10. Remove Deployment Feed Type.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/10. Trigger Docker and Helm Rebuild Jobs.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/10. Update npm feeds to use NpmFeedConfig.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/11. Rename ProGet Feed Type.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/12. Rename ProGet Connector Feed Type.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/20. Move System Config Values to Feeds and Connectors.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/20. Remove Legacy NuGetConfig Attribs.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/30. Add ModifyDate to DockerRepositories.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/40. Remove npm connector tasks.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/50. Add CreatedDate To Package Consumers.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3/51. New Retention Rules.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3.09/10. Create CustomLanguages.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3.09/40. Create UserConfiguration.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3.14/Create ClusterNodes Table.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3.23/10. Add DockerUpload context.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3.26/10. Add SHA512 to npm.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3.26/10.RebuildHelmMetadata.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3.27/10.ExpandContainerUsageServer.sql is missing a legacy ID. Debug: Script DDL-DML/v5.3.27/10.ExpandWebhookUrl.sql is missing a legacy ID. Error: Unhandled Exception: System.Data.SqlClient.SqlException: The parameterized query '(@Script_Guid uniqueidentifier,@Script_Name nvarchar(200),@Scrip' expects the parameter '@Script_Sql', which was not supplied. Error: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) Error: at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, 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 asyncWrite) Error: at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) Error: at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() Error: at Inedo.DbUpdater.SqlServer.SqlServerDatabaseConnection.UpgradeSchema(IDictionary`2 canoncialGuids) Error: at Inedo.DbUpdater.Program.Update(String scriptPath, String connectionString, Boolean force) Error: at Inedo.DbUpdater.Program.Run(ArgList args) Error: at Inedo.DbUpdater.Program.Main(String[] args) Debug: C:\Program Files\ProGet\WebApp restored. Debug: C:\Program Files\ProGet\Service restored. Debug: Starting service INEDOPROGETSVC... Debug: INEDOPROGETSVC service started. Error: System.InvalidOperationException: C:\Users\ADMINI~1\AppData\Local\Temp\2\ProGetSetup\SqlScripts\inedosql.exe returned exit code -532462766 at Inedo.Installer.Subtasks.RunProcessSubtask.Run() at Inedo.Installer.InstallationTask`1.RunSubtask(InstallationSubtask subtask) at Inedo.ProGet.Setup.InstallProGetTask.UpdateDatabaseSchema() at Inedo.ProGet.Setup.InstallProGetTask.Upgrade(UniversalPackageVersion oldVersion) at Inedo.Installer.InstallationTask`1.Inedo.Installer.IInstallationTask.RunInternal()
-
Hi @internalit_7155,
I know you have attempted the upgrade already, but in the future you can go to https://my.inedo.com/downloads and click the
Upgrade Guidance & Change Notesbutton. That will allow you to enter in the versions you are upgrading from and to and view the upgrade path. Here is the result of that for your upgrade, ProGet 3.7.6 to 5.3.33. The upgrade path for this is to first upgrade to ProGet 5.2.32 then to 5.3.33.Looking through your error, I have found this to be a known issue when upgrading a very old version of the database to our new tools directly. We actually recently fixed this bug in inedosql.
The best way to resolve this is to restore your database back to the 3.7.6 version and use the traditional installer to upgrade to ProGet 5.2.32 first. This will also allow you to log in and convert your NuGet feed to the new format. Once you upgrade to that version and convert your NuGet feed, then upgrade to ProGet 5.3.33. For ProGet 5.3.33, I would recommend using Inedo Hub to perform the upgrade. We have deprecated the traditional installer and it will no longer be generated in ProGet 6+.
Hope this helps!
Thanks,
Rich
-
Hello
I followed the advised migration path but I found out I had a sqlserver 2005 installed so I had to upgrade it to 2012 at least (the only one compatible with windows 2008R2).
The upgrade to 5.2.32 went fine and was confirmed by the installer, just when starting the service it crashes.
I had to update the serverurl as described here:https://inedo.com/support/kb/1014/changing-url-with-the-integrated-web-server
After that the service started but connecting with a browser the Proget I see a white (empty) page.
Is there a log I could check to find out what went wrong?
