How to Query Process Instances with Errors

Process Reports do allow you to filter on the Status and you can select 'Paused By Exception' for instances that are in error.

(on the reminder....I would caution you to consider what might happen if there were a very large number of process instances in error and you were sending emails every 5 minutes for all instances...you might want to think of a digest email e.g. "There are 97 instances of XXX process in error since <dateTime>" or similar...but even here, every 5 minutes seems like you'd end up spamming the recipients unnecessarily...)

Hi Mayank,

Hope this will help.

you can filter process with errors as below

1. create process report (report type-process , all process) 

2. open the process report add columns Num_Active_Task, Num_Problem_Task, ProcessInstanceId as attached 

3. use that report in query process analytics to filter processstatus is active and Num_Active_Task=0

This will return errored process.

In some scenarios, process instances would have been paused ,say if pause on error is  selected as true in write records and write records failed, in this case instance status is paused and unattended error task (write records), you can try filter by adding additional or condition in query filter like processstatus is paused and(or) Numb_Problem_Task > 0 to check if this works.

Additionally, you can add column Proceess Variable pv!ErrorDetail in your process report and if process variable stored error when error occurred in your process model then you can utilise it here to track error detail and take action based on it.

however, if your process model handled exception with exception handler error task(suppose assigned to ‘Technical Support’ group) then this will not appear in this report as there is active exception task for Technical Support group. 

in this case,

1. create process report (report type-task , all task) 

2. open this process report add columns TaskId, ProcessInstanceId, TaskAssignees as attached 

3.use that report in query process analytics to filter taskstatus is assigned, accepted and(or) TaskAssignees=‘Technical Support’ and(or) TaskName contains starts with ‘Exception/Error ……xxxx’(if you followed unique names that exception or error task always starts with Exception…..xxxxx or Error….xxxxx irrespective of different process models or applications)

This will return process instances which contains exception task with task id.   

or 

you can orchestrate robotic task to login to admin console, check process with errors checkbox in monitor view and the click on view unresolved error which will return a table process instances id with error details that you store it in excel for review or take action based on error suppose want terminate process instance in the flow. But need to analyse the impact on the volume, system load and do in non business hours if suggested