Cannot delete worker due to pending work, but work is cancelled

(0) Share

Report

Posted on by DP-25070112-0

We are trying to delete a login so that multiple logins don't exist under a worker profile creating a shared worker. The error is that there is pending work for the user so we cannot delete.

In all work the only works transactions locked by this user are cancelled. Typically cancelling work on locked to a user should error out so I'm not sure how this scenario even occurred. The option to change user is grayed out. Work sessions have been cleared already. Tried the force cancel work but will not update since work is already cancelled.

Any ideas what method exists to update this record and clear the locked user? Or is there some other assigned work that I'm potentially missing preventing deleting this login?

Categories:

Dynamics 365 Supply Chain Management

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

HardikPatel523 140 on at

Like (1)

Report
Copy link

Link copied!
Hi,
I quickly checked the error in the system to understand the conditions under which it is triggered.
Before explaining the conditions, for reference, there are two main tables involved: Work header and Work lines. I assume the names are self-explanatory, so I won’t go into much detail about them.
The system throws this error under the following conditions:

If at least one Work header record exists where the Locked user is the user being deleted, and the Work status is neither Cancelled nor Closed.

The same validation applies to Work lines.

If either of the above conditions is true, the system will throw the error you mentioned.
So, it is likely that such records exist for that user. It is also possible that the data is inconsistent—for example, a work line might exist without a corresponding work header—but that is just an assumption.
For a developer, it should be fairly easy to identify such records using the table browser.

Was this reply helpful? Yes No