BookmarkSubscribeRSS Feed
Quentin
Super User

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.

BASUG is hosting free webinars Next up: Jane Eslinger presenting PROC REPORT and the ODS EXCEL destination on Mar 27 at noon ET. Register now at the Boston Area SAS Users Group event page: https://www.basug.org/events.
1 REPLY 1
Koos
Calcite | Level 5

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.

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
  • 1 reply
  • 590 views
  • 0 likes
  • 2 in conversation