Code Fix: K2 Workflow reports show instances in running status even though they have completed
KB003006
PRODUCTK2 blackpearl 4.7
K2 4.7 March 2018 Cumulative Update
K2 4.7 March 2018 Cumulative Update Fix Pack 41
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 Description
The K2 Workflow reports show instances in running status even though they have completed. This is due to deadlocks that occur in the K2 Server when updating high volumes of item references.
Error Message
A SQL error may occur: “deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction”
Or
The user may see process instances in “running” state on the K2 Workspace site, even when they have completed.
Resolution
- Ensure you have K2 4.7 installed.
- Download and Install the K2 4.7 March 2018 Cumulative Update from K2 Partner and Customer Portal.
- Download the K2 4.7 March 2018 Cumulative Update FP41 from K2 Partner and Customer Portal.
- Install the K2 4.7 March 2018 Cumulative Update FP41 to apply the fix.
- It is recommended to refresh the browser cache.