Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

KB 3216955 Continuous dead locks in batch tables

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello All,

We were getting continuous dead locks in batch tables with one complex batch job and discovered we had not applied this hotfix.

We run Lean Manufacturing and are AX 2012 R3 CU9 Application version 6.3.2000.326.

After installing the KB (extracted the BatchRun class from the KB model installed in a duplicate instance) the deadlocks did stop however now we are getting almost continuous app locks:

DECLARE @res int; EXEC @res = SP_GETAPPLOCK @resource = N'BatchRunServerTaskLock', @lockmode = 'exclusive', @locktimeout = -1; SELECT @res; 

We understand that this shows that the new code is actually working however in observing the batch job execute we see that all of the tasks complete and go in to an Ended or Waiting state but the job itself stays at 100% complete and never goes back to a Waiting state, it just starts the subsequent run in an Executing state

We cleared the Batch History Table using the UI delete button and have other simple one task jobs that are executing heavy loads (many transactions) without the N'BatchRunServerTaskLock.

Any suggestions or feedback would be much appreciated!

*This post is locked for comments

  • Mea_ Profile Picture
    Mea_ 60,278 on at
    RE: KB 3216955 Continuous dead locks in batch tables

    Hi Bill Bartolotto,

    So what is the problem here? You don't have deadlocks anymore and your jobs are executing? If they never go from Executing  to Waiting that could be because of the recurrence setup, when job execution takes more than recurrence AX starts it straight ahead after completion because it is already behind a schedule.

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,354 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans