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
User contributions licensed under CC BY-SA 3.0