Skip to main content

Notifications

Microsoft Dynamics RMS forum

Transaction (Process ID xx) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Posted on by 875

i have a problem this Massage appears 30 times At the Day

Note that

1-Rms version Is 2.0.2000

2- We Don't Use Worksheet 250 While at work (At Night Only)

3- We Run The Script  In The next link and make modify for Triggers Without interest

https://community.dynamics.com/rms/b/rmssupport/archive/2012/11/29/hotfix-rollup-2784931-34-for-microsoft-dynamics-rms-2-0.aspx

4- We Make Export a new database for this store But The problem still exists

What Can I do

Thanks For All

*This post is locked for comments

  • JosephS Profile Picture
    JosephS 30 on at
    RE: Transaction (Process ID xx) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

    Hi,

    Check your sql server client utility .make sure tcp/ip and named pipes are enabled.Also check your general network connection settings.See if you can ping sql server from the pos station.

  • Suggested answer
    arishi Profile Picture
    arishi 740 on at
    RE: Transaction (Process ID xx) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

    make sure all machines running RMS has the exact same version and updates of RMS and SQL, widows update for SQL will also help if there is any for your version, do not google it let windows find, good luck...

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Transaction (Process ID xx) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

    Hi,

    How many POS registers are you running in the store and where have you kept the store database?

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

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,802 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,129 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,154

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans