3
N

Mention the other user when you show a (dead) lock message

Niels Ellenbroek on 4/7/2022 9:21:15 AM

Today we got a dead lock message:

The Activity was dead locked with another user who was modifying the inter tenant transfer table. Please retry the activity.


The system only mentions "another user".

It would be much more helpful for the user, that (s)he gets this message with the actual user that is causing a lock or dead lock.

Then this user can be contacted

Category: General
STATUS DETAILS
Declined
Ideas Administrator

Business Central Team (administrator)

Thank you for your feedback. We are not considering the suggestion at this time due to the following reason: 

It is not possible for the Business Central server to know the "winner" AL session in a deadlock situation. The second best thing you can do in this situation is to query partner telemetry for the SQL Deadlock 
signal that was added to the 2022 release wave 1. Here you at least get insights into where in the AL execution the victim session was when the database decided to rollback its transaction.
 

Sincerely,

Kennie Nybo Pontoppidan
PM, Microsoft