Unable to delete License Server Admin Set
The Delete button in the License Server Administrative Sets page does not work
There is an existing bug on this issue.
Below is the workaround. The License Server Admin set can be removed from the database directly by means of an SQL script.The customer needs to modify the line "SET Name = 't3'" to use the name of the set you're wanting to delete.This is for SQL Server.DECLARE @Name NVARCHAR(max)SET @Name = 't3'-- Remove users from the set:DELETE aaFROM MGR_LICSRVR_ADMINSET_ADMIN AS aaJOIN MGR_LICSRVR_ADMINSET as aset ON aa.ADMINSET_ID = aset.IDWHERE aset.NAME = @NAME-- Remove servers from the set:DELETE agFROM MGR_LICSVRADMSET_LICSVRGRP AS agJOIN MGR_LICSRVR_ADMINSET as aset ON ag.ADMINISTRATIVE_SET_ID = aset.IDWHERE aset.NAME = @NAME-- Remove the set itself:DELETE MGR_LICSRVR_ADMINSET WHERE NAME = @NAME
Aug 26, 2020