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 :
Finance | Project Operations, Human Resources, ...
Answered

Cannot create a record in Alerts - event inbox data (EventInboxData). Inbox ID: **********.

(0) ShareShare
ReportReport
Posted on by

Hi All,

We are getting the below error in E-mail attachment distributor batch job history.

we tried the bleow link for updating the nexval , 

https://stoneridgesoftware.com/microsoft-dynamics-ax-error-the-record-already-exists/

Please advise us how we can resolve this issue.

"Cannot create a record in Alerts - event inbox data (EventInboxData). Inbox ID: 5637706741.
The record already exists."

""Microsoft.Dynamics.Ax.Xpp.DuplicateKeyException: Exception of type 'Microsoft.Dynamics.Ax.Xpp.DuplicateKeyException' was thrown.
at Microsoft.Dynamics.Ax.MSIL.Interop.throwException(Int32 ExceptionValue)
at Microsoft.Dynamics.Ax.MSIL.cqlCursorIL.insert(IntPtr table)
at Dynamics.Ax.Application.EventNotification.Create() in EventNotification.create.xpp:line 62
at Dynamics.Ax.Application.EventNotificationWorkflow.Create(Boolean _isGlobal, Boolean ) in EventNotificationWorkflow.create.xpp:line 11
at Dynamics.Ax.Application.SysEmailAttachment.Createeventnotification() in SysEmailAttachment.createEventNotification.xpp:line 1
at Dynamics.Ax.Application.SysEmailAttachment.Run() in SysEmailAttachment.run.xpp:line 10
at Dynamics.Ax.Application.SysEmailAttachmentNotificationBatch.Run() in SysEmailAttachmentNotificationBatch.run.xpp:line 18
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)"

I have the same question (0)
  • Verified answer
    Blue Wang Profile Picture
    Microsoft Employee on at

    Hi Akbarpasha,

    Try to clear EventInbox table.

    Or try this method:

    microsftdynamics.blogspot.com/.../when-submitting-timesheet-for-approval.html

  • Akbarpasha Profile Picture
    on at

    Thank you Blue Wang,

    If we clear(delete) the records from "EventInboxData" table, it will impact anything in the Production environment as I have already tried with the second option, still we are getting the same error.

    Can we delete the records from EventInboxData table in Production?

    Please advise us.

    Regards,

    Akbar

  • Akbarpasha Profile Picture
    on at

    Hi Blue Wang,

    we have done Full CIL, Full compile and DB synchronization in Production, the previous error is not appearing now , but getting the below error in " E-mail attachment distributor" batch job, it ending in error :

    "A currency to convert from is required to retrieve exchange rate information.

    Microsoft.Dynamics.Ax.Xpp.ErrorException: Exception of type 'Microsoft.Dynamics.Ax.Xpp.ErrorException' was thrown.

      at Dynamics.Ax.Application.ExchangeRateHelper.Handleerror(String _error, String _faultCode) in ExchangeRateHelper.handleError.xpp:line 23

      at Dynamics.Ax.Application.ExchangeRateHelper.Validatefromcurrency() in ExchangeRateHelper.validateFromCurrency.xpp:line 6

      at Dynamics.Ax.Application.ExchangeRateHelper.Getexchangerate1() in ExchangeRateHelper.getExchangeRate1.xpp:line 25

      at Dynamics.Ax.Application.Currency.exchRate(String _currencyCode, Date _exchRateDate, UnknownNoYes _exchRatesTriangulation, Boolean _showerror, NoYes _governmentExchRate, Boolean , Boolean , Boolean , Boolean ) in Currency.exchRate.xpp:line 18

      at Dynamics.Ax.Application.Currency.@exchRate(String _currencyCode, Date _exchRateDate, UnknownNoYes _exchRatesTriangulation, Boolean _showerror, Boolean , Boolean , Boolean )

      at Dynamics.Ax.Application.PurchTotals_Trans.Exchrate() in PurchTotals_Trans.exchRate.xpp:line 1

      at Dynamics.Ax.Application.PurchTotals.Calc(Boolean _excludePendingInvoices, Boolean _delayTaxCalc, Boolean _taxesOnly, Boolean , Boolean , Boolean ) in PurchTotals.calc.xpp:line 52

      at Dynamics.Ax.Application.PurchTotals.Calc()

      at Dynamics.Ax.Application.PurchPurchaseOrderProformaDP.Initpurchpurchaseorderheader() in PurchPurchaseOrderProformaDP.initPurchPurchaseOrderHeader.xpp:line 11

      at Dynamics.Ax.Application.PurchPurchaseOrderProformaDP.Setpurchpurchaseorderheader() in PurchPurchaseOrderProformaDP.setPurchPurchaseOrderHeader.xpp:line 18

      at Dynamics.Ax.Application.PurchPurchaseOrderProformaDP.Createdata(PurchPurchaseOrderProformaContract _contract) in PurchPurchaseOrderProformaDP.createData.xpp:line 21

      at Dynamics.Ax.Application.PurchPurchaseOrderProformaDP.Processreport() in PurchPurchaseOrderProformaDP.processReport.xpp:line 19

      at Dynamics.Ax.Application.SrsReportRunRdpPreProcessStrategy.Execute(Boolean _isPreview, Boolean ) in SrsReportRunRdpPreProcessStrategy.execute.xpp:line 39

      at Dynamics.Ax.Application.SrsReportRunRdpPreProcessService.Executewithcontract(SrsReportDataContract _reportContract, Int64 _preProcessedRecId, SrsReportDataProviderPreProcessInterface _rdpInstance, Boolean _isPreviewData, Boolean , Boolean , Boolean ) in SrsReportRunRdpPreProcessService.executeWithContract.xpp:line 82

      at Dynamics.Ax.Application.SrsReportRunRdpPreProcessService.@Executewithcontract(SrsReportDataContract _reportContract, Int64 _preProcessedRecId, SrsReportDataProviderPreProcessInterface _rdpInstance, Boolean , Boolean )

      at Dynamics.Ax.Application.SrsReportRunRdpPreProcessService.Executewithcontract(SrsReportDataContract _reportContract, Int64 _preProcessedRecId)

      at Dynamics.Ax.Application.SrsReportRunService.Prerunreport(SrsReportDataContract _reportContract) in SrsReportRunService.preRunReport.xpp:line 21

      at Dynamics.Ax.Application.SrsReportRunImpl.Prerunreport() in SrsReportRunImpl.preRunReport.xpp:line 12

      at Dynamics.Ax.Application.SrsReportRunController.Runreport() in SrsReportRunController.runReport.xpp:line 55

      at Dynamics.Ax.Application.SrsReportRunController.Run() in SrsReportRunController.run.xpp:line 27

      at Dynamics.Ax.Application.SysOperationController.Startoperation() in SysOperationController.startOperation.xpp:line 12

      at Dynamics.Ax.Application.SrsReportRunController.Startoperation() in SrsReportRunController.startOperation.xpp:line 12

      at Dynamics.Ax.Application.SysWorkflowApprovalWorkitemService.Generatereport(Int64 _configReportRecId, Int32 _contextTableId, Int64 _contextRecId) in SysWorkflowApprovalWorkitemService.generateReport.xpp:line 61

      at Dynamics.Ax.Application.SysWorkflowApprovalWorkitemService.Getattachmentcontent(Int64 _docuRefRecId, Int64 _configReportRecId, Int32 _contextTableId, Int64 _contextRecId) in SysWorkflowApprovalWorkitemService.getAttachmentContent.xpp:line 38

      at Dynamics.Ax.Application.SysEmailAttachment.generateAndSaveFileToDisk(Int64 _appConfigReportsRecId, Int32 _contextTableId, Int64 _contextRecId) in SysEmailAttachment.generateAndSaveFileToDisk.xpp:line 34

      at Dynamics.Ax.Application.SysEmailAttachment.generateAttachment(String _workflowElementName, Int32 _contextTableId, Int64 _contextRecId) in SysEmailAttachment.generateAttachment.xpp:line 29

      at Dynamics.Ax.Application.EventNotificationWorkflow.Sendmail(Boolean _isGlobalEmailTemplate, Boolean ) in EventNotificationWorkflow.sendMail.xpp:line 30

      at Dynamics.Ax.Application.EventNotificationWorkflow.Create(Boolean _isGlobal, Boolean ) in EventNotificationWorkflow.create.xpp:line 31

      at Dynamics.Ax.Application.SysEmailAttachment.Createeventnotification() in SysEmailAttachment.createEventNotification.xpp:line 1

      at Dynamics.Ax.Application.SysEmailAttachment.Run() in SysEmailAttachment.run.xpp:line 10

      at Dynamics.Ax.Application.SysEmailAttachmentNotificationBatch.Run() in SysEmailAttachmentNotificationBatch.run.xpp:line 18

      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)"

    Please advise how to resolve this issue.

    Regards,

    Akbar

  • Crispin John Augustine Profile Picture
    37,081 on at

    the first line tells the error, doesn't it?
    CurrencyCode field is not setup in one of the tables involved. If you set it up, this error should disappear

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 689

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 606 Super User 2026 Season 1

#3
CP04-islander Profile Picture

CP04-islander 356

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans