web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Deadlock Error while u...
Microsoft Dynamics RMS (Archived)

Deadlock Error while using RMS Manager/OPS

(0) ShareShare
ReportReport
Posted on by Community Member

Our stores have been experiencing this Deadlock error (message below) even though a patch (3 triggers) from Microsoft through New West was applied .

Does anyone have any idea how to permanently resolve this issue?

Any assistance will be highly appreciated.

Error: Run-time error: '-2147467259(80004005)':

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

*This post is locked for comments

I have the same question (0)
  • Kevin Antosh Profile Picture
    Kevin Antosh 1,649 on at
    RE: Deadlock Error while using RMS Manager/OPS

    Possible solution here: dailydoseofexcel.com/.../odbc-microsoft-access-driver-is-not-a-valid-path

  • Community Member Profile Picture
    Community Member on at
    RE: Deadlock Error while using RMS Manager/OPS

    Hey Kevin thanks for the reply, the error I am getting though relates more to a deadlock error using an SQL db, but thanks again.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Deadlock Error while using RMS Manager/OPS

    Hi Darryll,

    Can you try to disable the following triggers and verify whether they solve the issue?

    "tr_ItemValueLog" trigger - Item table

    "tr_TransactionEntryComputedQuantity" trigger - Transaction Entry table.

    "tr_ComputeQuantity" trigger - Inventory Transfer Log table.

    We have encountered this issue in the past, and after several attempts with Microsoft with no success, we have managed to disabled the above triggers and now we are no longer encountering such deadlocks. This issue happens normally when you have a high demand store with a lot of point of sales (over 25) working at the same time.

    Good luck!

    Regards,

    Kevin

  • Community Member Profile Picture
    Community Member on at
    RE: Deadlock Error while using RMS Manager/OPS

    Hi Kevin. I am wondering what impact that will have on our DB and Point of Sale Application in our stores? Our POS infrastructure consist of one Headquarter and two Stores with a total of 9 registers.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans