Slow performance of open worklist item operation for certain users
kbt162619
PRODUCTIssue
Open worklist item operation is very slow (takes more than two minutes) for specific user(s) when performed via the following API call:
wkfConn.ImpersonateUser(fromUser);
WorklistItem workItem = wkfConn.OpenWorklistItem(serialNumber, "ASP", false);
Symptoms
It is also possible to see that for affected users, execution of the UMGroup Get Groups SmartObject takes very long. The same can be observed if you run GetIdentityContainers table-valued function in the K2 database, i.e. execute:
Resolution
This issue can be caused by the affected user being a member of a large number of nested groups/circular nested groups. The issue can be reproduced if you create 10 groups, and then add the 1st one in all of them and adding your test user to all of those groups. This causes extreme slowness of the GetIdentityContainers function.
To resolve this issue, apply the K2 update which includes optimizations for the GetIdentityContainers function:
K2 4.7 - apply K2 4.7 March 2018 Cumulative Update Fix Pack 29 or newer update which contains "Hotfix: Performance issues occur in K2 Worklist, K2 Designer and K2 Management" for K2 4.7
K2 5.1 - apply K2 Five (5.1) Fix Pack 30 or newer update which contains "Hotfix: Performance issues occur in K2 Worklist, K2 Designer and K2 Management" for K2 5.1
K2 5.2 - apply K2 Five (5.2) Fix Pack 21 or newer update which contains "Hotfix: Performance issues occur in K2 Worklist, K2 Designer and K2 Management" for K2 5.2
