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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Parallel operations in...
Microsoft Dynamics AX (Archived)

Parallel operations in table

(0) ShareShare
ReportReport
Posted on by v.udhay 80

hello all, 

I have a batch with runs in LedgerJournalTable and it takes few mins or sometimes even hours to complete. When the batch status is "Executing", I try to delete any header from General journal randomly and AX gets hanged until the batch status is "Ended". 

Once the batch status is "Ended" then AX proceeds to delete the GL which I deleted manually. 

I would like both the operations run simultaneously. Is it possible to do that technically ? 

*This post is locked for comments

I have the same question (0)
  • Martin Dráb Profile Picture
    Martin Dráb 235,804 Most Valuable Professional on at
    RE: Parallel operations in table

    Also, it sounds like your long-running process executes everything in a single transaction (and therefore all locks are held until it completes). Check if it can't be split to smaller transactions and whether all locks it takes are necessary.

    It's also possible to explicitly enforce optimistic locking, if relevant in your case.

  • Suggested answer
    Mea_ Profile Picture
    Mea_ 60,284 on at
    RE: Parallel operations in table

    Hi ChennaiAXDeveloper,

    Probably SQL escalates locks on LedgerJournalTable during posting, you need to check it in management studio, then you can disable lock escalation for this table, here you can read how to disable them blog.pythian.com/disable-lock-escalation-in-sql-server but it's better to talk to your DBA if you have one.

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Syed Haris Shah Profile Picture

Syed Haris Shah 9

#2
Mea_ Profile Picture

Mea_ 4

#3
KP-31070522-0 Profile Picture

KP-31070522-0 3

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans