Qlik Community

QlikView Connectors

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Giovane
New Contributor III

Connecting to a PostgreSQL data base

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?

4 Replies

Re: Connecting to a PostgreSQL data base

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?


talk is cheap, supply exceeds demand
Giovane
New Contributor III

Re: Connecting to a PostgreSQL data base

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.

p_verkooijen
Valued Contributor

Re: Connecting to a PostgreSQL data base

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

Giovane
New Contributor III

Re: Connecting to a PostgreSQL data base

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.

Community Browser