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