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