We are getting "Error message when you use Process Manager on the computer that is running Order Management in Microsoft Dynamics SL: SQL Server Message1205 - "Another user has locked a database record that this application needs in order to continue" "
What causes this issue and why would we get it in SL 2011 after an upgrade from SL 7 along with an upgraded SQL server.
Thanks,
Chuck
*This post is locked for comments
Looks like this error is a bug.
Microsoft has had me change the global solomon.ini file command to equal as noted below:
[Database Runtime]
AsyncDelay=1
I hope this helps someone else working with SL 2011 FP 1 SP2.
Thanks,
Chuck
Mark
We just got another SQL Server Message 1205 error.
It always occurs on transactions with serial numbers after releasing sales orders and clicking save.
New error details are:
Transaction was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
This has only started happening since we upgraded to SL 2011 FP 1 SP2.
Any help would be appreciated.
Thanks,
Chuck
Mark
I appreciate your help once again.
The user was trying to put a serial number on a shipper when they got the errors.
Programming Bulletproof Error 11500
Exception: System.Exception
Event Handler: OM401100.Form1.Update1_UpdateEvent
Line<not available>
Thanks,
Chuck
Chuck,
It's hard to say. Does the error give any additional details on what table was locked? If not, maybe check the SL event log or the SQL event log to see if more details are logged in either of those places.
In general, that error would indicate that some other process, say a batch release process, has a table locked for a period of time. Then process manager tries to access the batch table but can't because the release process has it locked.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (