4Site
Support Request System
View Patch #50.028.031
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
02723 -
Sort sequence on PR mail is wrong. non-blankPriority should be first.
02716 -
Username does not appear in active user table
Symptoms:
Request 02723 IF the 4Site PR mail had a numeric priority on it it showed up at the end of the list. All PR's with blank priority were showing first. Request 02716 The activeuser table only shows hostid next to the last checkin time. On a Citrix machine, every user has the same hostid. An extra column needs to be added for username.
Solution:
Request 02723 Somewhere along the way someone must've added a new column to the select and forgot to change the sort. It was an ordinal position 25 and should've been 26. It works again - numbers sort first then blanks then letters. Request 02716 Add the column to the activeuser table. SQL Server only. Use the suser_sname() SQL Server function to determine loginname so that both SQL Server Authenticated and Windows Authenticated accounts display an informative name. Note: The change made in 50.015.001 that introduced the activeuser table disabled the ability of DBAs to kill SQL Server processes to free up license positions of inactive users left logged on. After 50.015.001, DBAs could kill an inactive 4Site user by deleting a record from the activeuser table, but the only way to identify the specific user was by it's hostid. Since all Citrix users appear to originate from the same hostid, the loginname had to be added to the activeuser table. Hence this patch.
Browse Patches
Find a Patch
Return to Request System Menu
