Issue Description

When you design a K2 workflow using a SharePoint list containing multiple lookup fields that point to the same secondary SharePoint list, you are unable to view the workflow instance in K2 Management > Workflow Server > Workflows > [Workflow Name] > Reports tab. An error will also be logged in the Host Server log file. This issue occurs when the workflow is designed to start by using a SharePoint event.

Error Message

The following error is logged in the Host Server log file: “ServerLog_ItemInstanceInput'. Cannot insert duplicate key in object 'ServerLog.ItemInstanceInput'. The duplicate key value is (1, 1, 1, ID)”.

Resolution

  1. Ensure you have K2 Five (5.1) installed.
  2. Download the K2 Five (5.1) FP23 from K2 Partner and Customer Portal.
  3. Install the K2 Five (5.1) FP23 to apply the fix.
  4. It is recommended to refresh the browser cache.