SAS/ACCESS Oracle readbuff error

Quentin — Fri, 06 Jun 2014 15:10:28 GMT

Hi All,

I have code that is pulling data from an Oracle database and uses readbuff option.

Code runs fine on our Linux server using SAS/ACCESS to Oracle.

On a Windows server using SAS/ACCESS to ODBC, it crashes with a traceback error.

Both servers are 9.3.

I haven't tested it much, cuz the Windows server admin doesn't like it when I do. (Query is run by a stored process, I think it might actually cause a process to hang, but I don't have enough rights on the box to see).

Just wondering if anyone else has seen this? It's a small table.

Seems like:

http://support.sas.com/kb/17/006.html

Example below, I get similar error using a libname with implicit pass-through.

6870      +proc sql;
6871      +  Connect to odbc(datasrc=... readbuff=250);
ODBC: AUTOCOMMIT is YES for connection 0
6872      +
6873      +  Select * from Connection to odbc
6874      +  (select * from Mytable)
6875      +  ;
 
ODBC_49: Prepared: on connection 0
select * from Mytable 
 
ODBC_50: Executed: on connection 0
Prepared statement ODBC_49
 
ERROR:  An exception has been encountered.
Please contact technical support and provide them with the following traceback 
       information:
 
The SAS task name is [SQL (52)]
ERROR:  Read Access Violation SQL (52)
Exception occurred at (02D10425)
Task Traceback
Address   Frame     (DBGHELP API Version 4.0 rev 5)
0000000002D10425  000000000A09D5F0  saswob:tkvercn1+0xF3E5
00000000078C380F  000000000A09D5F8  saswobc:tkvercn1+0x27CF
00000000075F7C58  000000000A09D738  sasods:tkvercn1+0x186C18
00000000075FE619  000000000A09D830  sasods:tkvercn1+0x18D5D9
000000000753173C  000000000A09DBB0  sasods:tkvercn1+0xC06FC
00000000083D9828  000000000A09DBB8  sasoda:tkvercn1+0x287E8
00000000083C5E21  000000000A09E230  sasoda:tkvercn1+0x14DE1
00000000083C23C8  000000000A09EC30  sasoda:tkvercn1+0x11388
0000000008CA2488  000000000A09EC38  sasmrk:tkvercn1+0xD1448
0000000008C46B86  000000000A09ECF0  sasmrk:tkvercn1+0x75B46
00000000085BDB88  000000000A09ECF8  sasxml:tkvercn1+0x5CB48
0000000008562FB3  000000000A09EE10  sasxml:tkvercn1+0x1F73
00000000083D9828  000000000A09EE50  sasoda:tkvercn1+0x287E8
00000000083C02E5  000000000A09F2F0  sasoda:tkvercn1+0xF2A5
00000000075F7C58  000000000A09F330  sasods:tkvercn1+0x186C18
00000000074A2628  000000000A09F550  sasods:tkvercn1+0x315E8
00000000074A1EA9  000000000A09F650  sasods:tkvercn1+0x30E69
0000000007D555A8  000000000A09F658  sassqx:tkvercn1+0x44568
0000000007D39238  000000000A09F750  sassqx:tkvercn1+0x281F8
0000000007D37827  000000000A09F870  sassqx:tkvercn1+0x267E7
0000000007D39F8D  000000000A09F8D0  sassqx:tkvercn1+0x28F4D
0000000007D481BB  000000000A09F920  sassqx:tkvercn1+0x3717B
0000000007D406CD  000000000A09FC20  sassqx:tkvercn1+0x2F68D
0000000007A0132A  000000000A09FC28  sassql:tkvercn1+0x2EA
0000000001D28FD7  000000000A09FCB8  sashost:Main+0xF917
0000000001D2D5FD  000000000A09FF50  sashost:Main+0x13F3D
00000000776959ED  000000000A09FF58  kernel32:BaseThreadInitThunk+0xD
00000000778CC541  000000000A09FF88  ntdll:RtlUserThreadStart+0x21

Yes, I know it says to contact tech support. I would if I really needed a solution at this point (I can live with the defaults readbuff as it's a small table) , and if I could do more testing. It's mostly Friday curiousity.

--Q.

Re: SAS/ACCESS Oracle readbuff error

Koos — Fri, 27 Jan 2017 23:34:20 GMT

Hi, I have the same problem on Linux. See http://support.sas.com/kb/57/877.html. The readbuff does not seem to work well with the oracle client, so rather set the FetchBufferSize.

topic SAS/ACCESS Oracle readbuff error in SAS Programming

SAS/ACCESS Oracle readbuff error

Re: SAS/ACCESS Oracle readbuff error