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

Hello!

 

I have next problem.

How can I solve it?

Thanks for help.

 

Table EID.BKI_INFO has 24 991 461 records.

 

Code:

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

libname mbank '/mypath';

 

data mbank.EID_BKI_INFO (compress=char);

set EID.BKI_INFO;

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 EID.BKI_INFO.

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

         variables.

NOTE: Compressing data set MBANK.EID_BKI_INFO decreased size by 81.80 percent.

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

WARNING: Data set MBANK.EID_BKI_INFO 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: 6,941

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: 6,941

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,110

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: 6,941

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
  • 792 views
  • 0 likes
  • 3 in conversation