Hi,
I have a custom batch job which runs every hour and does the job of invoicing sales orders. Below is the error log. Please have a look at Red marked lines. I believe issue lies there.
It says something related to cql (SQL). I believe it could be because of temporary DB connection issue.
When this happened, batch job did not invoice around 30% to 40% orders it was supposed invoiced. When it run again, it picked up these uninvoiced orders and successfully invoiced them without any issue.
This shows that there was no data related issue. It was something related to infrastructure. But i want to check with the experts here on their opinion.
Also, We will touch base with MS Support on this error.
" at [aoskernel.dll]Microsoft.Dynamics.Ax.MSIL.Interop.GetManagedCallStack(basic_string<wchar_t\,std::char_traits<wchar_t>\,std::allocator<wchar_t> >* )
at [aoskernel.dll]Microsoft.Dynamics.Ax.Services.AOSAppDomainHelper.callGetManagedCallStack(basic_string<wchar_t\,std::char_traits<wchar_t>\,std::allocator<wchar_t> >* )
at callGetManagedCallStack(basic_string<wchar_t\,std::char_traits<wchar_t>\,std::allocator<wchar_t> >* )
at cqlClass.callEx(cqlClass* , Char* , interpret* )
at cqlClass.callEx(cqlClass* , Char* , interpret* )
at [aoskernel.dll]Microsoft.Dynamics.Ax.MSIL.cqlClassIL.Call(IntPtr c, String methodName, Object[] parameters, Type[] types, Object[] varargs, Type[] varargsTypes)
at [Microsoft.Dynamics.AX.Server.Core.dll]Microsoft.Dynamics.Ax.Xpp.XppObjectBase.Call(String methodName, Object[] parameters, Type[] types, Object[] varargs)
at [Microsoft.Dynamics.Ax.Xpp.Support.dll]Dynamics.AX.Application.xInfo.add(Exception exception1, String text1, String text2)
at [Dynamics.AX.ApplicationPlatform.dll]Dynamics.AX.Application.Info.`add(Exception _exception, String _txt, String _helpUrl, XppObjectBase _sysInfoAction, Boolean buildprefix, String _label, Boolean @_helpUrl_IsDefaultSet, Boolean @_sysInfoAction_IsDefaultSet, Boolean @buildprefix_IsDefaultSet, Boolean @_label_IsDefaultSet)
at [Dynamics.AX.ApplicationPlatform.dll]Dynamics.AX.Application.Info.add(Exception _exception, String _txt, String _helpUrl, XppObjectBase _sysInfoAction, Boolean buildprefix, String _label, Boolean @_helpUrl_IsDefaultSet, Boolean @_sysInfoAction_IsDefaultSet, Boolean @buildprefix_IsDefaultSet, Boolean @_label_IsDefaultSet)
at [Dynamics.AX.ApplicationPlatform.dll]Dynamics.AX.Application.Info.add(Exception _exception, String _txt, String _helpUrl, XppObjectBase _sysInfoAction, Boolean buildprefix, String _label)
at [Dynamics.AX.ApplicationPlatform.dll]Dynamics.AX.Application.Info.`kernelAdd(Exception _exception, String _txt, String label)
at [Dynamics.AX.ApplicationPlatform.dll]Dynamics.AX.Application.Info.kernelAdd(Exception _exception, String _txt, String label)
at Info::kernelAdd(Object , Object[] , Boolean& )
at [Microsoft.Dynamics.Ax.Xpp.Support.dll]Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeInstanceCall(Object instance, String MethodName, Object[] parameters)
at callILClassMethod(interpret* ip, Char* method, UInt32 chdl, cqlClass* c)
at cqlCursorIL_Native.EndFind(cqlCursor* )
at cqlCursorIL_Native.EndFind(cqlCursor* )
at [aoskernel.dll]Microsoft.Dynamics.Ax.MSIL.cqlCursorIL.EndFind(IntPtr table)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesLine.`findRecId(Int64 _recId, Boolean _update, Boolean @_update_IsDefaultSet)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesLine.findRecId(Int64 _recId, Boolean _update, Boolean @_update_IsDefaultSet)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesLine.findRecId(Int64 _recId)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.RetailTransactionServiceFulfillment.`updateFulfillmentStatus(Int64 salesLineRecId)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.RetailTransactionServiceFulfillment.updateFulfillmentStatus(Int64 salesLineRecId)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesInvoiceJournalPostBase.`updateInventory(InventMovement _inventMovement)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesInvoiceJournalPostBase.updateInventory(InventMovement _inventMovement)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesInvoiceJournalPost.`postInventory()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesInvoiceJournalPost.postInventory()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterJournalPost.`postSingleLine(Boolean _countryRegion_RU, Boolean _hasQualityOrder, Boolean _isExciseEnableIN, Boolean _isVATEnableIN, Boolean _isCustomsEnableIN, Boolean _isConfigurationkeyRetailEnabled)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterJournalPost.postSingleLine(Boolean _countryRegion_RU, Boolean _hasQualityOrder, Boolean _isExciseEnableIN, Boolean _isVATEnableIN, Boolean _isCustomsEnableIN, Boolean _isConfigurationkeyRetailEnabled)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesInvoiceJournalPost.`postSingleLine(Boolean _countryRegion_RU, Boolean _hasQualityOrder, Boolean _isExciseEnableIN, Boolean _isVATEnableIN, Boolean _isCustomsEnableIN, Boolean _isConfigurationkeyRetailEnabled)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesInvoiceJournalPost.postSingleLine(Boolean _countryRegion_RU, Boolean _hasQualityOrder, Boolean _isExciseEnableIN, Boolean _isVATEnableIN, Boolean _isCustomsEnableIN, Boolean _isConfigurationkeyRetailEnabled)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterJournalPost.`postLines()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterJournalPost.FormletterJournalPostCoCHelper.`postLines(FormletterJournalPost instance)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.ProjFormLetterJournalPost_Extension.postLines(FormletterJournalPost this)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterJournalPost.FormletterJournalPostCoCHelper.`postLines(FormletterJournalPost instance)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterJournalPost.postLines()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterJournalPost.`post()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterJournalPost.post()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterJournalPost.`run()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterJournalPost.run()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesInvoiceJournalPostBase.`run()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesInvoiceJournalPostBase.SalesInvoiceJournalPostBaseCoCHelper.`run(SalesInvoiceJournalPostBase instance)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesInvoiceJournalPostBase_ApplicationSuite_Extension.run(SalesInvoiceJournalPostBase this)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesInvoiceJournalPostBase.SalesInvoiceJournalPostBaseCoCHelper.`run(SalesInvoiceJournalPostBase instance)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesInvoiceJournalPostBase.run()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesInvoiceJournalPost.`run()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesInvoiceJournalPost.SalesInvoiceJournalPostCoCHelper.`run(SalesInvoiceJournalPost instance)
at [Dynamics.AX.RevenueRecognition.dll]Dynamics.AX.Application.RevRecSalesInvoiceJournalPost_Extension.run(SalesInvoiceJournalPost this)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesInvoiceJournalPost.SalesInvoiceJournalPostCoCHelper.`run(SalesInvoiceJournalPost instance)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesInvoiceJournalPost.run()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterService.`postJournal(Common _parmTable)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterService.postJournal(Common _parmTable)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterService.`createAndPostJournal()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterService.createAndPostJournal()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterService.`processJournal(Printout _printout)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterService.FormletterServiceCoCHelper.`processJournal(FormletterService instance, Printout arg0)
at [Dynamics.AX.RevenueRecognition.dll]Dynamics.AX.Application.RevRecFormLetterService_Extension.processJournal(FormletterService this, Printout _printout)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterService.FormletterServiceCoCHelper.`processJournal(FormletterService instance, Printout arg0)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterService.processJournal(Printout _printout)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterService.`processFormLetterParmTable(Printout _printout)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterService.processFormLetterParmTable(Printout _printout)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterService.`runSingleThread(Printout _printout)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterService.runSingleThread(Printout _printout)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterService.`run()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterService.run()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterService.`postSalesOrderInvoice(SalesFormLetterInvoiceContract _contract)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterService.postSalesOrderInvoice(SalesFormLetterInvoiceContract _contract)
at FormletterService::postSalesOrderInvoice(Object , Object[] , Boolean& )
at [Microsoft.Dynamics.Ax.Xpp.Support.dll]Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeInstanceCall(Object instance, String MethodName, Object[] parameters)
at [Microsoft.Dynamics.Ax.Xpp.Support.dll]Microsoft.Dynamics.Ax.Xpp.DictClass.Callobject(String _methodName, XppObjectBase _Called, Object[] varArgs)
at [Dynamics.AX.ApplicationFoundation.dll]Dynamics.AX.Application.SysOperationServiceController.`runOperationInstance(SysOperationServiceController controller)
at [Dynamics.AX.ApplicationFoundation.dll]Dynamics.AX.Application.SysOperationServiceController.runOperationInstance(SysOperationServiceController controller)
at [Dynamics.AX.ApplicationFoundation.dll]Dynamics.AX.Application.SysOperationServiceController.`runOperationSynchronously()
at [Dynamics.AX.ApplicationFoundation.dll]Dynamics.AX.Application.SysOperationServiceController.runOperationSynchronously()
at [Dynamics.AX.ApplicationFoundation.dll]Dynamics.AX.Application.SysOperationServiceController.`run()
at [Dynamics.AX.ApplicationFoundation.dll]Dynamics.AX.Application.SysOperationServiceController.run()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormLetterServiceController.`run()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormLetterServiceController.run()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesFormLetter.`run()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesFormLetter.run()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesFormLetter_Invoice.`run()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesFormLetter_Invoice.SalesFormLetter_InvoiceCoCHelper.`run(SalesFormLetter_Invoice instance)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesFormLetter_InvoiceAppSuite_Extension.run(SalesFormLetter_Invoice this)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesFormLetter_Invoice.SalesFormLetter_InvoiceCoCHelper.`run(SalesFormLetter_Invoice instance)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesFormLetter_Invoice.run()
