Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Export data entity in ...
Finance | Project Operations, Human Resources, ...
Suggested answer

Export data entity in d365

(0) ShareShare
ReportReport
Posted on by Anusha Redy 60

HI,

I am trying to export data entity iam geeting these error

System.Exception: Exception from HRESULT: 0xC02020E8

   at Microsoft.Dynamics.AX.Framework.Tools.DMF.ServiceProxy.DmfEntitySharedTypesProxy.DoWork[T](Func`1 work)​
   at Dynamics.AX.Application.DMFGenerateSSISPackage.`generateFileDataV2(DMFDefinitionGroupExecution _dmfDefinitionGroupExecution, String _defGroupName, DMFFileFormat _fileFormat, DMFDelimiter _rowDelimiter, DMFDelimiter _columnDelimiter, String _codePage, String _locale, NoYes _isFirstRowHeader, NoYes _unicode, String _source, String _textQualifier, DMFXMLStyle _style, String _rootElement, String _filePath, Map _entitySyncVersion, Int32 _previewCount, Boolean @_entitySyncVersion_IsDefaultSet, Boolean @_previewCount_IsDefaultSet) in xppSource://Source/ApplicationFoundation\AxClass_DMFGenerateSSISPackage.xpp:line 1273​
Thanks,
Anusha.
  • Suggested answer
    andreasraithel Profile Picture
    andreasraithel 4,820 Super User 2024 Season 2 on at
    Export data entity in d365
    It is always a good idea to be sure that the entity meta data are refershed and up-to-date.
    Go to Data management/Data import/export framework parameters/Entity settings/Refresh entity list
     
    Hope this helps.
    Herzliche Grüße / kind regards,
     
    Andreas Raithel
    D365FO Solution Architect
  • BADRI NARAYANAN G Profile Picture
    BADRI NARAYANAN G 167 on at
    Export data entity in d365
    Hi Friends,I got the same error for one of my custom entities.
     
    I followed the steps mentioned by Gustavo Vivancos.
     
    After that my issue was rectified.
     
    Thanks
    Badri
  • Zen_Raj Profile Picture
    Zen_Raj 177 on at
    RE: Export data entity in d365

    Thank you Gustavo, this solved my issue after hours of searching. Just had to skip staging to no.

  • Gustavo Vivancos Profile Picture
    Gustavo Vivancos 32 on at
    RE: Export data entity in d365

    Hi. I faced an error thtat is quite similar:

    "Error adding updating OLEDB source properties-Exception from HRESULT: 0xC0202009"

    It failed always with the same entity/ies without any apparent reason.

    To solve it, I do the following steps:

    1) Remove the entity from list of entities to export

    2) Open the Add dialog, one or multiple entities, doesn't matter

    3) Select the entity

    4) Set the field "Skip staging" to No

    5) Fill the other required fields and insert the entity

    Now, you should be able to export the entity without error.

    Best wishes.

  • nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: Export data entity in d365

    I'm very sorry but I don't think I'm able to provide more help, with the information that I have received.

    Also if you share some error message without any context, it's unfortunately not helpful at all.

    Hopefully you get your problem resolved with the small pieces of advice that I provided!

  • Anusha Redy Profile Picture
    Anusha Redy 60 on at
    RE: Export data entity in d365

    Error adding updating OLEDB source properties-Exception from HRESULT: 0xC0202009

  • Anusha Redy Profile Picture
    Anusha Redy 60 on at
    RE: Export data entity in d365

    in that entity has two data sources, in that tables has some code in x++

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: Export data entity in d365

    Ok, so something is wrong with that entity.

    Is there something special about this entity, or is it an entity with exactly one data source and no x++ code?

    Did it work ever before?

    I suggest you compare it to standard entity that is working correctly.

    If you need more help from us, please share much more information about your entity. Right now we don't know anything so it's hard to guess what could be wrong.

  • Anusha Redy Profile Picture
    Anusha Redy 60 on at
    RE: Export data entity in d365

    i am geeting this error for specific entity, yes it is a custom entity .

  • nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: Export data entity in d365

    Do you get this error with some specific entity or all entities?

    If only one, is it some custom entity that you developed?

    If yes, is there something special in this entity?

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,684 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,414 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