Problem Note 52776: A Read access violation occurs when you run a query against an SAP table in a SAS® double-byte character set (DBCS) encoding
 |  |  |  |  |
When you use the COUNT function in an SQL query against an SAP table via the metadata LIBNAME engine, the query fails with a Read access violation that is similar to the following:.
ERROR: An exception has been encountered. Please contact technical support and provide them with the following traceback information: The SAS task name is [SQL] ERROR: Read Access Violation SQL Exception occurred at (04AB5FD3) Task Traceback Address Frame (DBGHELP API Version 4.0 rev 5) 0000000004AB5FD3 000000000CD8D2F0 saswzsd:tkvercn1+0x14F93 0000000004AAB96D 000000000CD8D770 saswzsd:tkvercn1+0xA92D 000000000CE3AAD0 000000000CD8D778 sassqlu:tkvercn1+0x39A90 000000000CE29367 000000000CD8D9C0 sassqlu:tkvercn1+0x28327 000000000CE278D1 000000000CD8E090 sassqlu:tkvercn1+0x26891 000000000CE26770 000000000CD8E160 sassqlu:tkvercn1+0x25730 000000000CE2F5B6 000000000CD8E3F0 sassqlu:tkvercn1+0x2E576 000000000CE15632 000000000CD8E5B0 sassqlu:tkvercn1+0x145F2 000000000CE1D2AC 000000000CD8E850 sassqlu:tkvercn1+0x1C26C 000000000CE2144A 000000000CD8E960 sassqlu:tkvercn1+0x2040A 000000000CE0B895 000000000CD8ECB0 sassqlu:tkvercn1+0xA855 000000000C6DE35D 000000000CD8ECB8 sassqlp:tkvercn1+0x3D31D 000000000C6DCD8A 000000000CD8F630 sassqlp:tkvercn1+0x3BD4A 000000000C6CE4C2 000000000CD8F820 sassqlp:tkvercn1+0x2D482 000000000C6FA84D 000000000CD8F920 sassqlp:tkvercn1+0x5980D 000000000C5D03A1 000000000CD8F928 sassqx:tkvercn1+0x2F361 000000000B5B132A 000000000CD8FC28 sassql:tkvercn1+0x2EA 0000000003408FD7 000000000CD8FCB8 sashost:Main+0xF917 000000000340D5FD 000000000CD8FF50 sashost:Main+0x13F3D 0000000077ACF56D 000000000CD8FF58 kernel32:BaseThreadInitThunk+0xD 0000000077C03281 000000000CD8FF88 ntdll:RtlUserThreadStart+0x21
The following example code causes the Read access violation:
libname x meta library="SAP-library";
proc sql;
select(count(t1.mandt)) as calculation
from x. t1;
quit;
To work around this problem, use the SAP engine to access the table.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | Base SAS | z/OS | 9.3_M1 | 9.3 TS1M1 | ||
| Z64 | 9.3_M1 | 9.3 TS1M1 | ||||
| Microsoft® Windows® for x64 | 9.3_M1 | 9.3 TS1M1 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 9.3_M1 | 9.3 TS1M1 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 9.3_M1 | 9.3 TS1M1 | ||||
| Microsoft Windows Server 2003 Standard Edition | 9.3_M1 | 9.3 TS1M1 | ||||
| Microsoft Windows Server 2003 for x64 | 9.3_M1 | 9.3 TS1M1 | ||||
| Microsoft Windows Server 2008 | 9.3_M1 | 9.3 TS1M1 | ||||
| Microsoft Windows Server 2008 R2 | 9.3_M1 | 9.3 TS1M1 | ||||
| Microsoft Windows Server 2008 for x64 | 9.3_M1 | 9.3 TS1M1 | ||||
| Microsoft Windows XP Professional | 9.3_M1 | 9.3 TS1M1 | ||||
| Windows 7 Enterprise 32 bit | 9.3_M1 | 9.3 TS1M1 | ||||
| Windows 7 Enterprise x64 | 9.3_M1 | 9.3 TS1M1 | ||||
| Windows 7 Home Premium 32 bit | 9.3_M1 | 9.3 TS1M1 | ||||
| Windows 7 Home Premium x64 | 9.3_M1 | 9.3 TS1M1 | ||||
| Windows 7 Professional 32 bit | 9.3_M1 | 9.3 TS1M1 | ||||
| Windows 7 Professional x64 | 9.3_M1 | 9.3 TS1M1 | ||||
| Windows 7 Ultimate 32 bit | 9.3_M1 | 9.3 TS1M1 | ||||
| Windows 7 Ultimate x64 | 9.3_M1 | 9.3 TS1M1 | ||||
| Windows Vista | 9.3_M1 | 9.3 TS1M1 | ||||
| Windows Vista for x64 | 9.3_M1 | 9.3 TS1M1 | ||||
| 64-bit Enabled AIX | 9.3_M1 | 9.3 TS1M1 | ||||
| 64-bit Enabled HP-UX | 9.3_M1 | 9.3 TS1M1 | ||||
| 64-bit Enabled Solaris | 9.3_M1 | 9.3 TS1M1 | ||||
| HP-UX IPF | 9.3_M1 | 9.3 TS1M1 | ||||
| Linux | 9.3_M1 | 9.3 TS1M1 | ||||
| Linux for x64 | 9.3_M1 | 9.3 TS1M1 | ||||
| Solaris for x64 | 9.3_M1 | 9.3 TS1M1 | ||||
A fix for this issue for Base SAS 9.3_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/I22.html#52776| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2014-04-17 11:30:57 |
| Date Created: | 2014-04-16 16:47:34 |