1739

Issue:

After installing an updated version of the SES console, the database requires upgrading.  In preforming this on Microsoft SQL Server 2016 Cumulative Update 6 or 7, the SES console hangs.

The occurs because the Cumulative Updates for SQL Server 2016 starting with 6, prevents the execution of a critical SQL directive when preforming the database upgrade

Affected Environment:

Fix:  

Please upgrade to Cumulative update 8 or later for SQL Server 2016

Workaround:

If you are unable to perform the update as recommended, there is a workaround as documented from Microsoft Support: (Changed with the relevant details).

Please run the following scripts against the SQL server
 

-- Stop the audit:

ALTER SERVER AUDIT AuditName WITH (STATE = OFF) GO

-- Change the database isolation level:

ALTER DATABASE WMTemplate SET ALLOW_SNAPSHOT_ISOLATION ON

-- Turn the audit back on:

ALTER SERVER AUDIT AuditName WITH (STATE = ON) GO