SUPPORT / SAMPLES & SAS NOTES
Problem Note 71039: BULKLOADING multi-byte characters with SAS/ACCESS® Interface to Greenplum might fail with “ERROR: invalid byte sequence for encoding "UTF8"”
 |  |  |  |  |
SAS/ACCESS Interface to Greenplum might fail to BULKLOAD SAS data to Greenplum when the SAS data contains double or multi-byte characters (DBCS or MBCS).
As a result, an error similar to the following occurs:
ERROR: [SAS][ODBC Greenplum Wire Protocol driver][Greenplum]ERROR: invalid byte sequence for encoding "UTF8": 0xc3 0x64 (seg10 slice1 greenplum-host-ip:6004 pid=30100)(Where External table ext_table-name, line 1 of file
gpfdist://gpfdist-host:8081/BL_libref.table-name.dat; File wchar.c; Line 2011; Routine report_invalid_encoding; ) : [SAS][ODBC Greenplum Wire Protocol driver][Greenplum]Failed transaction. The current transaction rolled back. Load error
code: 4294967295
gpfdist://gpfdist-host:8081/BL_libref.table-name.dat; File wchar.c; Line 2011; Routine report_invalid_encoding; ) : [SAS][ODBC Greenplum Wire Protocol driver][Greenplum]Failed transaction. The current transaction rolled back. Load error
code: 4294967295
In this scenario, the invalid byte sequence is 0xc3 0x64. (Note that this sequence might vary.)
The only workaround is to use BULKLOAD=NO.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
The issue was fixed in SAS® Viya® 2021.2.4 and later.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Greenplum (on SAS Viya) | Linux for x64 | Viya | Viya |