Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Cannot create a record...
Finance | Project Operations, Human Resources, ...
Answered

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

(0) ShareShare
ReportReport
Posted on by Akbarpasha

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

  • Crispin John Augustine Profile Picture
    Crispin John Augustine 37,081 on at
    RE: Cannot create a record in Alerts - event inbox data (EventInboxData). Inbox ID: **********.

    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

  • Akbarpasha Profile Picture
    Akbarpasha on at
    RE: Cannot create a record in Alerts - event inbox data (EventInboxData). Inbox ID: **********.

    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

  • Akbarpasha Profile Picture
    Akbarpasha on at
    RE: Cannot create a record in Alerts - event inbox data (EventInboxData). Inbox ID: **********.

    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

  • Verified answer
    Blue Wang Profile Picture
    Blue Wang on at
    RE: Cannot create a record in Alerts - event inbox data (EventInboxData). Inbox ID: **********.

    Hi Akbarpasha,

    Try to clear EventInbox table.

    Or try this method:

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

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,321 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans