Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Transaction (Process I...
Microsoft Dynamics RMS (Archived)

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

(0) ShareShare
ReportReport
Posted on by Saudi Market 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

photo of Muhammad Affan

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

thumbnail image of a pie chart section

Top 10 leaders for November!

Congratulations to our November super stars!

thumbnail image of the word Tip

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,503 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans