This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice This article is not considered official documentation for K2 software and is provided “as is” with no warranties.

Issue

Some users will experience a delay when workspace worklist tasks are being returned/listed.

Symptoms

The [Server].[DestQueueUser] table would have duplicate values.
When a force identity cache refresh is done using the wrong case i.e Denallix:\bob and not Denallix:\Bob this issue will be the result.

Resolution

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])

   AS [RN]
   FROM [Server].[DestQueueUser]
)
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.