MobiControl Upgrade Failure HELP

G
Gary
Indianhead Foodservice Distributors

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:

2 years ago
Windows
ANSWERS
M
MNMOD@SOTI
2 years ago

Hi Gary,

Thank you for posting on SOTI Pulse!

Did you follow the upgrade path while moving from 13.4.0 to the latest version? Also, did you make sure that all the system requirements are met before upgrading? If not, that could be the reason for the upgrade failure. Please find the link for the upgrade path and System requirements below:

https://www.soti.net/mc/help/v15.6/en/setup/upgrading/upgrade.html?hl=upgrade%2Cpath

https://www.soti.net/mc/help/v15.6/en/setup/installing/system_requirements.html?hl=system%2Crequirements

Feel free to reach out in case of any other questions.


Kind regards,

Technical Support Specialist | SOTI | +1 905.624.9828 | SOTI.net l Discussion Forum | Log a Case Online l Facebook l LinkedIn l Twitter

RC
Raymond Chan Diamond Contributor
2 years ago

Did you first upgrade your MobiControl v13.4.0.4449 to v13.4.0.5519?