Webroot Error During SOTI MobiControl Upgrade

When upgrading SOTI MobiControl from 14.x or 13.x to 15.x or later, a Webroot error may occur.

This issue is due to Webroot integration in older versions of SOTI MobiControl, which can cause issues with database connections.

Note: Ensure you back up the system and DB prior to performing the upgrade.

To address this error, add a setting to your SOTI MobiControl database using the following SQL script.

Step 1: Verify Settings Table

1. Open your SQL Database.
2. Run the following script to check the Settings table. Ensure you select the correct database for SOTI MobiControl.

SELECT * 
FROM [MobiControlDB].[dbo].[Settings]
WHERE Name LIKE '%DisableWebrootCheckVersion%'

3. Review the results:

• If an entry is not found, proceed to Step 2A.
• If an entry is found with an older version, proceed to Step 2B.

Step 2A: Insert a New Entry

If an entry is not found in the Settings table:

1. Identify the version of SOTI MobiControl you are upgrading to.

2. Use the following SQL script template, replacing VERSION with the version number you are upgrading to, to insert a new key.

INSERT INTO [MobiControlDB].[dbo].[Settings] 
VALUES ('DisableWebrootCheckVersion', 'VERSION')

Example: If upgrading to SOTI MobiControl 15.4.0 build 4737, update the SQL script template as follows:

INSERT INTO [MobiControlDB].[dbo].[Settings] 
VALUES ('DisableWebrootCheckVersion', '15.4.0.4737')

Step 2B: Update Existing Entry

If an entry for DisableWebrootCheckVersion with an older version is found in the Settings table:

1. Identify the version of SOTI MobiControl you are upgrading to.

2. Use the following SQL script template replacing, Upgraded_Version with the version number you are upgrading to, to update the existing key .

UPDATE [MobiControlDB].[dbo].[Settings]
SET Data = 'Upgraded_Version'
WHERE Name = 'DisableWebrootCheckVersion'

Example: If upgrading to SOTI MobiControl 15.4.0 build 4737, update the SQL script template as follows:

UPDATE [MobiControlDB].[dbo].[Settings]
SET Data = '15.4.0.4737'
WHERE Name = 'DisableWebrootCheckVersion'