Problem Note 44329: An "invalid byte sequence" error might occur when you use bulk load with SAS/ACCESS® Interface to Greenplum
 |  |  |  |  |
When you try to bulk load to Greenplum, you might receive an "invalid byte sequence" error similar to the one shown below:
[SAS ACCESS to Greenplum][ODBC Greenplum Wire Protocol driver][Greenplum]ERROR: invalid byte sequence for encoding "UTF8"
This problem can occur when you try to bulk load into an existing table that contains numerics. The way that SAS stores numerics can cause Greenplum to throw an error when rounding.
This error is not specific to UTF8 encoding.
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/ACCESS Interface to Greenplum | Linux for x64 | 9.3 | 9.3_M1 | 9.3 TS1M0 | 9.3 TS1M1 |
| Solaris for x64 | 9.3 | 9.3_M1 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Microsoft® Windows® for x64 | 9.3 | 9.3_M1 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.3 | 9.3_M1 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2008 | 9.3 | 9.3_M1 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Microsoft Windows XP Professional | 9.3 | 9.3_M1 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Windows 7 Enterprise 32 bit | 9.3 | 9.3_M1 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Windows 7 Enterprise x64 | 9.3 | 9.3_M1 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| 64-bit Enabled AIX | 9.3 | 9.3_M1 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| 64-bit Enabled Solaris | 9.3 | 9.3_M1 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| HP-UX IPF | 9.3 | 9.3_M1 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Linux | 9.3 | 9.3_M1 | 9.3 TS1M0 | 9.3 TS1M1 | ||
A fix for this issue for SAS/ACCESS Interface to Greenplum 9.3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/F17.html#44329| Type: | Problem Note |
| Priority: | medium |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> GreenPlum |
| Date Modified: | 2011-10-27 09:20:42 |
| Date Created: | 2011-09-19 09:58:36 |