Problem Note 56978: A Read access violation error might occur when you are running an SQL procedure query
 |  |  |  |  |
When you access a database management system (DBMS), if you use the LIBNAME engine and an SQL query that includes a function that is not passed down to the DBMS, a Read access violation might occur. The error might look 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 (0A61DB82) Task Traceback Address Frame (DBGHELP API Version 4.0 rev 5) 000000000A61DB82 000000000771CB40 sassqlu:tkvercn1+0x2CB42 000000000A620AB5 000000000771CC00 sassqlu:tkvercn1+0x2FA75 000000000A610AB0 000000000771D020 sassqlu:tkvercn1+0x1FA70 000000000A615ABF 000000000771D1A0 sassqlu:tkvercn1+0x24A7F 000000000A60A00B 000000000771D440 sassqlu:tkvercn1+0x18FCB 000000000A6158C8 000000000771D5C0 sassqlu:tkvercn1+0x24888 000000000A60A6B4 000000000771D860 sassqlu:tkvercn1+0x19674 000000000A6158C8 000000000771D9E0 sassqlu:tkvercn1+0x24888 000000000A6152C6 000000000771DB60 sassqlu:tkvercn1+0x24286 000000000A61EA66 000000000771DE50 sassqlu:tkvercn1+0x2DA26 000000000A61A64C 000000000771E100 sassqlu:tkvercn1+0x2960C 000000000A605717 000000000771E330 sassqlu:tkvercn1+0x146D7 000000000A60DED1 000000000771E5D0 sassqlu:tkvercn1+0x1CE91 000000000A6158C8 000000000771E750 sassqlu:tkvercn1+0x24888 000000000A5FB8BA 000000000771ECB0 sassqlu:tkvercn1+0xA87A 000000000AC8EA14 000000000771ECB8 sassqlp:tkvercn1+0x3D9D4 000000000AC8D41E 000000000771F630 sassqlp:tkvercn1+0x3C3DE 000000000AC7EA92 000000000771F820 sassqlp:tkvercn1+0x2DA52 000000000ACAD50D 000000000771F920 sassqlp:tkvercn1+0x5C4CD 000000000A5005D1 000000000771F928 sassqx:tkvercn1+0x2F591 000000000A05132A 000000000771FC28 sassql:tkvercn1+0x2EA 0000000003798FD7 000000000771FCB8 sashost:Main+0xF917 000000000379D61D 000000000771FF50 sashost:Main+0x13F5D 00000000776459CD 000000000771FF58 kernel32:BaseThreadInitThunk+0xD 00000000779DB891 000000000771FF88 ntdll:RtlUserThreadStart+0x21
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | HP-UX IPF | 9.3 TS1M2 | 9.4 TS1M3 |
| 64-bit Enabled Solaris | 9.3 TS1M2 | 9.4 TS1M3 | ||
| Linux | 9.3 TS1M2 | 9.4 TS1M3 | ||
| Solaris for x64 | 9.3 TS1M2 | 9.4 TS1M3 | ||
| Linux for x64 | 9.3 TS1M2 | 9.4 TS1M3 | ||
| 64-bit Enabled HP-UX | 9.3 TS1M2 | 9.4 TS1M3 | ||
| 64-bit Enabled AIX | 9.3 TS1M2 | 9.4 TS1M3 | ||
| Windows Vista | 9.3 TS1M2 | |||
| Windows Vista for x64 | 9.3 TS1M2 | |||
| Windows 7 Ultimate x64 | 9.3 TS1M2 | 9.4 TS1M3 | ||
| Windows 7 Ultimate 32 bit | 9.3 TS1M2 | 9.4 TS1M3 | ||
| Windows 7 Professional x64 | 9.3 TS1M2 | 9.4 TS1M3 | ||
| Windows 7 Professional 32 bit | 9.3 TS1M2 | 9.4 TS1M3 | ||
| Windows 7 Home Premium 32 bit | 9.3 TS1M2 | 9.4 TS1M3 | ||
| Windows 7 Home Premium x64 | 9.3 TS1M2 | 9.4 TS1M3 | ||
| Windows 7 Enterprise x64 | 9.3 TS1M2 | 9.4 TS1M3 | ||
| Windows 7 Enterprise 32 bit | 9.3 TS1M2 | 9.4 TS1M3 | ||
| Microsoft Windows XP Professional | 9.3 TS1M2 | |||
| Microsoft Windows Server 2012 Std | 9.3 TS1M2 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2012 R2 Std | 9.3 TS1M2 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.3 TS1M2 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2012 Datacenter | 9.3 TS1M2 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2008 for x64 | 9.3 TS1M2 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2008 | 9.3 TS1M2 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2008 R2 | 9.3 TS1M2 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2003 for x64 | 9.3 TS1M2 | |||
| Microsoft Windows Server 2003 Standard Edition | 9.3 TS1M2 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 9.3 TS1M2 | |||
| Microsoft Windows Server 2003 Datacenter Edition | 9.3 TS1M2 | |||
| Microsoft Windows 8.1 Pro 32-bit | 9.3 TS1M2 | 9.4 TS1M3 | ||
| Microsoft Windows 8.1 Pro | 9.3 TS1M2 | 9.4 TS1M3 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.3 TS1M2 | 9.4 TS1M3 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.3 TS1M2 | 9.4 TS1M3 | ||
| Microsoft Windows 8 Pro 32-bit | 9.3 TS1M2 | 9.4 TS1M3 | ||
| Microsoft Windows 8 Pro x64 | 9.3 TS1M2 | 9.4 TS1M3 | ||
| Microsoft Windows 8 Enterprise x64 | 9.3 TS1M2 | 9.4 TS1M3 | ||
| Microsoft Windows 8 Enterprise 32-bit | 9.3 TS1M2 | 9.4 TS1M3 | ||
| Microsoft® Windows® for x64 | 9.3 TS1M2 | 9.4 TS1M3 | ||
| z/OS | 9.3 TS1M2 | 9.4 TS1M3 | ||
| z/OS 64-bit | 9.3 TS1M2 | 9.4 TS1M3 | ||
A fix for this issue for Base SAS 9.4_M3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/V01.html#56978A fix for this issue for Base SAS 9.4_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/R19.html#56978| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2015-12-15 12:37:21 |
| Date Created: | 2015-11-01 17:04:18 |