Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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
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
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
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.