web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

D365 BYOD Export Failed with no Errors

(0) ShareShare
ReportReport
Posted on by 19

I am trying to export a single entity to a Sql database. Schema creations happened successfully. But when I do the export it failed with no errors. How can I find the cause? 

I have the same question (0)
  • Mohit Rampal Profile Picture
    12,565 Moderator on at

    Hi, Please check if there is anything in 'View Execution Log'

  • Nissanka Profile Picture
    19 on at

    This is the log "Export execution failed for entity DAXV Customer Transaction: Export failed while copying data from staging to target:"

    How can I resolve this

  • Mohit Rampal Profile Picture
    12,565 Moderator on at

    Please confirm that data entity is published. If yes, then try exporting to excel or csv file. If you are using incremental push then change to full push and export. Also, dropping the entity and re-publishing might help.

  • Nissanka Profile Picture
    19 on at

    Yes entity is published and schema is created in BYOD database as well. I tried exporting to a csv is says successfully ended. but were can I find the csv file. Also I tried deleting the index as mentioned in another post and exporting to BYOD. But still did not work

    "<?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:

    "

    "Export execution failed for entity Inventory historical transaction for legacy system: Export failed while copying data from staging to target:"

  • Mohit Rampal Profile Picture
    12,565 Moderator on at

    Is the other data entities working for BYOD? If yes, then try dropping and re publishing the data entity.

  • Nissanka Profile Picture
    19 on at

    it is same with other entities too.

  • Mohit Rampal Profile Picture
    12,565 Moderator on at

    Right, Please check if you can access BYOD database. Is the BYOD database created in Devbox or it's Azure SQL database used in Sandbox or prod environment?

    global.hitachi-solutions.com/.../

  • Nissanka Profile Picture
    19 on at

    It is an azure SQL database. I am testing this uat snadbox environment. I have followed the same steps as in the link.

  • Mohit Rampal Profile Picture
    12,565 Moderator on at

    It seems issue with BYOD database. Can you validate connection string and connect to BYOD database from SQL server. Please share screenshot of 'configure entity export to database' form.

  • Nissanka Profile Picture
    19 on at

    yes as I said even the schema creation happens for staging tables when I publish entities.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 514 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 390

#3
Adis Profile Picture

Adis 266 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans