How to Find Out the Error in a K2 blackpearl 4.5 Workflow Process Instance

Sometimes looking through the logs on the K2 Workspace or Process Portal is just too slow. Run the following SQL query on the K2Server database:

USE K2Server

SELECT TOP 1000 *

FROM dbo._ErrorLog WITH(NOLOCK)
ORDER BY Date DESC
 
SELECT TOP 1000 *
FROM dbo._ProcInst WITH(NOLOCK)
ORDER BY StartDate DESC