Sometimes we have processes that stop executing because of database connectivity

Sometimes we have processes that stop executing because of database connectivity issues, engine issues, etc. The alerts show:

Problem: An error occurred in executing an Activity Class.
Recommended Action: Examine the activity class to correct the error and then resume.

The process dashboard shows the process as active with 'There is a problem with this process.' and the orange triangle with the ! mark. I can monitor the process and most of the time there is a red box and slash around the node in question. Sometimes because the node has been processed more than once there is only a normal blue box. I can cancel the spawned node (the one with 'Problem with task' and restart it just fine (after we bounced the server, etc.).

1) Is there a way to see all processes that are hung, the report 'Processes with Problems' doesn't show any.
2) Is there a way to mass restart all processes that are hung? Currently, opening hundreds of alerts, moni...

OriginalPostID-104760

OriginalPostID-104760