Page 1 of 1

ODBC buffer size

Posted: Mon Sep 02, 2013 10:02 am
by rajaduraibanu
hi
Can any one help me out , m facing a problem with fetchrow_array , when using in perl code .
If i specify limit in my select query with limit 100 m geting proper and expected result but for limit 200 m getting below error , i think i need to increase the ODBC buffer size but m not getting how to do .....

DBD::ODBC::st fetchrow_array failed: [unixODBC][Vertica][VerticaDSII] (20) An error occurred during query execution: (SQL-HY000)

Re: ODBC buffer size

Posted: Tue Sep 03, 2013 12:33 pm
by JimKnicely
Hi,

What operating system is the client running on? I believe you may be looking for the ResultBufferSize parameter of the DSN? It sets the size of the memory buffer for the large result sets in streaming mode. Note: This parameter was previously called MaxMemoryCache.

Re: ODBC buffer size

Posted: Thu Sep 05, 2013 11:18 am
by rajaduraibanu
mmm ya thank u :)

Re: ODBC buffer size

Posted: Mon Nov 18, 2013 10:08 am
by banurajadurai
hi
m facing the same error again ,
i increased the buffer size to 5000000000, even then After fetching 2047 rows the script is getting stopped with error

DBD::ODBC::st fetchrow_array failed: [unixODBC][Vertica][VerticaDSII] (20) An error occurred during query execut ion: (SQL-HY000) at TDA_test.pl line 51.
DBD::ODBC::st fetchrow_array failed: [unixODBC][Vertica][VerticaDSII] (20) An error occurred during query execut ion: (SQL-HY000) at TDA_test line 51.
:cry:

in my code there is a main select quey , inside which there are some 10 select queries ...
Here Main select query is failing :-(