Page 1 of 1

End-Of-File communication channel

Posted: Thu Jan 12, 2017 8:48 am
by jerome_rajan
Hi,
One of our jobs that loads a large volume into the table finishes with the warning -

The OCI function OCISessionEnd returned status -1. Error code: 3,113, Error message: ORA-03113: end-of-file on communication channel


I'd expect such communication failures to result in aborts and not just warnings. Is there a parameter that needs to be turned on?

Posted: Thu Jan 12, 2017 9:39 am
by chulett
What stage are you using? One of them (from what I recall) had a "treat warning as error" in the past, not sure if that still exists.

Posted: Thu Jan 12, 2017 12:28 pm
by qt_ky
We used to get that warning (or error) when the firewall would close off our database connection. We had to work with our firewall team to resolve it.

Good memory, Craig. The Connector has a setting "Process warning messages as fatal error" with a default of No.