PostgreSQL connection gets stuck in loading screenArticle Number: 000052895 | Last Modified: 2019/01/17
When there is a syntax error in the SQL query (for example Select Count(*) as [Total] - square brackets are invalid characters in Postgres SQL), Qlik Sense doesn't shows error but gets stuck on the loading window with the in-progress icon circling.
This does not happen in Qlik Sense February or June 2018. In these versions, Qlik Sense displays an error immediately when a syntax error is detected.
- Qlik Sense April 2018 (Qlik ODBC Connector Package 4.8.0)
- Check for syntax errors in the SQL query. May test the query in pgAdmin first
- Upgrade to Qlik Sense June 2018 should completely resolve the issue
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.Submit a case
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.