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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Error while exporting Inventory Aging Entity to Azure SQL Database

(0) ShareShare
ReportReport
Posted on by 575

Hello Guys,

I am getting the below error message when i export the entity through BYOD. please help me to fix this issue.

<?xml version="1.0"?><Errors><Error><ErrorCode>-1071636471</ErrorCode><SubComponent></SubComponent><Description>SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.</Description></Error><Error><ErrorCode>-1071607767</ErrorCode><SubComponent></SubComponent><Description>SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "OLE DB Destination.Inputs[OLE DB Destination Input]" failed because error code 0xC020907B occurred, and the error row disposition on "OLE DB Destination.Inputs[OLE DB Destination Input]" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.</Description></Error><Error><ErrorCode>-1073450974</ErrorCode><SubComponent></SubComponent><Description>SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "OLE DB Destination" (2) failed with error code 0xC0209029 while processing input "OLE DB Destination Input" (15). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.</Description></Error><Error><ErrorCode>-1071636284</ErrorCode><SubComponent></SubComponent><Description>The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020.</Description></Error><Error><ErrorCode>-1073450952</ErrorCode><SubComponent></SubComponent><Description>SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on Oledb Source returned error code 0xC02020C4. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.</Description></Error></Errors>

I have the same question (0)
  • David Bader Profile Picture
    on at

    Hi veera,

    Your issue looks to be related to exporting a data entity to BYODB in D365 F&O so I am going to move your post out of the General Forum to the D365 for Finance and Operations Forum for better visibility.

  • Suggested answer
    Sergei Minozhenko Profile Picture
    23,093 on at

    Hi veera AX,

    First, you need to check if entity mapping is up to date and schema in BYOD as well.

    1. Go to entity list and find you entity and regenerate mapping (Modify target mapping - Generate mapping)

    2. Republish entity to BYOD (Drop and publish again)

    3. Re-add entity to data project and try to export again

    4. Check if disabling "Skip staging" parameter will help (you can add it via personalization to "Selected entities" grid in data project).

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 669 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

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

#3
Martin Dráb Profile Picture

Martin Dráb 384 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans