Code Fix: A duplicate key error occurs when deploying a package
KB002023
PRODUCTK2 blackpearl 4.7
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
When deploying a K2 package via the Microsoft Management Console, an error occurs on a few of the views in the package.
Error Message
The error message states: "Error %d, Level %d, State %d, Procedure %s, Line %dCannot insert duplicate key row in object 'Form.EventInstance' with unique index".
Resolution
- Ensure you have K2 4.7 installed.
- Download and install the K2 4.7 August 2017 Cumulative Update from K2 Partner and Customer Portal.
- Get the K2 4.7 August 2017 Cumulative Update FP4 from Regional Support.
- Install the K2 4.7 August 2017 Cumulative Update FP4 to apply the fix.