I am trying to upgrade an existing instance of MobiControl running version 13.4.0.4449 to the latest 15.6 version. During the installation process I got a catastrophic error message during the installation and had to do a manual restore to get the services back up. I'm including the portion of the logs that detail the error. I can't find anything on getting past this.
I ran the upgrade under and a domain admin account and used the sa account against the sql database which is SQL Express 2016 running the latest CU.
[2023-05-26 12:07:01.689] DEBUG (4): DAC Message: Error SQL72014: .Net SqlClient Data Provider: Msg 4902, Level 16, State 1, Line 1 Cannot find the object "dbo.DevNote" because it does not exist or you do not have permissions.
[2023-05-26 12:07:01.689] DEBUG (4): DAC Message: Error SQL72045: Script execution error. The executed script:
[2023-05-26 12:07:01.689] DEBUG (4): ALTER TABLE [dbo].[DevNote] DROP CONSTRAINT [DevInfo_DevNote_FK1];
[2023-05-26 12:07:01.689] DEBUG (4): DAC Message: Message SQL0: An error occurred while the batch was being executed.
[2023-05-26 12:07:01.689] DEBUG (4): DAC Progress: Faulted [2]: Updating database
[2023-05-26 12:07:01.689] DEBUG (4): DAC Message: Message SQL73036: Updating database (Failed)
[2023-05-26 12:07:01.689] DEBUG (4): DAC Progress: Faulted [2]: Deploying package to database
[2023-05-26 12:07:01.689] DEBUG (4): DAC Progress: Faulted [2]: Registering metadata for database
[2023-05-26 12:07:01.721] DEBUG (4): FAILURE: DACPAC has failed to deploy: Microsoft.SqlServer.Dac.DacServicesException: Could not deploy package.
[2023-05-26 12:07:01.721] DEBUG (4): Warning SQL72015: The type for column AzureTenantName in table [dbo].[AzureTenant] is currently NVARCHAR (2083) NOT NULL but is being changed to NVARCHAR (450) NOT NULL. Data loss could occur.
[2023-05-26 12:07:01.721] DEBUG (4): Warning SQL72015: The type for column Id in table [dbo].[Container] is currently INT IDENTITY (1, 1) NOT NULL but is being changed to TINYINT NOT NULL. Data loss could occur.
[2023-05-26 12:07:01.721] DEBUG (4): Warning SQL72015: The type for column Handle in table [dbo].[CryptoKey] is currently NVARCHAR (250) NOT NULL but is being changed to NVARCHAR (200) NOT NULL. Data loss could occur.
[2023-05-26 12:07:01.721] DEBUG (4): Warning SQL72015: The type for column ContainerId in table [dbo].[DevContainerStatus] is currently INT NOT NULL but is being changed to TINYINT NOT NULL. Data loss could occur.
[2023-05-26 12:07:01.721] DEBUG (4): Warning SQL72015: The column [dbo].[DeviceConfigSectionStatus].[Id] is being dropped, data loss could occur.
[2023-05-26 12:07:01.721] DEBUG (4): Warning SQL72015: The type for column ContainerId in table [dbo].[DeviceConfigSectionStatus] is currently INT NOT NULL but is being changed to TINYINT NOT NULL. Data loss could occur.
[2023-05-26 12:07:01.721] DEBUG (4): Warning SQL72016: The column FilterExpression on table [dbo].[DeviceGroupVirtual] must be changed from NULL to NOT NULL. If the table contains data, the ALTER script may not work. To avoid this issue, you must add values to this column for all rows or mark it as allowing NULL values, or enable the generation of smart-defaults as a deployment option.
[2023-05-26 12:07:01.721] DEBUG (4): Warning SQL72015: The column [dbo].[DeviceInstalledApp].[AppleVPPLicenseId] is being dropped, data loss could occur.
[2023-05-26 12:07:01.721] DEBUG (4): Warning SQL72015: The type for column ContainerId in table [dbo].[DeviceInstalledApp] is currently INT NOT NULL but is being changed to TINYINT NOT NULL. Data loss could occur.
[2023-05-26 12:07:01.721] DEBUG (4): Warning SQL72015: The type for column ContainerId in table [dbo].[DevicePackageStatus] is currently INT NOT NULL but is being changed to TINYINT NOT NULL. Data loss could occur.
[2023-05-26 12:07:01.721] DEBUG (4): Warning SQL72015: The type for column ContainerId in table [dbo].[DevicePayloadStatus] is currently INT NULL but is being changed to TINYINT NULL. Data loss could occur.
[2023-05-26 12:07:01.721] DEBUG (4): Warning SQL72015: The type for column ContainerId in table [dbo].[DevLicense] is currently INT NULL but is being changed to TINYINT NULL. Data loss could occur.
[2023-05-26 12:07:01.721] DEBUG (4): Warning SQL72016: The column EventCategoryId on table [dbo].[Events] must be changed from NULL to NOT NULL. If the table contains data, the ALTER script may not work. To avoid this issue, you must add values to this column for all rows or mark it as allowing NULL values, or enable the generation of smart-defaults as a deployment option.
[2023-05-26 12:07:01.721] DEBUG (4): Warning SQL72015: The type for column Name in table [dbo].[MobileNetworkCode] is currently NVARCHAR (1000) NOT NULL but is being changed to NVARCHAR (300) NOT NULL. Data loss could occur.
[2023-05-26 12:07:01.721] DEBUG (4): Warning SQL72015: The type for column ContainerId in table [dbo].[Profile] is currently INT NULL but is being changed to TINYINT NULL. Data loss could occur.
[2023-05-26 12:07:01.721] DEBUG (4): Warning SQL72015: The type for column ContainerId in table [dbo].[WPDeviceInstalledAppExt] is currently INT NOT NULL but is being changed to TINYINT NOT NULL. Data loss could occur.
[2023-05-26 12:07:01.721] DEBUG (4): Warning SQL72015: The type for column PackageFamilyName in table [dbo].[WPInventory] is currently NVARCHAR (500) NOT NULL but is being changed to NVARCHAR (450) NOT NULL. Data loss could occur.
[2023-05-26 12:07:01.721] DEBUG (4): Warning SQL72015: The column [dbo].[WPProductPackage].[MinOSVersionInt] is being dropped, data loss could occur.
[2023-05-26 12:07:01.721] DEBUG (4): Error SQL72014: .Net SqlClient Data Provider: Msg 4902, Level 16, State 1, Line 1 Cannot find the object "dbo.DevNote" because it does not exist or you do not have permissions.
[2023-05-26 12:07:01.721] DEBUG (4): Error SQL72045: Script execution error. The executed script: