Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / The activity was deadl...
Small and medium business | Business Central, N...
Suggested answer

The activity was deadlocked with another user... & Working on it....

(0) ShareShare
ReportReport
Posted on by Besian

I have a big problem in one of my client with this error (deadlock error and working on it...). He has many users in the system and many of this work with the same user in the system and they have a big problem with deadlock error and working  on it...

All this users work on the Sales Quote and in this page/table are this error all the time (deadlock error and working  on it...) If I see Database Lock page 9511 its full with record all the time. Also to these users even when they are working on the system is displayed "working on it...". Have anyone any ideas ?

11111.png

  • Daniel S Dias Profile Picture
    Daniel S Dias 15 on at
    RE: The activity was deadlocked with another user... & Working on it....

    Hi Besian, i am currently having a similar issue. did you get a resolve?

  • Suggested answer
    RockwithNav Profile Picture
    RockwithNav 6,562 on at
    RE: The activity was deadlocked with another user... & Working on it....

    One of the major reason triggering deadlock is when 2 transactions are executed simultaneously and they are blocking each other.  See which piece of code is complaining this and then if you deliberately use LOCKTABLE function then this it will go but I will suggest to refracture the code.

  • Besian Profile Picture
    Besian on at
    RE: The activity was deadlocked with another user... & Working on it....

    Thank You SanderB for your answer, but I made these configurations and again the situation is the same.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: The activity was deadlocked with another user... & Working on it....

    It's interesting that you post this today.

    About 2 weeks ago a client of ours also experienced a lot of locking issues, all of a sudden, after a new update.

    The locking issues were resolved by disabling automatic cost posting and changing automatic cost adjustment to run less often (not 'Always').
    Let me know if it helps.

    pastedimage1633700581879v2.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,883 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,569 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans