topic Re: Connecting to a PostgreSQL data base in QlikView

Connecting to a PostgreSQL data base

Giovane — Mon, 26 Jan 2026 21:26:37 GMT

I'm in trouble when attempting to extract data from a PostgreSQL data base. I've received the following message: "SQL##f - SqlState: S1001, ErrorCode: 4, ErrorMsg: Out of memory while reading tuples." I'm using PostgreSQL30 odbc driver. But, even when using PostgreSQL35 odbc driver the same issue accurs. Anyone knows how to fix this issue?

Re: Connecting to a PostgreSQL data base

Gysbert_Wassenaar — Fri, 04 Mar 2016 17:36:39 GMT

No idea, but it has nothing to do with Qlikview. It's a problem with the Postgresql odbc driver or the database. Have you tried searching for an answer on Postgresql related sites?

Re: Connecting to a PostgreSQL data base

Giovane — Fri, 04 Mar 2016 18:11:19 GMT

Hello, Buddy. I didn't attempt to search the answer in a specific PostgreSQL forum but, it's a good idea. I hope to find here someone that had the same problem than me in order to cut the way. But, if case of bad luck, your opinion will be useful.

Thanks for your cooperation.

Re: Connecting to a PostgreSQL data base

p_verkooijen — Fri, 04 Mar 2016 18:29:36 GMT

Try googling for the error first hit on "ErrorCode: 4, ErrorMsg: Out of memory while reading tuples" is IBM Out of memory while reading tuples. No query has been executed with that handle. - United States

Re: Connecting to a PostgreSQL data base

Giovane — Fri, 04 Mar 2016 19:36:39 GMT

Straight to the point. Exactly what I was looking for. Reading the post that you've suggested I saw that the symptoms match with my issue. Done!

Thank you very much, Paul.

Re: Connecting to a PostgreSQL data base

LeticiaP — Tue, 02 Jun 2020 11:53:57 GMT

Hi, I don´t know if yoy finally solved the issue, bit I'm facing it right now and the previous link doesn't work out anymore. If you have a clue about how to solve it it would be very helpful.

Thanks!

Re: Connecting to a PostgreSQL data base

MarceloCalvo — Mon, 10 Mar 2025 20:47:40 GMT

I found a solution, is to set the "use declare/fetch" option in psqlODBC driver options.