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