News and Announcements icon

Dynamics 365 CommunityForums Dynamics 365 general forum Workflows are stuck in...

Dynamics 365 general forum

Workflows are stuck in Waiting and In Progress State

(0) Share

Report

Report

Posted on by P.C

10

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.

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

RaviKashyap 55,410 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.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2

Martin Dráb 230,458 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans