How to set up buffersize - Vertica odbc connection

[Yurie]

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

[Oligolas]

Hi,

DBMAX_TEXT=32767 maybe?

libname dw odbc datasrc="Vertica" user=myusername password=mypassword schema=ods_abcd DBMAX_TEXT=32767;

[Yurie]

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. 

[ChrisBrooks]

Have you tested if the SAS/ACESS Connector to Vertica is installed as in this guide http://my.vertica.com/docs/Ecosystem/SASConnectionGuide.pdf

[richardmgb]

Did anyone ever find a solution to this issue?

[jimbarbour]

@richardmgb,

If you have an issue, let's please open a new topic.  This topic from 2017 is dead, dead, dead.  🙂

thanks,

Jim