Upgrade Issue

We got part way through upgrading from 3.7.0 build 5 to 4.0.6 build 26 when we got this error. How do we fix this up so that we can complete the release?

Debug: The script "10-RELNO. DROP NumericReleaseNumber" executed successfully.
Debug: 10-RELNO. UPDATE Sortable Release Numbers v2...
Error: The script "10-RELNO. UPDATE Sortable Release Numbers v2" execution failed. SQL Error: Release number '9.4.0' is invalid for the selected application.
Error: The transaction ended in the trigger. The batch has been aborted.
Error: System.InvalidOperationException: C:\Users\SVC_JE~1\AppData\Local\Temp\2\BuildMasterSetup\bmdbupdate.exe returned exit code -2
at Inedo.Installer.Subtasks.RunProcessSubtask.Run()
at Inedo.Installer.Subtasks.InstallationSubtask.RunSubtask(IInstallationTask parentTask)
at Inedo.BuildMaster.Setup.InstallBuildMasterTask.Upgrade(Version oldVersion)
at Inedo.Installer.InstallationTask`1.Inedo.Installer.IInstallationTask.RunInternal()

We've seen this error pop-up a few times, mostly if the ReleaseNumberScheme was altered on the table directly. This script will get fixed in a future release... but in the mean time...

One fix is to purge the offending application or releases causing the problem. To purge releases, you need to use the method Releases_PurgeReleaseData.

Of course, that may not be possible, so you can bypass this update script with this:

DELETE [__BuildMaster_DbSchemaChanges] WHERE [Script_Id] = 612
INSERT INTO [__BuildMaster_DbSchemaChanges]
SELECT '406239826673664', 612, 1, '10-RELNO. UPDATE Sortable Release Numbers v2', GETDATE(), 'N' UNION ALL
SELECT '406239826673664', 612, 2, '10-RELNO. UPDATE Sortable Release Numbers v2', GETDATE(), 'N' UNION ALL
SELECT '406239826673664', 612, 3, '10-RELNO. UPDATE Sortable Release Numbers v2', GETDATE(), 'N'

hope that helps