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 Stewart Burchell , would this also include active processes with errors?

Hi Mayank_Verma  - an instance is not Active if it is 'Paused By Exception'. There are a few other Statuses that it can be in:

Stewart Burchell - Maybe there is a miscommunication from my end. I want to get the details of processes that are active and in errored state. Are those also filterable with process reports?

Maybe I'm misunderstanding what you're asking? A process report can filter the list of processes based upon some criteria. If you're only interested in instances that are in error then you an use 'Status' set to 'Paused By Exception' as described. If you want data about those instances then that's available in the 'Data' tab:

You have access to anything you might have access to in the Process Model itself - pv!s, pm!s,pp!s...just select + New Data and pick what it is you're looking for.

See here for more details; docs.appian.com/.../Configuring_Process_Reports.html

As mentioned above, I tried adding the filter to the Process Report. Unfortunately, it's not displaying any process instance though I have like 3 process instance errors.

Stewart Burchell  Even same question from my side.
When an unattended node errors out, the process shows as "Active"  in process reports but "Active with Errors" in Monitoring view. Is there a way to query/detect "Active with Errors" state from a process report.

Hi Mayank_Verma 

Please check this plugin: Appian Community, I hope this helps.

Thank you so much for this Bhirundha 

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