Workflows are stuck in Waiting and In Progress State

(0) Share

Report

Posted on by P.C

Hello All,

There are nearly 10000 workflows which stuck in waiting and in progress state.

maximum out of these is giving "Generic SQL error".Internally we are calling custom workflow but in traces not got enough information.

There are some of the workflows which are showing deadlock error(suspended temporarily due to error: Unhandled Exception: System.Data.SqlClient.SqlException: Transaction (Process ID 217) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction)

It is in production, please help.

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

RaviKashyap 55,410 Moderator on at

Like (0)

Report

RE: Workflows are stuck in Waiting and In Progress State

Hi,

If the error message confirms a sql deadlock then I don't think you can do anything from your end. If it is On Premise, you can login to sql server, find the process and kill it. You can also try restart the async service.

If it is online, you can contact Microsoft Support to assist you with it.

Once the deadlock is realeased, you should disable the workflow and try to find out the cause of the deadlock to avoid it n future.

Hope this helps.

Was this reply helpful? Yes No