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.
After upgrading from 4.6.11 to 4.7 the table [K2].[Server].[DestQueueUser] is constantly increasing with Duplicate values.
The following query can be used to determine if there are duplicates in the table.
WITH CTE AS
[QueueID], [User], ROW_NUMBER() OVER(PARTITION BY [QueueID], [User]
[QueueID]) AS [RN]
SELECT * FROM CTE
If duplicates exist this can have an adverse performance impact on user worklist retrieval and the duplicates will continue to increase.
This issue has been resolved in May CU Fix Pack 6.