Problem Note 48047: The conversion of data formatted for the NLS locale does not work properly in DataFlux® Federation Server
 |  |  |  |
Specification conformance is a major goal of the DataFlux Federation Server. The server is required to support industry standard specifications such as ODBC/JDBC. One factor of this conformance is handling data conversions of data that is compliant with those standards. The Federation Server is also required to follow the I18N (Internationalization) standards defined for SAS products. The conversion routines do not correctly handle data formatted for the customer's chosen locale.
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
For example:
When a locale-valid numeric string needs to be converted into a signed
or unsigned integer, a problem may occur if the string is formatted like 123. or 123.00.
If this type of pattern data is used in a SQL statement, the error
Cannot connect to SQL Logging service
will appear in SQL Log task in Federation Server Managers.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | Base SAS | Aster Data nCluster on Linux x64 | 9.3 | 9.3 TS1M1 | ||
| DB2 Universal Database on AIX | 9.3 | 9.3 TS1M1 | ||||
| DB2 Universal Database on Linux x64 | 9.3 | 9.3 TS1M1 | ||||
| Greenplum on Linux x64 | 9.3 | 9.3 TS1M1 | ||||
| Netezza TwinFin 32bit blade | 9.3 | 9.3 TS1M1 | ||||
| Netezza TwinFin 32-bit SMP Hosts | 9.3 | 9.3 TS1M1 | ||||
| Netezza TwinFin 64-bit S-Blades | 9.3 | 9.3 TS1M1 | ||||
| Netezza TwinFin 64-bit SMP Hosts | 9.3 | 9.3 TS1M1 | ||||
| Teradata on Linux | 9.3 | 9.3 TS1M1 | ||||
| z/OS | 9.3 | 9.3 TS1M1 | ||||
| Z64 | 9.3 | 9.3 TS1M1 | ||||
| Microsoft® Windows® for x64 | 9.3 | 9.3 TS1M1 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 9.3 | 9.3 TS1M1 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 9.3 | 9.3 TS1M1 | ||||
| Microsoft Windows Server 2003 Standard Edition | 9.3 | 9.3 TS1M1 | ||||
| Microsoft Windows Server 2003 for x64 | 9.3 | 9.3 TS1M1 | ||||
| Microsoft Windows Server 2008 | 9.3 | 9.3 TS1M1 | ||||
| Microsoft Windows Server 2008 for x64 | 9.3 | 9.3 TS1M1 | ||||
| Microsoft Windows XP Professional | 9.3 | 9.3 TS1M1 | ||||
| Windows 7 Enterprise 32 bit | 9.3 | 9.3 TS1M1 | ||||
| Windows 7 Enterprise x64 | 9.3 | 9.3 TS1M1 | ||||
| Windows 7 Home Premium 32 bit | 9.3 | 9.3 TS1M1 | ||||
| Windows 7 Home Premium x64 | 9.3 | 9.3 TS1M1 | ||||
| Windows 7 Professional 32 bit | 9.3 | 9.3 TS1M1 | ||||
| Windows 7 Professional x64 | 9.3 | 9.3 TS1M1 | ||||
| Windows 7 Ultimate 32 bit | 9.3 | 9.3 TS1M1 | ||||
| Windows 7 Ultimate x64 | 9.3 | 9.3 TS1M1 | ||||
| Windows Vista | 9.3 | 9.3 TS1M1 | ||||
| Windows Vista for x64 | 9.3 | 9.3 TS1M1 | ||||
| 64-bit Enabled AIX | 9.3 | 9.3 TS1M1 | ||||
| 64-bit Enabled HP-UX | 9.3 | 9.3 TS1M1 | ||||
| 64-bit Enabled Solaris | 9.3 | 9.3 TS1M1 | ||||
| HP-UX IPF | 9.3 | 9.3 TS1M1 | ||||
| Linux | 9.3 | 9.3 TS1M1 | ||||
| Linux for x64 | 9.3 | 9.3 TS1M1 | ||||
| Solaris for x64 | 9.3 | 9.3 TS1M1 | ||||
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2012-10-09 11:28:56 |
| Date Created: | 2012-10-01 10:48:51 |