End-Of-File communication channel

jerome_rajan · Post by **jerome_rajan** » Thu Jan 12, 2017 8:48 am

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?

chulett · Post by **chulett** » Thu Jan 12, 2017 9:39 am

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.

qt_ky · Post by **qt_ky** » Thu Jan 12, 2017 12:28 pm

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.