Problem Note 60709: When you insert text data containing a question mark (?) into an Oracle database table from SAS® Federation Server, the ? is converted to :1
 |  |  |  |  |
When you insert text data containing a question mark (?) into an Oracle database table from SAS Federation Server 4.1, the ? might be converted to :1.
This problem occurs due to an issue in the native Threaded Kernel Table Services (TKTS) Oracle driver.
To work around the problem, use the ODBC driver.
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 | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Federation Server | Microsoft® Windows® for x64 | 4.1 | 9.4 TS1M3 | 9.4 TS1M5 | |
| Microsoft Windows 8 Enterprise x64 | 4.1 | 9.4 TS1M3 | 9.4 TS1M5 | |||
| Microsoft Windows 8 Pro x64 | 4.1 | 9.4 TS1M3 | 9.4 TS1M5 | |||
| Linux for x64 | 4.1 | 9.4 TS1M3 | 9.4 TS1M5 | |||
A fix for this issue for SAS Threaded Kernel Extension for Oracle 9.41 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/A8Q.html#60709A fix for this issue for SAS Federation Server 4.2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Y46.html#60709A fix for this issue for SAS Federation Server 4.1_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/W97.html#60709| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2017-07-07 15:08:31 |
| Date Created: | 2017-07-03 10:19:14 |