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
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (