The number of concurrent licenses are not reset when the Application Virtualization Management Server service restarts

First, here is an overview of what the stored procedure does:

1. Determines which servers should be cleaned up.
2. Retrieve the startup times of the servers from MESSAGE_LOG table.
3. Determine the latest date of startup for each server using the results from #2.
4. Find stale sessions by looking in the MESSAGE_LOG table where the entry date < last startup date AND where it has no corresponding teardown entries (specified by pre-defined transaction codes).
5. For each stale session found, clean up the entries in the appropriate tables.

In order for the stored procedure to work properly, modification needs to be made at step 2 as follows:

1. Connect to the SQL Server where the App-V database is located (make sure the account you are using has the right permissions to modify the stored procedure).
2. Expand SQL_Server_Instance\APPVIRT\Programmability\Stored Procedures.
3. Right click on dbo.sp_SFTclosesessions and select “Modify”.
4. Go to line 212 and change 41217 to 44951.
5. Now hit Execute to save the changes.

For example, here is the relevant part of dbo.sp_SFTclosesessions prior to modification:

SELECT s.server_id,

           s.hostname,

           m.msg_time

      INTO #temp_startups

      FROM message_log m INNER JOIN

           vw_softgrid_servers s ON (m.server_hostname = s.hostname)

     WHERE s.server_id = ISNULL(@server_id, s.server_id)

       AND s.hostname = ISNULL(@server_hostname, s.hostname)

       AND m.fn_module LIKE N'SW_SystemDispatcher%'

       AND m.severity = 0

       AND m.msg_id = 41217 --

Here is the relevant part of dbo.sp_SFTclosesessions after modification:

SELECT s.server_id,

           s.hostname,

           m.msg_time

      INTO #temp_startups

      FROM message_log m INNER JOIN

           vw_softgrid_servers s ON (m.server_hostname = s.hostname)

     WHERE s.server_id = ISNULL(@server_id, s.server_id)

       AND s.hostname = ISNULL(@server_hostname, s.hostname)

       AND m.fn_module LIKE N'SW_SystemDispatcher%'

       AND m.severity = 0

       AND m.msg_id = 44951