topic Query Timeout (ODBC) in Power Query

Query Timeout (ODBC)

ells — Fri, 13 May 2022 09:29:48 GMT

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

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.

Re: Query Timeout (ODBC)

lbendlin — Sat, 14 May 2022 18:17:11 GMT

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.

Re: Query Timeout (ODBC)

ells — Sun, 15 May 2022 09:17:14 GMT

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

Re: Query Timeout (ODBC)

Anonymous — Thu, 23 Jun 2022 12:56:52 GMT

Hello, hope you are well.

How did you do that? I'm having the same error of timeout but I don't know how to set it in the ODBC.

Thanks in advance