Versions Compared

Old Version 2

changes.mady.by.user AGAT Support

Saved on

compared with

New Version 3

changes.mady.by.user AGAT Support

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

When upgrading the database and having an the following issue with creating the UIX_SIP:

...

perform Perform the following steps:

  1. Edit the scripts 4.5.6.1to5.0.0.sql. Default location is
    C:\Agat\SphereShield.Setup\Payload\SqlScripts\Upgrade\Archive

  2. Search for UIX_SIP and Remove the following code:

    Code Block
    BEGIN TRY  

		DECLARE @indiciesScript varchar(max)= N'USE [{DB_NAME}]
			ALTER TABLE [FEDERATION_POLICY_CACHE] DROP CONSTRAINT [UIX_SIP]

			CREATE UNIQUE NONCLUSTERED INDEX [UIX_SIP] ON [FEDERATION_POLICY_CACHE]
			(
			[LOCAL_SIP] ASC,
			[OTHER_SIP] ASC,
			[POLICY_TYPE] ASC
			) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
			'
		SET @scriptToExecute = REPLACE(@indiciesScript, N'{DB_NAME}', @dbName)

		EXECUTE (@scriptToExecute)
	
	END TRY 
	BEGIN CATCH 
		 print  'Have error in create UIX_SIP index'		
	END CATCH

...