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.