topic Qlik Sense - Timeout loading data from SQL in App Development

Qlik Sense - Timeout loading data from SQL

Mon, 23 Jan 2017 19:25:02 GMT

Hi,

We receive a timeout error when loading data from SQL (after 1-2 min). Where can we increase the timeout on qlik sense?

We have checked our SQL time out and it's 600 seconds, so that's not the cause.

Kind Regards,

Deloitte Spain

Re: Qlik Sense - Timeout loading data from SQL

petter — Mon, 23 Jan 2017 22:49:52 GMT

What type and version of SQL database do you have and exactly which driver and version do you use to connect to the database?

Re: Qlik Sense - Timeout loading data from SQL

Tue, 24 Jan 2017 09:21:33 GMT

Finally we did it in Qlik Sense, editing the ODBC connection.

When you are setting the connection, at the bottom you have some space fields (under the header advanced) where you can fill some settings. We tried the following ones and it worked fine:

Timeout = 0

ConnectionTimeout = 60000

QueryTimeout = -1

Re: Qlik Sense - Timeout loading data from SQL

KIRTHI — Fri, 07 Jun 2024 11:17:33 GMT

Please share the Timeout parameter names and ideal values. I am seeing a lot of SQL Endpoint Timeout errors.