Standard settings missed post upgrade to Enterprise version

This script will list the number of system settings that were missed when upgrading to the current version of AVEVA Mobile Operator and the system settings that have no value.

Resolution:

For the system settings having no value, execute the following SQL command to fix the issue:

Note: Depending upon the number of settings that were missed, you may have to run this script that many times.

DECLARE @SettingName nvarchar(500), @Value nvarchar(max), @SettingId uniqueidentifier, @TenantId uniqueidentifier

SET @SettingName = N'< Enter Setting Name>'

SET @Value = N'<Enter Value>'

IF NOT EXISTS(SELECT * FROM SAT_Settings WHERE Name = @SettingName)

BEGIN

Print 'Invalid Setting Name.'

return

END

IF @Value = '' OR @Value = N'<Enter Value>'

BEGIN

Print 'Value is required.'

return

END

SELECT @TenantId = BASE_PK FROM ISMGT_BASE WHERE ParentId IS NULL AND [Type] = 1

SELECT @SettingId = SettingsPK FROM SAT_Settings WHERE Name = @SettingName

IF NOT EXISTS (SELECT * FROM SAT_Settings_Org_Link WHERE SettingsFK = @SettingId AND OrganizationEntityFK = @TenantId)

BEGIN

INSERT INTO [SAT_Settings_Org_Link] ([ID], [SettingsFK], [OrganizationEntityFK], [Value], [CreatedOn], [CreatedBy], [UpdatedOn], [UpdatedBy])

VALUES (NEWID(), @SettingId, @TenantId, @Value, SYSDATETIMEOFFSET(),'9A6748A2-C1F0-11D3-A101-009027316350', SYSDATETIMEOFFSET(), '9A6748A2-C1F0-11D3-A101-009027316350')

END