Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Giovane
Creator
Creator

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?

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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

View solution in original post

5 Replies
Gysbert_Wassenaar

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
Creator
Creator
Author

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
Partner - Specialist
Partner - Specialist

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
Creator
Creator
Author

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.

LeticiaP
Contributor
Contributor

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!