We have Dynamics 365 Finance and Operations v10.0.39. We use workflows to gain approval for project tax invoice proposals.
Several of those workflows have become unrecoverable, with the following message: "Stopped (unrecoverable): Cannot select a record in SysWorkflowTable (SysWorkflowTable). Correlation ID: {00000000-0000-0000-0000-000000000000}, {00000000-0000-0000-0000-000000000000}.Deadlock, where one or more users have simultaneously locked the whole table or part of it."
This issue has only recently started, and only affects a small sample of our project tax invoice proposals.
We have then cancelled the workflow, but the result is the invoice proposal is not able to be edited or deleted - it is completely stuck with the status Submitted (see screenshots).
The transaction lines attached to these proposals are now also stuck and we are not able to invoice our Customers, so this has a cash flow impact.
Any help would be much appreciated!