Forum Discussion
Query Timeout (ODBC)
I am querying using the ODBC connector.
In the M code we have the connection:
Odbc.DataSource("dsn="ww", [HierarchyNaviagtion = true, ConnectionTimeout-#duration(0,0,30,0)
I was hoping this would allow the Odbc connector to time out at 30 minutes. However it still seems to timeout at 15 minutes regardless of the duration? Is this a setting in the ODBC Data Source Adminstrator on my PC or a native timeout? Or am I missing something. Error message below.
Thanks
E
OLE DB or ODBC error: [DataSource.Error] ERROR [ ] ERROR: Error executing query. Total time 900.18 seconds. QUERY [VIRTUAL] [QUERY_TIMEOUT] QUERY [JDBC WRAPPER] [PROCESSING] QUERY [JDBC ROUTE] [PROCESSING] java.sql.SQLException: Error executing query. Total time 900.18 seconds. QUERY [VIRTUAL] [QUERY_TIMEOUT] QUERY [JDBC WRAPPER] [PROCESSING] QUERY [JDBC ROUTE] [PROCESSING] ; Error fetching next row.
Thanks,
It looks the the ODBC data source will automatically timeout at 15 minutes. I have changed the setting in the ODBC Sata Sources and this appears to heave reqolved the issue.Many thanks
3 Replies
Thanks,
It looks the the ODBC data source will automatically timeout at 15 minutes. I have changed the setting in the ODBC Sata Sources and this appears to heave reqolved the issue.Many thanks
There are two timeouts
- connection timeout : time to negotiate a connection successfully
- command timeout : time until the first data is returned (or sometimes a brute force hard limit on when the last of the data has to be returned.
Specify the command timeout value.
