Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Error in export data e...
Microsoft Dynamics AX (Archived)

Error in export data entity using Entity store

(0) ShareShare
ReportReport
Posted on by Community Member 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

*This post is locked for comments

  • 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,156 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.

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

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans