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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.