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.
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)”.
- Ensure you have K2 Five (5.2) installed.
- Download the K2 Five (5.2) FP1 from K2 Partner and Customer Portal.
- Install the K2 Five (5.2) FP1 to apply the fix.
- It is recommended to refresh the browser cache.