Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Error when validating tables or reloading: ERROR [HYT00] [Microsoft][ODBC SQL Server Driver]Query timeout expired

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Albert_Candelario

Error when validating tables or reloading: ERROR [HYT00] [Microsoft][ODBC SQL Server Driver]Query timeout expired

Last Update:

May 20, 2021 8:31:35 AM

Updated By:

Sonja_Bauernfeind

Created date:

Feb 21, 2018 8:36:37 AM

A data reload or validation fails with:

ERROR [HYT00] [Microsoft][ODBC SQL Server Driver]Query timeout expired

The error you are reporting is coming from the database. It looks to be a 30 second timeout on the DB and if the DB is very large as the Qlik Sense UDC connection is looking into sp_tables and then on sp_views and try to find out any match to the name of the view, there could be an issue as the DB might be too large to trigger the sp_tables within 30s.

 

Environment:

QlikView 
Qlik Sense Enterprise on Windows 

 

Resolution:

 

  1. Configure the database accordingly to allow for a long timeout value.
  2. Or use a different connector that allows the same. 
Labels (2)
Contributors
Version history
Last update:
‎2021-05-20 08:31 AM
Updated by: