SSIS job fails intermitently with the message "Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED"

0

Our BI team has a couple SSIS job that run every night and one that runs weekly. They all fail intermittently. One of the daily and the weekly are run against an Oracle 11.2.0.3 database (that I support). The error is the one I posted above. The whole message is as follows:

The PrimeOutput method on Oracle Source returned error code 0x80004005.  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.

The error handling was triggered at: 6/24/2016 12:33:44 AM

failed with the errorcode: 704 OCI error encountered. ORA-03113: end-of-file 
on communication channel Process ID: 25372 Session ID: 1239 Serial number: 
3317

These 2 jobs connect to an idle instance of the Oracle database - We have an Active/Passive configuration -. The server hosting this Oracle instance is running RHEL.

No errors are found in alert.log or listener.log and our network team couldn't find bottlenecks (network usage is about 30%) they couldn't find dropped packages either.

Is there something else I need to check on the Oracle side of things that you can think of?

Appreciated

oracle11g
ssis
oci
ora-03113
asked on Stack Overflow Sep 10, 2018 by F. Gil

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0