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-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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