web
You’re offline. This is a read only version of the page.
close
Skip to main content
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,563 Moderator on at
    RE: D365 BYOD Export Failed with no Errors

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

  • Nissanka Profile Picture
    19 on at
    RE: D365 BYOD Export Failed with no Errors

    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,563 Moderator on at
    RE: D365 BYOD Export Failed with no Errors

    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
    RE: D365 BYOD Export Failed with no Errors

    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,563 Moderator on at
    RE: D365 BYOD Export Failed with no Errors

    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
    RE: D365 BYOD Export Failed with no Errors

    it is same with other entities too.

  • Mohit Rampal Profile Picture
    12,563 Moderator on at
    RE: D365 BYOD Export Failed with no Errors

    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
    RE: D365 BYOD Export Failed with no Errors

    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,563 Moderator on at
    RE: D365 BYOD Export Failed with no Errors

    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
    RE: D365 BYOD Export Failed with no Errors

    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 813

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 738 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 566 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans