When I run a proc contents command, I received the following error message:
Code:
libname dw odbc datasrc="Vertica" user=myusername password=mypassword schema=ods_abcd;
proc contents data=dw.table; run;
Error message:
Error: CLL prepare error: [Vertica] [Vertica DSII] (10) An error occurred during query preparation: Multiple commands cannot be active on the same connnection. Cionsider increasing resultbuffersize or fetching all results before initiating another command. SQL statement: select * from ods_abcd.table.
I used the Vertica connected to my database through ODBC (I use SAS 9.4 SAS server). However, after I get the all the tables, I even could not open the tables in the library and give me the above error message. Any suggestions will be very appreciate!
Regards,
Yurie
Hi,
DBMAX_TEXT=32767 maybe?
libname dw odbc datasrc="Vertica" user=myusername password=mypassword schema=ods_abcd DBMAX_TEXT=32767;
- Cheers -
Thanks! I tried add DBMAX_text=32767. The libref name was successfully assigned with Engine: ODBC and phsycial Name: Vertica. However, when I test the table using proc freq, I still get the same error message.
Have you tested if the SAS/ACESS Connector to Vertica is installed as in this guide http://my.vertica.com/docs/Ecosystem/SASConnectionGuide.pdf
Did anyone ever find a solution to this issue?
If you have an issue, let's please open a new topic. This topic from 2017 is dead, dead, dead. 🙂
thanks,
Jim
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.