Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
If you create a new application, with only one query that includes the WITH statement does it fail?
Kind regards.
@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:
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.