Symptoms
The queries should be validate with K2 support
Diagnoses
When executing the following script no results are returned here....
SELECT TOP 1000 [ID]
,[ProcID]
,[Status]
,[StartDate]
,[FinishDate]
,[Originator]
,[Priority]
,[ExpectedDuration]
,[Folio]
,[Delegated]
,[DelegatedBy]
,[ExecutingProcID]
FROM [K2].[ServerLog].[ProcInst]
WHERE [Folio] LIKE '%********%'
Resolution
The server.proc inst table will display process that are still in a running state. To see closed off processes this will need to be view from the serverlog.procinst table instead.
Note: Direct DB modifications are not supported and will put you in an unsupported state.