Worklist Delay When Returning Task List
kbt133279
PRODUCTK2 blackpearl 4.6.11
BASED ONK2 blackpearl 4.6.11
TAGSK2 Workspace
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.
LEGACY/ARCHIVED CONTENT
This article has been archived, and/or refers to legacy products, components or features. The content in this article is offered "as is" and will no longer be updated. Archived content is provided for reference purposes only. This content does not infer that the product, component or feature is supported, or that the product, component or feature will continue to function as described herein.
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:ob 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.
