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:
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 |
Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdatesA fix for this issue for SAS BI Dashboard 4.41_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/N7I.html#71039| Type: | Problem Note |
| Priority: | high |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> GreenPlum |
| Date Modified: | 2024-11-27 11:09:19 |
| Date Created: | 2024-11-06 10:09:39 |