Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Dynamic 365 Data Export to BYOD

(0) ShareShare
ReportReport
Posted on by 19

I want to export data entities to a sql database. I have configured the BYOD and published the data entities. Also the schemas have been created in Sql database. But when I try to export getting this error. 
How to resolve this?

<?xml version="1.0"?><Errors><Error><ErrorCode>-2146233088</ErrorCode><SubComponent>Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper</SubComponent><Description>DMF2008 - at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFEntityDBPackageExport.AddEntityDBDataFlowComponent(Package package, String commandText)
at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFPackageControllerEntityDB.CreateAndExecutePackage(DMFEntityDBHelper entityDBHelper)
at DMFExecutePackage.PackageCreator.processByodEntity()
at DMFExecutePackage.Program.Main(String[] args)</Description></Error><Error><ErrorCode>-1071611876</ErrorCode><SubComponent>Microsoft.SqlServer.DTSPipelineWrap</SubComponent><Description>Exception from HRESULT: 0xC020801C - at Microsoft.SqlServer.Dts.Pipeline.Wrapper.CManagedComponentWrapperClass.AcquireConnections(Object pTransaction)
at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFEntityDBPackageExport.AddEntityDBDataFlowDestinationComponent(Package package, MainPipe dataFlowTask, IDTSComponentMetaData100 rowCountComponent)
at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFEntityDBPackageExport.AddEntityDBDataFlowComponent(Package package, String commandText)</Description></Error></Errors>
error labelId:

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 13,564 Super User 2025 Season 1 on at
    RE: Dynamic 365 Data Export to BYOD

    Hi Nissanka,

    When you choose the entity and click on "Modify target mapping", you will get warning over disabled fields.

  • Nissanka Profile Picture
    Nissanka 19 on at
    RE: Dynamic 365 Data Export to BYOD

    I tried both incremental and full push after enabling change tracking. Can you please tell me how to check if there are disabled fields?

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 13,564 Super User 2025 Season 1 on at
    RE: Dynamic 365 Data Export to BYOD

    Hi Nissanka,

    Do you export data in full push or incremental mode? Please check if there is/are disabled fields on for the entity and try to delete disabled field , after approval of reporting team, then publish the entity against your Azure SQL DB and create a new export job and run a full push export.

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…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans