Symptoms

ServerLog out of Sync Issue - K2]..ServerLog]..ProcInst]
 

Diagnoses

When you have 2 process instances in the eK2].]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 eK2].]ServerLog].]ProcInst] table. Can you confirm if it is safe to delete these 2 process instances from the database manually?

SELECT *
FROM MK2].]ServerLog].]ProcInst]
where eStatus] = 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