You might receive a Read Access Violation error when connecting to MySQL using SAS/ACCESS® Interface to ODBC. This issue occurs if you are using the MySQL ODBC 5.3 Unicode driver and you specify Driver= in your LIBNAME statement. The resulting error looks 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 (2229C567) Task Traceback Address Frame (DBGHELP API Version 4.0 rev 5) 000000002229C567 00000000229DED10 sasioodb:tkvercn1+0x1B527 000000002229BE8C 00000000229DF390 sasioodb:tkvercn1+0x1AE4C 0000000022339C80 00000000229DF398 sasxdbi:tkvercn1+0x38C40 0000000022324548 00000000229DF550 sasxdbi:tkvercn1+0x23508 00000000232619DC 00000000229DF558 sassqp:tkvercn1+0x99C 00000000232613E3 00000000229DF920 sassqp:tkvercn1+0x3A3 00000000221B2510 00000000229DF928 sassqx:tkvercn1+0x314D0 00000000221B1E80 00000000229DFB60 sassqx:tkvercn1+0x30E40 0000000022161330 00000000229DFB68 sassql:tkvercn1+0x2F0 00000000034B8A2B 00000000229DFBF8 sashost:Main+0x10F0B 00000000034BE65D 00000000229DFF50 sashost:Main+0x16B3D 00000000776759ED 00000000229DFF58 kernel32:BaseThreadInitThunk+0xD 00000000778AC541 00000000229DFF88 ntdll:RtlUserThreadStart+0x21 SAS WTABORT (SQL) The SAS System has detected an abort condition. An Exception occurred during wthtrm(). Please Contact Technical Support. Tasks [MAIN ] [WAITING ] pri[ 5] reb[0337C3A0] WC[0] WN[1] [IDLETASK] [READY ] pri[ 9] reb[0337C3A0] [EVENTTSK] [WAITING ] pri[ 0] reb[0337C3A0] WC[0] WN[1] [sasxkern] [WAITING ] pri[ 3] reb[0337C3A0] WC[0] WN[1] [SGIOREAD] [WAITING ] pri[ 3] reb[0337C3A0] WC[0] WN[1] [SGIOWRIT] [WAITING ] pri[ 3] reb[0337C3A0] WC[0] WN[1] [Session ] [WAITING ] pri[ 3] reb[04B8CE00] WC[0] WN[1] [TKSRV ] [WAITING ] pri[ 3] reb[04B8D3B0] WC[0] WN[1] [DMS Proc] [WAITING ] pri[ 7] reb[04B8DCC0] WC[0] WN[1] [Language] [WAITING ] pri[ 7] reb[04B8DCC0] WC[0] WN[1] [RESULTS ] [WAITING ] pri[ 7] reb[04DAFBC0] WC[0] WN[1] [XUIDLE ] [READY ] pri[ 8] reb[04B94900] [SASODR ] [WAITING ] pri[ 3] reb[05FFA2E0] WC[0] WN[1] [SASVODSV] [READY ] pri[ 7] reb[05FFA5A0] [DMSEXP ] [WAITING ] pri[ 7] reb[0600C970] WC[0] WN[1] [lst ] [WAITING ] pri[ 7] reb[068C4F60] WC[0] WN[1] [log ] [WAITING ] pri[ 7] reb[068C5220] WC[0] WN[1] [pgm ] [WAITING ] pri[ 7] reb[07A33920] WC[0] WN[1] [Enhanced] [WAITING ] pri[ 7] reb[07A33BE0] WC[0] WN[1] [Submit ] [WAITING ] pri[ 3] reb[04B8DCC0] WC[0] WN[1] [SQL ] [RUNNING ] pri[ 3] reb[21936C40] Traceback SASTBTraceBackCtx has been called with a string ("vacrash") instead of a CONTEXT pointer. Address Frame (DBGHELP API Version 4.0 rev 5) 000007FEFD94940D 00000000229DC8E0 KERNELBASE:RaiseException+0x3D 00000000020CECEB 00000000229DC8E8 tkmk:tkBoot+0x4CFAB 00000000020CEAB9 00000000229DCE30 tkmk:tkBoot+0x4CD79 00000000020C53CA 00000000229DCE80 tkmk:tkBoot+0x4368A 00000000034B00A9 00000000229DCE88 sashost:Main+0x8589 00000000034A1FC6 00000000229DCF30 sashost:rtmdoit+0x246 00000000034B4B5B 00000000229DD0A0 sashost:Main+0xD03B 00000000034B8438 00000000229DD230 sashost:Main+0x10918 00000000034BE4A8 00000000229DD800 sashost:Main+0x16988 00000000034BDD1B 00000000229DDB10 sashost:Main+0x161FB 00000000034BE680 00000000229DDB40 sashost:Main+0x16B60 000000000360348F 00000000229DDBB0 sashost:Main+0x15B96F 00000000778A9D2D 00000000229DDBB8 ntdll:RtlDecodePointer+0xAD 00000000778991CF 00000000229DE2C0 ntdll:RtlUnwindEx+0xBBF 00000000778D1248 00000000229DE880 ntdll:KiUserExceptionDispatcher+0x2E 000000002229C567 00000000229DE888 sasioodb:tkvercn1+0x1B527 000000002229BE8C 00000000229DF390 sasioodb:tkvercn1+0x1AE4C 0000000022339C80 00000000229DF398 sasxdbi:tkvercn1+0x38C40 0000000022324548 00000000229DF550 sasxdbi:tkvercn1+0x23508 00000000232619DC 00000000229DF558 sassqp:tkvercn1+0x99C 00000000232613E3 00000000229DF920 sassqp:tkvercn1+0x3A3 00000000221B2510 00000000229DF928 sassqx:tkvercn1+0x314D0 00000000221B1E80 00000000229DFB60 sassqx:tkvercn1+0x30E40 0000000022161330 00000000229DFB68 sassql:tkvercn1+0x2F0 00000000034B8A2B 00000000229DFF20 sashost:Main+0x10F0B 00000000034BE65D 00000000229DFF50 sashost:Main+0x16B3D 00000000776759ED 00000000229DFF58 kernel32:BaseThreadInitThunk+0xD 00000000778AC541 00000000229DFFD0 ntdll:RtlUserThreadStart+0x21
Click the Hot Fix tab in this note to access the hot fix for this issue.
Product Family | Product | System | SAS Release | |
Reported | Fixed* | |||
SAS System | SAS/ACCESS Interface to MySQL | Microsoft® Windows® for x64 | 9.4 TS1M2 | 9.4 TS1M3 |
Microsoft Windows 8 Enterprise 32-bit | 9.4 TS1M2 | 9.4 TS1M3 | ||
Microsoft Windows 8 Enterprise x64 | 9.4 TS1M2 | 9.4 TS1M3 | ||
Microsoft Windows 8 Pro 32-bit | 9.4 TS1M2 | 9.4 TS1M3 | ||
Microsoft Windows 8 Pro x64 | 9.4 TS1M2 | 9.4 TS1M3 | ||
Microsoft Windows 8.1 Enterprise 32-bit | 9.4 TS1M2 | 9.4 TS1M3 | ||
Microsoft Windows 8.1 Enterprise x64 | 9.4 TS1M2 | 9.4 TS1M3 | ||
Microsoft Windows 8.1 Pro | 9.4 TS1M2 | 9.4 TS1M3 | ||
Microsoft Windows 8.1 Pro 32-bit | 9.4 TS1M2 | 9.4 TS1M3 | ||
Microsoft Windows Server 2008 | 9.4 TS1M2 | 9.4 TS1M3 | ||
Microsoft Windows Server 2008 R2 | 9.4 TS1M2 | 9.4 TS1M3 | ||
Microsoft Windows Server 2008 for x64 | 9.4 TS1M2 | 9.4 TS1M3 | ||
Microsoft Windows Server 2012 Datacenter | 9.4 TS1M2 | 9.4 TS1M3 | ||
Microsoft Windows Server 2012 R2 Datacenter | 9.4 TS1M2 | 9.4 TS1M3 | ||
Microsoft Windows Server 2012 R2 Std | 9.4 TS1M2 | 9.4 TS1M3 | ||
Microsoft Windows Server 2012 Std | 9.4 TS1M2 | 9.4 TS1M3 | ||
Windows 7 Enterprise 32 bit | 9.4 TS1M2 | 9.4 TS1M3 | ||
Windows 7 Enterprise x64 | 9.4 TS1M2 | 9.4 TS1M3 | ||
Windows 7 Home Premium 32 bit | 9.4 TS1M2 | 9.4 TS1M3 | ||
Windows 7 Home Premium x64 | 9.4 TS1M2 | 9.4 TS1M3 | ||
Windows 7 Professional 32 bit | 9.4 TS1M2 | 9.4 TS1M3 | ||
Windows 7 Professional x64 | 9.4 TS1M2 | 9.4 TS1M3 | ||
Windows 7 Ultimate 32 bit | 9.4 TS1M2 | 9.4 TS1M3 | ||
Windows 7 Ultimate x64 | 9.4 TS1M2 | 9.4 TS1M3 | ||
64-bit Enabled AIX | 9.4 TS1M2 | 9.4 TS1M3 | ||
64-bit Enabled Solaris | 9.4 TS1M2 | 9.4 TS1M3 | ||
HP-UX IPF | 9.4 TS1M2 | 9.4 TS1M3 | ||
Linux for x64 | 9.4 TS1M2 | 9.4 TS1M3 | ||
Solaris for x64 | 9.4 TS1M2 | 9.4 TS1M3 |
A fix for this issue for SAS/ACCESS Interface to ODBC 9.4_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/V58.html#56606Type: | Problem Note |
Priority: | high |
Date Modified: | 2015-10-23 12:08:09 |
Date Created: | 2015-09-17 10:41:15 |