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
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?
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?
Hi.
I am having the same issue.
Can you tell me how you have resolved the issue?
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.
@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!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.