Problem Note 70925: Reading a Snowflake table and using BULKUNLOAD=YES might fail after applying Hot Fix L9B004
 |  |  |  |  |
Trying to read a Snowflake table using BULKUNLOAD=YES might fail after applying Hot Fix L9B004 when the Snowflake table contains a column defined as a date or datetime.
Here are some of the errors that have occurred due to this issue:
ERROR: Message from TK: The destination buffer size was not sufficient for the transcoded data
ERROR: read_and_convert_data_file(1): get_column_data failed, rc = 0x803fe807
WARNING: At least one column was truncated during UNLOAD read operation
The connection to the server was lost when running using SAS Enterprise Guide.
There is no workaround for this issue.
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/ACCESS Interface to Snowflake | Microsoft® Windows® for x64 | 9.43 | 9.4 TS1M8 | ||
| Linux for x64 | 9.43 | 9.4 TS1M8 | ||||
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#70925| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2024-08-12 11:14:08 |
| Date Created: | 2024-08-07 22:41:34 |