Multiple Duplicate Entries in table DestQueueUser after K2 4.7 Upgrade
kbt133084
PRODUCTIssue
After upgrading from 4.6.11 to 4.7 the table [K2].[Server].[DestQueueUser] is constantly increasing with Duplicate values.Symptoms
The following query can be used to determine if there are duplicates in the table.
WITH CTE AS
(
SELECT
[QueueID], [User], ROW_NUMBER() OVER(PARTITION BY [QueueID], [User]
ORDER BY
[QueueID]) AS [RN]
FROM
[Server].[DestQueueUser]
)
SELECT * FROM CTE
If duplicates exist this can have an adverse performance impact on user worklist retrieval and the duplicates will continue to increase.