Multiple Duplicate Entries in table DestQueueUser after K2 4.7 Upgrade

  • 16 February 2021
  • 0 replies
  • 4 views

Userlevel 5
Badge +20
 

Multiple Duplicate Entries in table DestQueueUser after K2 4.7 Upgrade

kbt133084

PRODUCT
K2 blackpearl 4.7
BASED ON
K2 blackpearl 4.7
TAGS
K2 Workspace
Contact Support KB
Cumulative Update
Fix Pack
Code Fix
Support
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

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.

 

 

Resolution

This issue has been resolved in May CU Fix Pack 6.

0 replies

Be the first to reply!

Reply