Sage 50 Manufacturing WaitingForLockForm error

[billshankley]

We are currently moving to a new ERP system with Manufacturing now being end of life but have not gone live yet, while still using Sage as our primary ERP we have started to experience an error when trying to cancel a works order in Sage 50 Manufacturing. When confirming cancellation a dialogue box pops up with .NET framework error "Waiting for lock" and then it loops around retrying without success.

.NET error box states Unhandled exception has occured... Cannot access a disposed object... Object: "WaitingForLockForm"

I thought this may have been an update issue but it is happening on all clients. This is the only operation causing this error currently but would appreciate if there is any knowledge of fixing/working around this error?

Thanks,

[billshankley]

In the demo system on the same server with the same execution client functionality is ok so that rules out an environment/dependency problem. All clients were affected at the same time so that leaves the server along with ACCDATA and the SQL db as potential root causes.

No issues in 10 years and just as we're moving off the system we get this. Typical.

[billshankley]

There was an old record in the ActiveLock table in the SQL database which I deleted and functionality is back. Can't imagine too many still use Manufacturing Line 50 but I think the schema overlaps quite a bit with Sage 200 so maybe this will help somebody.