SSIS Error Code DTS_E_OLEDBERROR 0x80004005

0

I am running an SSIS package that uses OLEDB connections to fetch data from and Oracle 10.2.0.5.0 database and insert it into an SQLServer 2012 (11.0.6260)

I get the following error.

Time: 2021-02-05 01:13:55 AM
Task: Data Flow Task
Error Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.

followed by

Time: 2021-02-05 01:13:55 AM
Task: Data Flow Task
Error Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on OLE DB Source returned error code 0xC0202009.  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.

There are no keys or constraints on the destination table.

Both of the dataflow tasks have CommandTimeout set to 0.

All of the other packages with the same source and destination databases run without any problem.

Edit 2

This particular package runs fine on our test/development environment.

I have sinced run the package several times and noticed that the source query returns about 4500 records but only about 500 are inserted into the destination database.

End Edit 2

Is there anything else that I can check for?

Edit 1

The Error message is as it appears in service manager.

Error Message

The log files just before the error are below.

enter image description here

The source Query is quite along running query. It takes approximately 9 minutes.

End Edit 1

sql-server
ssis
oledb
asked on Stack Overflow Feb 5, 2021 by Sarah Richardson • edited Feb 19, 2021 by Sarah Richardson

1 Answer

0

Logging into the oracle database directly with the user that is used for our integrations and running the query gave the following error.

oracle error ORA-02392

After increasing the size of the user profile the query returned data and the integrations ran correctly.

answered on Stack Overflow Feb 24, 2021 by Sarah Richardson

User contributions licensed under CC BY-SA 3.0