Hi SAS experts, We are working on SAS 9.4 for ETL and Redshift for data warehousing. When we sometimes read data in SAS from Redshift or write data to Redshift for small tables, we get the following error. This happens even for small tables when we attempt to get row count using PROC SQL in SAS. But for large tables (>10 M), this is always the case for both reading and writing. Can you please help us troubleshoot the issue?
ERROR: CLI prepare error: [SAS][ODBC Redshift Wire Protocol driver]Socket closed.
SQL statement: SELECT * FROM "schema".tblname.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.04 seconds
cpu time 0.01 seconds
It may help to show the code submitted.
The quotes around schema in the from look a bit suspect and may indicate an improper libname creation/connection setting.
You would be best to progress this in a track with SAS Tech Support. Perhaps a more recent Redshift ODBC driver version might help.
There's a few Redshift ODBC driver errors documented on SAS Support but none reference the error you are getting.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.
Find more tutorials on the SAS Users YouTube channel.