SOTI Connect Installation/ Upgrade Issues

1. Stop any running antivirus programs.
2. Re-run the SOTI Connect installer.

2023-07-25 17:48:59,992 [ERROR] [ 8] Installer - Database migration failed and the installation/update cannot be continued.
Please contact support for further assistance.
2023-07-25 17:48:59,992 [ERROR] Installer - Installation failed System.Exception: Database migration failed and the installation/update cannot be continued.
Please contact support for further assistance.

1. Navigate to the Server Properties panel of the VM hosting the SQL, then select Database Settings.
2. Record the location of the Data and Logs.

   

3. Navigate to the Data and Log directories and delete all files inside.
   Note: Delete only the files, not the directories themselves.

• Affected versions: SOTI Connect 2024.0 and later

use SotiConnectManagementServer

IF OBJECT_ID('tempdb..#removeJsonMetadata') IS NOT NULL
	DROP PROCEDURE #removeJsonMetadata
GO

CREATE PROCEDURE #removeJsonMetadata
@JsonText nvarchar(max),
@Result nvarchar(max) OUTPUT
as 
	declare @idBegin int = 0;
	declare @idEnd int = 0;
	select @idBegin = CHARINDEX('"$id":"', @JsonText, @idBegin)
	WHILE @idBegin > 0
	BEGIN
		select @idEnd = @idBegin +  LEN('"$id":"')
		select @idEnd = CHARINDEX('"', @JsonText, @idEnd)
		select @idEnd = case when SUBSTRING(@JsonText, @idEnd + 1, 1) = ',' then @idEnd + 2 else @idEnd + 1 end
		select @JsonText = REPLACE(@JsonText, SUBSTRING(@JsonText, @idBegin, @idEnd - @idBegin), '');
		select @idBegin = CHARINDEX('"$id":"', @JsonText, @idBegin)
	END
	select @Result = @JsonText
RETURN
GO


declare @JsonText nvarchar(max)

DECLARE employee_cursor CURSOR FOR
  SELECT RuleJson
  FROM   [SotiConnectManagementServer].[dbo].[Rules]

OPEN employee_cursor;
FETCH NEXT FROM employee_cursor INTO @JsonText
WHILE @@FETCH_STATUS = 0
  BEGIN  
	  exec #removeJsonMetadata @JsonText, @JsonText output
      UPDATE [SotiConnectManagementServer].[dbo].[Rules]
      SET    RuleJson = @JsonText
      WHERE  CURRENT OF employee_cursor;

      FETCH NEXT FROM employee_cursor INTO @JsonText
  END;
CLOSE employee_cursor;
DEALLOCATE employee_cursor; 

1. Run the SOTI Connect installer as an administrator.
2. Press CTRL + Double-click on the installer window to reveal the Repair DTD option.

   

3. Choose Repair DTD and follow the installer instructions.

• The OEM has discontinued support for action X.
• A specific OEM model does not support action X, which is otherwise supported by all other OEM models. To support common properties/actions, SOTI Connect marks the action as "Unavailable".

1. Delete the "Unavailable" action from the rule or configuration.
2. Reconfigure the rule to exclude unavailable actions.

Activation of app failed with error:
This app can't be activated by the Built-in Administrator. See the Microsoft-Windows-TWinUI/Operational log for additional information.

• Make sure your screen resolution is at least 1024x768.
• Ensure User Account Control (UAC) is enabled. See Windows forum for more information.

1. Launch the SOTI Connect installer as an administrator.
2. Navigate to the SOTI Connect Root Certificate view.
3. Select Import Root Certificate From File.

   

4. Select Browse, locate the root certificate file, and enter the Certificate Password.
5. Select Next, then follow the remaining steps in the installer to complete the update.

Installer - Could not start service SOTI Connect - Management Server