You’re offline. This is a read only version of the page.
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?
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.
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?
Is the other data entities working for BYOD? If yes, then try dropping and re publishing the data entity.
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:"
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.
Hi, Please check if there is anything in 'View Execution Log'
#1
André Arnaud de Cal...
291,965
Super User 2025 Season 1
#2
Martin Dráb
230,836
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
