Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thanks
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.