Worklist Delay When Returning Task List
Some users will experience a delay when workspace worklist tasks are being returned/listed.
SymptomsThe [Server].[DestQueueUser] table would have duplicate values.
When a force identity cache refresh is done using the wrong case i.e Denallix:ob and not Denallix:Bob this issue will be the result.
Clear the [Server].[DestQueueUser] table manually from SQL Server Management Studio to remove all duplicates using the below script. This will significantly reduce the time that K2 Workspace Worklist takes to return the users tasks.
WITH CTE AS
SELECT [QueueID], [User], ROW_NUMBER() OVER(PARTITION BY [QueueID], [User]
ORDER BY [QueueID])
DELETE CTE WHERE [RN] > 1
Applying the May CU Fix Pack 6 will no longer require a manual fix due to the fix being incorporated into the fix pack.