Standard settings missed in prior release (5​.1​.2 and below)

You can upgrade only from IntelaTrac 5.1.2 to AVEVA Mobile Operator 2020 and later versions.

This script will list the number of systems settings that were missed in the earlier or current version of IntelaTrac (5.1.2).

Resolution:

Execute the following SQL commands. You can use the integrity report to get the values for Setting ID, Setting Name, Value, App ID Category, Value Control,and IsAssessedInMobile.

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

DECLARE @SettingId uniqueidentifier, @SettingName nvarchar(500), @Value nvarchar(max), @AppId int, @Category nvarchar(100), @ValueControl xml, @IsAssessedInMobile bit

-- Provide input fields based on the output from report

SET @SettingId = N'< Provide setting Guid >'

SET @SettingName = N'< Provide setting Name >'

SET @Value = N'< Provide value >'

SET @AppId = N'< Provide app id >'

SET @Category = N'< Provide category >'

SET @ValueControl = N'< Provide value control >'

SET @IsAssessedInMobile = N'< Provide if this needs mobile access >'
IF NOT EXISTS (SELECT * FROM SATVDMAT_SETTINGS WHERE [name] = @SettingName)

BEGIN

INSERT INTO SATVDMAT_SETTINGS ([name], [value], [base_fk], [user_fk], [appid], [category], [SETTINGID], [CreatedOn], [UpdatedOn], [CreatedBy], [UpdatedBy], [ValueControl], [IsAccessedInMobile])

VALUES (@SettingName, @Value, '9A6748A1-C1F0-11D3-A101-009027316350', '00000000-0000-0000-0000-000000000000', @AppId, @Category, @SettingId,

GETDATE(), GETDATE(), '9A6748A2-C1F0-11D3-A101-009027316350', '9A6748A2-C1F0-11D3-A101-009027316350',

@ValueControl, @IsAssessedInMobile)

END