Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Dead lock while posting invoice

Posted on by Microsoft Employee

We are getting dead lock when sales invoice posted using web service. Our process is below.

sales invoices are made in our shipping ERP and sales invoice posted using web service

1) Web service is called for creation of sales invoice lines and AX will create the line items and confirm the invoice.

2) Second web service is called to post the invoice and posted

We have 200  users posting invoices from our shipping application and we get dead lock error from dynamics ax 2012 R3.

Our AX server is 256 GR RAM and 2 octacore core processor.

Is dead lock due to 2 web service call for invoice posting?? . Will it be possible to do posting in one web service call 

ie create sales invoice lines, confirm invoice and post invoice. 

Please guide me on this. We have planned for go-live soon. 

*This post is locked for comments

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at
    RE: Dead lock while posting invoice

    Hi Wilson.

    To be able to troubleshoot, you should understand the SQL statements which are causing the deadlock. Then find the related methods in AX 2012 (web service or related posting class). Then you have to review the calls if there is a kind of table or record lock which can cause this. We don't know how exactly it has been created, so don't know the exact cause.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans