Problem Note 59898: The error "Unable to transcode data" is generated when you execute campaigns against a non-Western Latin (WLATIN1) Netezza database
 |  |  |  |  |
SAS® Customer Intelligence campaigns might fail to publish or export data when the underlying database is Netezza. When this problem occurs, the following error is generated.
NOTE: The SAS System stopped processing this step because of errors.
This error occurs when the SAS® compute tier and the SAS/ACCESS® Interface to Netezza engine are deployed on a Microsoft Windows server and the data contains non-Western Latin (WLATIN1) characters (for example, UTF-8 or other double-byte character sets [DBCS]).
When the underlying SAS sessions have a UTF-8 encoding, non-ASCII character data might not be transcoded correctly and is exported in binary format when it is bulk loaded to the Netezza database. This behavior is not limited to Microsoft Windows servers; it might occur on all platforms.
For more information, see SAS Note 59905, "ERROR: Unable to transcode data. . ." occurs when you access a non-Western Latin (WLATIN1) Netezza database."
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 Customer Intelligence Core Mid-Tier | 64-bit Enabled AIX | 6.5 | 6.5 | 9.4 TS1M3 | 9.4 TS1M5 |
| 64-bit Enabled Solaris | 6.5 | 6.5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| HP-UX IPF | 6.5 | 6.5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Linux for x64 | 6.5 | 6.5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Solaris for x64 | 6.5 | 6.5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft® Windows® for x64 | 6.5 | 6.5 | 9.4 TS1M3 | 9.4 TS1M5 | ||