topic Re: Errors in Postgres Connections Since April 2019 Release in Connectivity & Data Prep

Errors in Postgres Connections Since April 2019 Release

peterkunhardt — Tue, 30 Jul 2019 17:59:22 GMT

We've been experiencing numerous errors in our OLAP queries against Postgres sources from within Qlik since upgrading to 13.21.1. Many apps which worked on our previous version (11.24.4. aka Nov '18 Patch 2) now throw errors during reload or simply do not load any data from the SQL statement. This seems to be especially associated with any query which utilizes a WITH clause as part of the statement, but others are also failing inexplicably. I've tested these queries from a local machine and found that they are still operating normally.

I am not seeing anything in the release notes for April '19 SR2 or June '19 release notes about this issue.

Has anyone else been experiencing greater bugginess in SQL data connections since this release? Anyone found any relief by getting the latest version?

Re: Errors in Postgres Connections Since April 2019 Release

NadiaB — Tue, 30 Jul 2019 21:03:16 GMT

Hi @peterkunhardt

If you create a new application, with only one query that includes the WITH statement does it fail?

Kind regards.

Re: Errors in Postgres Connections Since April 2019 Release

peterkunhardt — Mon, 05 Aug 2019 22:49:05 GMT

@NadiaB excellent question; extracting the query to a new application does not resolve the problem.

Generally speaking I've tested the queries/apps which seem to fail by:

Deleting the auto-generated sections & rebuilding them
Creating a new app & testing just the individual query there
Creating a new data connection to the same source and testing with that
Creating a new ODBC data connection based on a system DSN which I installed myself so I can be sure the driver is the same as the one I use on my local machine

I'm seeing this behavior with two different Postgres sources: our Production follower and our Data Warehouse. The former is hosted by AWS/Heroku, while the latter is hosted in Azure.