topic Re: Error ORA-03113: end-of-file on communication channel in SAS Programming

Error ORA-03113: end-of-file on communication channel

_Olga_ — Tue, 26 Sep 2017 08:01:26 GMT

Hello!

I have next problem.

How can I solve it?

Thanks for help.

Table libOra.table has 24 991 461 records.

Code:

libname libOra ORACLE SCHEMA=myschema PATH=mypath USER='myuser' PASSWORD="mypass";

libname libSAS '/mypath';

data libSAS.table (compress=char);

set libOra.table;

run;　

Log:

ERROR: Error fetching from cursor. ORACLE error is ORA-03113: end-of-file on communication channel

NOTE: The DATA step has been abnormally terminated.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: There were 17448750 observations read from the data set libOra.table.

WARNING: The data set libSAS.table may be incomplete.　 When this step was stopped there were 17448750 observations and 34

　　　　　　　　　variables.

NOTE: Compressing data set libSAS.table decreased size by 81.80 percent.

　　　　　　Compressed is 397068 pages; un-compressed would require 2181094 pages.

WARNING: Data set libSAS.table was not replaced because this step was stopped.

NOTE: DATA statement used (Total process time):

　　　　　 real time　　　　　　　　　　 13:23:03.33

　　　　　 cpu time　　　　　　　　　　　 15:16.03

Re: Error ORA-03113: end-of-file on communication channel

Kurt_Bremser — Wed, 22 Mar 2017 07:54:17 GMT

The error is internal between the Oracle server and the Oracle client (that SAS uses for the connection). The most likely cause (IMO) is a network problem.

Maybe one of the routers/firewalls in between cuts off the connection after a given time?

See http://www.orafaq.com/wiki/ORA-03113

Re: Error ORA-03113: end-of-file on communication channel

SASKiwi — Wed, 22 Mar 2017 07:56:38 GMT

Just guessing but I suspect that there is a timeout rule on the SAS - Oracle communications channel / port, possibly caused by a firewall around your SAS or Oracle server. I suggest you check with your SAS administrators or your IT network specialists to get them to check this out.

Re: Error ORA-03113: end-of-file on communication channel

Kurt_Bremser — Wed, 22 Mar 2017 07:58:59 GMT

@SASKiwi wrote:

Just guessing but I suspect that there is a timeout rule on the SAS - Oracle communications channel / port, possibly caused by a firewall around your SAS or Oracle server. I suggest you check with your SAS administrators or your IT network specialists to get them to check this out.

Two minds, one thought 😉

Across the globe, at that!

Re: Error ORA-03113: end-of-file on communication channel

Bipasha — Thu, 28 Jun 2018 09:33:41 GMT

Hi.

I am having the same issue.

Can you tell me how you have resolved the issue?