Usage Note 69665: SAS/ACCESS® Interface to Amazon Redshift returns the error "This is either an Unknown Type or is not supported currently" when loading large tables
 |  |  |  |  |
When you insert data that contains more than 30,000 rows, the following error might occur:
[SAS][ODBC Redshift Wire Protocol driver]This is either an Unknown Type or is not supported currently.
If you set the EncryptionMethod driver option to 6 or 1, and you use a non-bulk data load method, this error might occur. Note that the EncryptionMethod driver option is used to enable SSL. The error is introduced with the latest version of the DataDirect ODBC driver that is included with SAS/ACCESS Interface to Amazon Redshift (Driver Name: S0rsft28.so, Driver Version: 08.0* (B0895, U0657)).
Available Workarounds:
To circumvent this issue, choose from the following workarounds:
- Use a non-SSL enabled connection by setting EncryptionMethod=0. However, this could present a security concern, so you should fully review this workaround before implementing it.
- Use BULKLOAD=YES for data load operations.
- Limit the data load to 30,000 rows per step.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Amazon Redshift | Linux for x64 | ||
A fix for this issue for DataDirect ODBC Driver for Amazon Redshift 9.45 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/M2D.html#69665A fix for this issue for DataDirect ODBC Driver for Amazon Redshift 9.44 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/J8L.html#69665| Type: | Usage Note |
| Priority: |
| Date Modified: | 2022-11-21 09:42:06 |
| Date Created: | 2022-11-08 10:49:04 |