DATA Step, Macro, Functions and more

How to set up buffersize - Vertica odbc connection

Reply
Contributor
Posts: 32

How to set up buffersize - Vertica odbc connection

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

Regular Contributor
Posts: 153

Re: How to set up buffersize - Vertica odbc connection

Hi,

 

DBMAX_TEXT=32767 maybe?

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

- Cheers -

Contributor
Posts: 32

Re: How to set up buffersize - Vertica odbc connection

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. 

Valued Guide
Posts: 561

Re: How to set up buffersize - Vertica odbc connection

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

Ask a Question
Discussion stats
  • 3 replies
  • 231 views
  • 0 likes
  • 3 in conversation