Symptoms
ServerLog out of Sync Issue - [K2].[ServerLog].[ProcInst]
Diagnoses
When you have 2 process instances in the [K2].[ServerLog].[ProcInst] table, that are in a running state that should not exist. The workitems were deleted from K2 Workspace and the option to delete log data was also chosen. All data in Server and ServerLog were deleted successfully however 2 rows remain in the [K2].[ServerLog].[ProcInst] table. Can you confirm if it is safe to delete these 2 process instances from the database manually?
SELECT *
FROM [K2].[ServerLog].[ProcInst]
where [Status] = 1
Resolution
This can occur if a process instance is not deleted correctly. Please contact K2 support to obtain the script to remove this from the K2 DB