DATA Step, Macro, Functions and more

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

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

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

[ Edited ]

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


Accepted Solutions
Solution
‎03-22-2017 04:17 AM
Super User
Posts: 7,768

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

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Solution
‎03-22-2017 04:17 AM
Super User
Posts: 7,768

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

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Posts: 3,252

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

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.

Super User
Posts: 7,768

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

[ Edited ]

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 Smiley Wink

 

Across the globe, at that!

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 1973 views
  • 0 likes
  • 3 in conversation