Skip to main content

Notifications

Microsoft Dynamics AX forum
Answered

Error in export data entity using Entity store

Posted on by Microsoft Employee

I get the following error when exporting data using data entity to an external database -"An Error occurred in add data flow component for Entity Store"

Any resolutions will be helpful

Found the following support article but resolution is not clear

support.microsoft.com/.../4020330

Categories:
  • Kannan01 Profile Picture
    Kannan01 65 on at
    RE: Error in export data entity using Entity store

    Check if you have any virtual fields added in your entity.

    If you have written any logic in mapEntityToDataSource() or postLoad() for any of virtual fields, then set "Skip Staging" as "No" while exporting data from D365 FO

  • Suggested answer
    yijun.lin Profile Picture
    yijun.lin 5 on at
    RE: Error in export data entity using Entity store

    Please use the sqlserver user,not the ad user for the entity store configure.

    Eg:Data Source =.; Initial Catalog=myByod;Integrated Security=true; User ID=sa; Password=**

  • nmaenpaa Profile Picture
    nmaenpaa 101,148 on at
    RE: Error in export data entity using Entity store

    Yes, you can find a verified answer above your own message. If you still have issues, please share more information about your issue, and any possible solutions that you tried.

    Also, please don't use tag Dynamics 365 in your message since all messages on this forum are about Dynamics 365. Therefore it doesn't make sense to use such tag.

  • anil1268 Profile Picture
    anil1268 222 on at
    RE: Error in export data entity using Entity store

    Any one resolved this issue, please let me know I am facing it too. Thanks.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error in export data entity using Entity store

    I got this error because SQL credentials were not part of connection string .After giving the credentials , issue was solved

  • Suggested answer
    Percy Nxumalo Profile Picture
    Percy Nxumalo 115 on at
    RE: Error in export data entity using Entity store

    I resolved the issue by re-publishing several times.  

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error in export data entity using Entity store

    When you use BYOD, keep in mind that you have to whitelist IP Addresses to be able to access the Azure SQL Database. So I recommend opening a support case to retrieve your D365 externally facing IP Addresses so that you can whitelist them in Azure SQL. Below is an article that may help you find the IP Address without opening a support case:

    blogs.msdn.microsoft.com/.../dynamics-365-for-finance-and-operations-static-ip-addresses

  • Wouter Mijle Profile Picture
    Wouter Mijle 65 on at
    RE: Error in export data entity using Entity store

    Hi Rahul,

    we already tried re-publishing it several times, but without success. The source names in BYOD seem to be equal to the D365FO names...

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error in export data entity using Entity store

    A lot of time republishing the entity from entity store could help. Also use the option of compare source names would give the delta between D365 and BYODW schema.

  • JackB Profile Picture
    JackB on at
    RE: Error in export data entity using Entity store

    I had an open ticket with MSFT and they said it was an issue that the Product Team identified. Not sure if it has since been corrected with a KB hotfix.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,186 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 227,996 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans