When attempting to delete a Server from the Default Server Group in the Microsoft Application Virtualization (App-V) Virtualization Management Console, the following error code is received:
Manually run the SoftGrid Close Orphaned Sessions SQL Job to clear out the licenses or manually delete them from the dbo.LICENSE_ASSIGNMENTS table.
First, to determine the server_id of the server that cannot be deleted from the Default Server Group, look at the dbo.SERVERS table which will have the name and hostname fields to identify it (e.g. Server1 has a server_id of 1). Run the following SQL query against the App-V database to determine how many licenses are assigned to Server1:
Select * from License_assignments where server_id = 1
To delete these records directly from the App-V database, run the following SQL query against the App-V database:
Delete from License_assignments where server_id = 1
NOTE Please make a backup of the App-V database prior to running any command or making any modification.
If the App-V (or SoftGrid) Jobs are not present or not running correctly, eventually the App-V database will grow too large and cause related issues. Please see the following blog posts for more information:
Troubleshooting SoftGrid Database Growth Issues : http://blogs.technet.com/b/appv/archive/2008/08/04/troubleshooting-softgrid-database-growth-issues.aspx
Use the following blog to learn how to create the missing App-V SQL Jobs (Step 7), test and troubleshoot the App-V SQL Jobs (Step 9):
A Complete Guide to SQL 2008 App-V Database Migration : http://blogs.technet.com/b/appv/archive/2012/02/08/a-complete-guide-to-sql-2008-app-v-database-migration.aspx
Article ID: 2679610 - Last Review: Mar 1, 2012 - Revision: 1