SUPPORT / SAMPLES & SAS NOTES
Problem Note 63987: You encounter a segmentation violation when connecting to Oracle using SAS/ACCESS® Interface to JDBC
 |  |  |  |  |
When querying Oracle tables that contain DATETIME column data with a SAS/ACCESS Interface to JDBC connection, you might encounter an error similar to the following:
ERROR: An exception has been encountered.
Please contact technical support and provide them with the following traceback
information:
Please contact technical support and provide them with the following traceback
information:
The SAS task name is [DATASTEP]
Segmentation Violation
Segmentation Violation
Traceback of the Exception:
/opt/sas/spre/home/SASFoundation/sasexe/libsas.so(tktracex+0x2e)
[0x7f0fa0ce9cee]
/opt/sas/spre/home/SASFoundation/sasexe/libsas.so(ht_handle_program_fault+0x306)
[0x7f0fa0bb9946]
/opt/sas/spre/home/SASFoundation/sasexe/tkmk.so(bkt_signal_handler+0x160)
[0x7f0fad1c27b0]
/lib64/libpthread.so.0(+0xf680) [0x7f0fae8f0680]
/opt/sas/spre/home/SASFoundation/sasexe/sasiojdb(hdget_jdbc+0x117c)
[0x7f0f4c876bdc]
/opt/sas/spre/home/SASFoundation/sasexe/sasiojdb(+0x683ae) [0x7f0f4c8733ae]
/opt/sas/spre/home/SASFoundation/sasexe/sasxdbi(yoeget+0xdb2) [0x7f0f4c57f5f2]
/opt/sas/spre/home/SASFoundation/dbcs/sasexe/sasyoio(yoget+0x1777)
[0x7f0f64de7c77]
/opt/sas/spre/home/SASFoundation/dbcs/sasexe/sasdsx(dsissr+0x169)
[0x7f0f650d6779]
[0x7f0f40e6d00f]
[0x7f0fa0ce9cee]
/opt/sas/spre/home/SASFoundation/sasexe/libsas.so(ht_handle_program_fault+0x306)
[0x7f0fa0bb9946]
/opt/sas/spre/home/SASFoundation/sasexe/tkmk.so(bkt_signal_handler+0x160)
[0x7f0fad1c27b0]
/lib64/libpthread.so.0(+0xf680) [0x7f0fae8f0680]
/opt/sas/spre/home/SASFoundation/sasexe/sasiojdb(hdget_jdbc+0x117c)
[0x7f0f4c876bdc]
/opt/sas/spre/home/SASFoundation/sasexe/sasiojdb(+0x683ae) [0x7f0f4c8733ae]
/opt/sas/spre/home/SASFoundation/sasexe/sasxdbi(yoeget+0xdb2) [0x7f0f4c57f5f2]
/opt/sas/spre/home/SASFoundation/dbcs/sasexe/sasyoio(yoget+0x1777)
[0x7f0f64de7c77]
/opt/sas/spre/home/SASFoundation/dbcs/sasexe/sasdsx(dsissr+0x169)
[0x7f0f650d6779]
[0x7f0f40e6d00f]
To work around this issue, use the TO_CHAR function in Oracle to change the DATETIME column to a CHARACTER column.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to JDBC | 64-bit Enabled AIX | 9.4 | 9.4 TS1M6 | ||
| Windows 7 Ultimate x64 | 9.4 | 9.4 TS1M6 | ||||
| Windows 7 Ultimate 32 bit | 9.4 | 9.4 TS1M6 | ||||
| Windows 7 Professional x64 | 9.4 | 9.4 TS1M6 | ||||
| Windows 7 Professional 32 bit | 9.4 | 9.4 TS1M6 | ||||
| Windows 7 Home Premium x64 | 9.4 | 9.4 TS1M6 | ||||
| Windows 7 Home Premium 32 bit | 9.4 | 9.4 TS1M6 | ||||
| Windows 7 Enterprise x64 | 9.4 | 9.4 TS1M6 | ||||
| Windows 7 Enterprise 32 bit | 9.4 | 9.4 TS1M6 | ||||
| Microsoft Windows Server 2019 | 9.4 | 9.4 TS1M6 | ||||
| Microsoft Windows Server 2016 | 9.4 | 9.4 TS1M6 | ||||
| Microsoft Windows Server 2012 Std | 9.4 | 9.4 TS1M6 | ||||
| Microsoft Windows Server 2012 R2 Std | 9.4 | 9.4 TS1M6 | ||||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 | 9.4 TS1M6 | ||||
| Microsoft Windows Server 2012 Datacenter | 9.4 | 9.4 TS1M6 | ||||
| Microsoft Windows 10 | 9.4 | 9.4 TS1M6 | ||||
| Microsoft Windows 8.1 Pro x64 | 9.4 | 9.4 TS1M6 | ||||
| Microsoft Windows 8.1 Pro 32-bit | 9.4 | 9.4 TS1M6 | ||||
| Microsoft Windows 8.1 Enterprise x64 | 9.4 | 9.4 TS1M6 | ||||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 | 9.4 TS1M6 | ||||
| Microsoft Windows 8 Pro x64 | 9.4 | 9.4 TS1M6 | ||||
| Microsoft Windows 8 Pro 32-bit | 9.4 | 9.4 TS1M6 | ||||
| Microsoft Windows 8 Enterprise x64 | 9.4 | 9.4 TS1M6 | ||||
| Microsoft Windows 8 Enterprise 32-bit | 9.4 | 9.4 TS1M6 | ||||
| Microsoft® Windows® for x64 | 9.4 | 9.4 TS1M6 | ||||
| 64-bit Enabled Solaris | 9.4 | 9.4 TS1M6 | ||||
| HP-UX IPF | 9.4 | 9.4 TS1M6 | ||||
| Linux for x64 | 9.4 | 9.4 TS1M6 | ||||
| Solaris for x64 | 9.4 | 9.4 TS1M6 | ||||