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 | ||||
An update for this issue is available for SAS Viya 3.4. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.4 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.4&softwareContextId=softwareUpdatesA fix for this issue for SAS/ACCESS Interface to Hadoop 9.46 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/E4Y.html#63987
When you query Oracle tables that contain DATETIME column data using SAS/ACCESS Interface to JDBC, you encounter a segmentation violation.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2019-04-12 09:22:28 |
| Date Created: | 2019-04-05 09:22:00 |