Amazon Redshift to SAS CLI error

[VVDR]

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 

[SASKiwi]

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.