BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
_Olga_
Calcite | Level 5

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

1 ACCEPTED SOLUTION

Accepted Solutions
Kurt_Bremser
Super User

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

View solution in original post

4 REPLIES 4
Kurt_Bremser
Super User

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

Bipasha
Obsidian | Level 7

Hi.

 

I am having the same issue.

 

Can you tell me how you have resolved the issue?

SASKiwi
PROC Star

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.

Kurt_Bremser
Super User

@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!

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 28199 views
  • 0 likes
  • 4 in conversation