Parallel operations in table

(0) Share

Report

Posted on by v.udhay

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

All responses (2)

Answers (0)

Martin Dráb 231,493 Most Valuable Professional on at

Like (0)

Report

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_ 60,278 on at

Like (0)

Report

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.