08-28-2017 12:59 PM
When I run a proc contents command, I received the following error message:
libname dw odbc datasrc="Vertica" user=myusername password=mypassword schema=ods_abcd;
proc contents data=dw.table; run;
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!
08-29-2017 09:12 AM
libname dw odbc datasrc="Vertica" user=myusername password=mypassword schema=ods_abcd DBMAX_TEXT=32767;
- Cheers -
09-01-2017 03:56 PM
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.
09-01-2017 04:50 PM
Have you tested if the SAS/ACESS Connector to Vertica is installed as in this guide http://my.vertica.com/docs/Ecosystem/SASConnectionGuide.pdf