Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
andrelopesintuita
Contributor
Contributor

Connecting to GreenPlum (Postgreqsl) on AWS Error

Hi,

I've been trying to connect Qlik Sense (cloud version) to GreenPlum (PosgreSQL) running on AWS. The connection itself can be created and I can see the corresponding DB schemas, objects and metadata.

When I then try to fetch or preview data, I get an error from GreenPlum as per below. This error seems to be related to the fact that Qlik uses prepared statements to fetch data, but for same reason, it's trying to execute multiple prepared statements with the same name and Postgres clearly doesn't like that. I don't see any option in the connection details from Qlik Sense to change any of this. 

Has anyone seen the same error? Might be a DB parameter that needs to be changed, couldn't find info so far on this one.

 

qlik error.JPG

 

Thanks

Labels (1)
1 Reply
andrelopesintuita
Contributor
Contributor
Author

Would like to add that I've download Qlik Sense desktop and with the exact same connection details, it worked perfectly, it's only in the Cloud that it doesn't work.