Amazon Redshift to SAS CLI error

VVDR — Thu, 13 May 2021 02:48:46 GMT

Hi Team,

Good day.

I am facing some CLI error while I am trying to execute any action on SAS tables that are refreshed from Redshift.

I followed the below steps to replicate.

I have executed SAS Libname statement to get the data into SAS from Redshfit. This is working fine.
I am able to see all the tables/vies in SAS library.
I am not able to perform any action on those tables/view

Ex:

Proc Sql;

Select count(*) from Test.RTab;

quit;

ERROR: CLI describe error: ERROR: prepared statement "_PLAN0x7f295c000f50" already exists; No query has been executed with that
handle

Please help me with the solution.

Regards

VVDR

Re: Amazon Redshift to SAS CLI error

SASKiwi — Thu, 13 May 2021 03:32:41 GMT

I'd suggest opening a track with SAS Tech Support on this if you haven't done so already. I searched SAS Notes and couldn't find anything relevant.