Code Fix: An error occurs when attempting to add or edit a SharePoint Update List event in a legacy workflow

[#1]

Code Fix: An error occurs when attempting to add or edit a SharePoint Update List event in a legacy workflow

KB003376

PRODUCT

K2 Five 5.3

K2 Five (5.3) Fix Pack 22

Issue Description

When you attempt to add or edit a SharePoint Update List event in a workflow in K2 Studio or K2 Designer for Visual Studio, an error occurs.

Error Message

The following error occurs: “SmartObject Server Exception: Violation of PRIMARY KEY constraint. Cannot insert duplicate key in object 'dbo.@smartObjects', The duplicate key value is (28)." The statement has been terminated”.

Resolution

The fix is available in the following K2 versions:

K2 4.7 March 2018 Cumulative Update	K2 Five (5.0) September 2018 Cumulative Update	K2 Five (5.1) November 2018 Cumulative Update	K2 Five (5.2) May 2019 Cumulative Update	K2 Five (5.3)
X	X	X	X	Fix Pack 22

1. Ensure you have the correct K2 version and/or Cumulative Update installed. See KB001893 to see what Fix Pack level you have installed.
2. Download the latest Fix Pack using the links in the table above for the version you require.
3. Install the Fix Pack to apply the fix.