Problem Note 71049: Reading a Snowflake table might result in "ERROR: The size of the data exceeded the maximum allocated buffer size for BULKUNLOAD"
 |  |  |  |  |
Reading a Snowflake table might result in an error under these conditions:
- The data includes at least one character that requires more than one byte for storage.
- You use the BULKUNLOAD=YES LIBNAME or data set option.
The error might look similar to the following:
ERROR: The size of the data exceeded the maximum allocated buffer size for BULKUNLOAD
A possible workaround is to change the order of the variables that are selected or created in the query. This workaround involves testing different orders of the variables to determine whether there is an order that works.
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 | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Snowflake | Microsoft® Windows® for x64 | 9.4 TS1M6 | |
| Linux for x64 | 9.4 TS1M6 | |||
| SAS System | SAS/ACCESS Interface to Snowflake (on SAS Viya) | Linux for x64 | Viya platform | |
A fix for this issue for SAS/ACCESS Interface to Snowflake 9.43 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/L9B.html#71049| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2024-11-15 11:03:55 |
| Date Created: | 2024-11-13 15:12:37 |