Problem Note 66803: CAS table columns might become corrupted when you load data from PostgreSQL into SAS® Cloud Analytic Services (CAS)
 |  |  |  |  |
When you read PostgreSQL columns into CAS, the resulting CAS table columns might contain corrupted data. This issue occurs if the character columns have a maximum length greater than the MAX_TEXT_LEN option (defaults to 8,190). Sometimes, the data can still appear corrupted even if the data in the column does not exceed the max value of MAX_TEXT_LEN.
For example, the data "Test1" might appear as "T*e*s*t*1", where the * could be any unreadable character.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Viya | Microsoft Windows Server 2003 for x64 | 3.5 | 3.5 | Viya | Viya |
| Microsoft Windows 8.1 Pro x64 | 3.5 | 3.5 | Viya | Viya | ||
| Microsoft Windows 8.1 Enterprise x64 | 3.5 | 3.5 | Viya | Viya | ||
| Microsoft Windows 8 Pro x64 | 3.5 | 3.5 | Viya | Viya | ||
| Microsoft Windows 8 Enterprise x64 | 3.5 | 3.5 | Viya | Viya | ||
| Microsoft® Windows® for x64 | 3.5 | 3.5 | Viya | Viya | ||
| Microsoft Windows Server 2008 R2 | 3.5 | 3.5 | Viya | Viya | ||
| Microsoft Windows Server 2008 for x64 | 3.5 | 3.5 | Viya | Viya | ||
| Microsoft Windows Server 2012 Datacenter | 3.5 | 3.5 | Viya | Viya | ||
| Microsoft Windows Server 2012 R2 Datacenter | 3.5 | 3.5 | Viya | Viya | ||
| Microsoft Windows Server 2012 R2 Std | 3.5 | 3.5 | Viya | Viya | ||
| Microsoft Windows Server 2012 Std | 3.5 | 3.5 | Viya | Viya | ||
| Microsoft Windows Server 2016 | 3.5 | 3.5 | Viya | Viya | ||
| Windows 7 Enterprise x64 | 3.5 | 3.5 | Viya | Viya | ||
| Windows 7 Home Premium x64 | 3.5 | 3.5 | Viya | Viya | ||
| Windows 7 Professional x64 | 3.5 | 3.5 | Viya | Viya | ||
| Windows 7 Ultimate x64 | 3.5 | 3.5 | Viya | Viya | ||
| Linux for x64 | 3.5 | 3.5 | 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=softwareUpdates| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2020-10-22 16:43:13 |
| Date Created: | 2020-10-19 09:28:16 |