web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Time sheet Automatic P...
Microsoft Dynamics AX (Archived)

Time sheet Automatic Post Batch Process

(0) ShareShare
ReportReport
Posted on by Community Member

Hi friends,

                    I am getting the error in time sheet automatic batch process. Please Suggest .

"Cannot edit a record in Subledger journal entry (SubledgerJournalEntry). Ledger: 0, Current.

Deadlock, where one or more users have simultaneously locked the whole table or part of it."

and  

"Microsoft.Dynamics.Ax.Xpp.DeadlockException: Exception of type 'Microsoft.Dynamics.Ax.Xpp.DeadlockException' was thrown.    at Microsoft.Dynamics.Ax.MSIL.Interop.throwException(Int32 ExceptionValue)    at Microsoft.Dynamics.Ax.MSIL.cqlCursorIL.UpdateAll(IntPtr table)    at Dynamics.Ax.Application.SubledgerJournalTransferCommand.Updatetransferstatus(Int64 accountingEventId, Int64 ledger, Int32 sourceRelationType) in SubledgerJournalTransferCommand.updateTransferStatus.xpp:line 21    at Dynamics.Ax.Application.SubledgerJournalTransferCommand.Executetransfer(SubledgerJournalTransferRequest subledgerJournalTransferRequest) in SubledgerJournalTransferCommand.executeTransfer.xpp:line 109    at Dynamics.Ax.Application.SubledgerJournalTransferOperation.Executetransfer(SubledgerJournalTransferRequest subledgerJournalTransferRequest) in SubledgerJournalTransferOperation.executeTransfer.xpp:line 15    at SubledgerJournalTransferOperation::executeTransfer(Object , Object[] )    at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeInstanceCall(Object instance, String MethodName, Object[] parameters)    at Microsoft.Dynamics.Ax.Xpp.DictClass.Callobject(String methodName, XppObjectBase Called, Object[] varArgs)    at Dynamics.Ax.Application.SysOperationServiceController.Runoperation(Boolean async) in SysOperationServiceController.runOperation.xpp:line 88    at Dynamics.Ax.Application.SysOperationServiceController.Run() in SysOperationServiceController.run.xpp:line 27    at Dynamics.Ax.Application.SubledgerJournalTransferController.Run() in SubledgerJournalTransferController.run.xpp:line 40    at Dynamics.Ax.Application.SubledgerJournalTransferProcess.Performjournalentrytransferoperation(SysOperationExecutionMode executionMode, Boolean ) in SubledgerJournalTransferProcess.performJournalEntryTransferOperation.xpp:line 28    at Dynamics.Ax.Application.SubledgerJournalTransferProcess.Transferjournalentries(Int64 accountingEventId) in SubledgerJournalTransferProcess.transferJournalEntries.xpp:line 51    at Dynamics.Ax.Application.SubledgerJournalizer.Journalize() in SubledgerJournalizer.journalize.xpp:line 63    at Dynamics.Ax.Application.SubledgerJournalizationOperation.Journalize(SubledgerJournalizationRequest subledgerJournalizationRequest) in SubledgerJournalizationOperation.journalize.xpp:line 15    at SubledgerJournalizationOperation::journalize(Object , Object[] )    at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeInstanceCall(Object instance, String MethodName, Object[] parameters)    at Microsoft.Dynamics.Ax.Xpp.DictClass.Callobject(String methodName, XppObjectBase Called, Object[] varArgs)    at Dynamics.Ax.Application.SysOperationServiceController.Runoperation(Boolean async) in SysOperationServiceController.runOperation.xpp:line 88    at Dynamics.Ax.Application.SysOperationServiceController.Run() in SysOperationServiceController.run.xpp:line 27    at Dynamics.Ax.Application.SourceDocumentStateInProcess.Journalize() in SourceDocumentStateInProcess.journalize.xpp:line 32    at Dynamics.Ax.Application.SourceDocumentStateInProcess.Dotransition() in SourceDocumentStateInProcess.doTransition.xpp:line 17    at Dynamics.Ax.Application.SourceDocumentStateBase.Transition() in SourceDocumentStateBase.transition.xpp:line 32    at Dynamics.Ax.Application.SourceDocumentStateBase.Performtransitionormaintenance() in SourceDocumentStateBase.performTransitionOrMaintenance.xpp:line 7    at Dynamics.Ax.Application.SourceDocumentStateBase.Transitionto() in SourceDocumentStateBase.transitionTo.xpp:line 15    at Dynamics.Ax.Application.SourceDocumentProcessorBase.Submit() in SourceDocumentProcessorBase.submit.xpp:line 11    at Dynamics.Ax.Application.SourceDocumentProcessor.submitSourceDocumentImplementation(SourceDocumentHeaderImplementation sourceDocumentImplementation, Boolean updateImplementation, SourceDocumentAccountingStatus targetSourceDocumentAccountingStatus, SourceDocumentProcessorCaller caller, SourceDocumentLineItemList sourceDocumentLineItemList, String user, Boolean doTransitionToCompletedStateAccountFullyQualifiedValidation, Boolean , Boolean , Boolean , Boolean , Boolean , Boolean ) in SourceDocumentProcessor.submitSourceDocumentImplementation.xpp:line 74    at Dynamics.Ax.Application.SourceDocumentProcessor.submitSourceDocumentImplementation(SourceDocumentHeaderImplementation sourceDocumentImplementation, Boolean updateImplementation, SourceDocumentAccountingStatus targetSourceDocumentAccountingStatus, SourceDocumentProcessorCaller caller, SourceDocumentLineItemList sourceDocumentLineItemList, String user, Boolean doTransitionToCompletedStateAccountFullyQualifiedValidation)    at Dynamics.Ax.Application.SourceDocumentProcessorFacade.submitSourceDocumentImplementation(SourceDocumentHeaderImplementation sourceDocumentImplementation, Boolean updateImplementation, SourceDocumentAccountingStatus targetSourceDocumentAccountingStatus, SourceDocumentProcessorCaller caller, String user, Boolean doTransitionToCompletedStateAccountFullyQualifiedValidation, Boolean , Boolean , Boolean , Boolean , Boolean ) in SourceDocumentProcessorFacade.submitSourceDocumentImplementation.xpp:line 60    at Dynamics.Ax.Application.SourceDocumentProcessorFacade.@submitSourceDocumentImplementation(SourceDocumentHeaderImplementation sourceDocumentImplementation, Boolean updateImplementation, SourceDocumentAccountingStatus targetSourceDocumentAccountingStatus, SourceDocumentProcessorCaller caller, String user, Boolean , Boolean , Boolean , Boolean )    at Dynamics.Ax.Application.SourceDocumentProcessorFacade.@submitSourceDocumentImplementation(SourceDocumentHeaderImplementation sourceDocumentImplementation, Boolean updateImplementation, SourceDocumentAccountingStatus targetSourceDocumentAccountingStatus, SourceDocumentProcessorCaller caller, Boolean , Boolean , Boolean )    at Dynamics.Ax.Application.TSTimesheetsPost.Postsourcedocument() in TSTimesheetsPost.postSourceDocument.xpp:line 29    at Dynamics.Ax.Application.TSTimesheetsPost.post(TSTimesheetTable tsTimesheetTable) in TSTimesheetsPost.post.xpp:line 12    at Dynamics.Ax.Application.TSTimesheetsPostOperation.Run(TSTimesheetsPostRequest dataContract) in TSTimesheetsPostOperation.run.xpp:line 11    at TSTimesheetsPostOperation::run(Object , Object[] )    at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeInstanceCall(Object instance, String MethodName, Object[] parameters)    at Microsoft.Dynamics.Ax.Xpp.DictClass.Callobject(String methodName, XppObjectBase Called, Object[] varArgs)    at Dynamics.Ax.Application.SysOperationServiceController.Runoperation(Boolean _async) in SysOperationServiceController.runOperation.xpp:line 88    at Dynamics.Ax.Application.SysOperationServiceController.Run() in SysOperationServiceController.run.xpp:line 27    at Dynamics.Ax.Application.BatchRun.runJobStaticCode(Int64 batchId) in BatchRun.runJobStaticCode.xpp:line 54    at Dynamics.Ax.Application.BatchRun.runJobStatic(Int64 batchId) in BatchRun.runJobStatic.xpp:line 13    at BatchRun::runJobStatic(Object[] )    at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeStaticCall(Type type, String MethodName, Object[] parameters)    at BatchIL.taskThreadEntry(Object threadArg)"

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Were i need to change the batch job recurrence for automatic timesheet approval process.

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,976 Super User 2026 Season 1 on at

    Hi Padma,

    Check LCS issue search for possible known issues and hotfixes. I'm aware of e.g: "KB 4034214 Automatic timesheet posting failing randomly" which has been released for AX 2012 R2

  • Community Member Profile Picture
    Community Member on at

    Hi Andre,

          Can please explain little  briefly about your suggestion.

  • Community Member Profile Picture
    Community Member on at

    Hi Andre,

                  This hotfixes is only for R2, Our client machine is R3. Please suggest an answer.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,976 Super User 2026 Season 1 on at

    Hi Padma,

    Did you search for any other hotfixes or just focused on the example I provided? Did you install cumulative updates on your AX 2012 R3 environment?

    Also check if you have configured the SQL server according to best practices: technet.microsoft.com/.../dd309734.aspx

  • Community Member Profile Picture
    Community Member on at

    Hi Andre,

             I checked all hotfix in R3, But i am not getting it and also sql configuration is configured no problem in it.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Andrew Jones a1x Profile Picture

Andrew Jones a1x 2

#3
GL-01081504-0 Profile Picture

GL-01081504-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans