SSIS Error Code 0x80004005 when getting data from Oracle

0

We have package that has been failing for a week now and I have been searching but could not find the valid solution to fix the issue.

The Data Flow task in the package where error was encountered are getting data from Oracle.

However, it failed with below error information (only the recent 3 errors listed).

1st Error:

  • Load Prestage:Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

2nd Error:

  • Load Prestage:Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on Retrieve From returned error code 0xC0202009. The component returned a failure code when the pipeline engine called PrimeOutput().

3rd Error:

  • Do Work (Transaction Required):Error: The SSIS Runtime has failed to commit the distributed transaction due to error 0x8004D019 "The transaction has already been aborted."

What I did to check the issue?

  • In the package, I tried executing that data flow task for multiple times. There are scenarios I encounter the error but mostly its running fine (though its running slow with 400k records).
  • I checked the PL SQL and it runs fine in Oracle with data.
  • I checked the generated data from Oracle and it seems no bad data.

Is there anyone here who can share their thoughts and possible solution to fix the issue?

sql-server
oracle
ssis
asked on Stack Overflow Oct 1, 2018 by Fritz joery Sondon • edited Oct 1, 2018 by sirandy

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0