Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlik Sense - Timeout loading data from SQL

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

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

2 Replies
petter
Partner - Champion III
Partner - Champion III

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

Not applicable
Author

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