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 SQL and select Database Settings (see the red box in the diagram).
2. Record the location of the data and the logs (see the blue boxes).

   

3. Navigate to the data and log directories and delete all files in those directories.
   Note: Delete only the file contents of the data and log folders, not the data and log folders 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.
2. Reconfigure the rule to exclude any rule or configuration that has "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.
• Make sure the User Account Control (UAC) is enabled. See Windows forum for more information.