Symptoms

The queries should be validate with K2 support
 

Diagnoses

When executing the following script no results are returned here....

SELECT TOP 1000 0ID]
,>ProcID]
,>Status]
,>StartDate]
,>FinishDate]
,>Originator]
,>Priority]
,>ExpectedDuration]
,>Folio]
,>Delegated]
,>DelegatedBy]
,>ExecutingProcID]
FROM MK2].]ServerLog].]ProcInst]

WHERE EFolio] 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.