SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 70925: Reading a Snowflake table and using BULKUNLOAD=YES might fail after applying Hot Fix L9B004

DetailsHotfixAboutRate It

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 FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS/ACCESS Interface to SnowflakeMicrosoft® Windows® for x649.439.4 TS1M8
Linux for x649.439.4 TS1M8
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.