Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
48 | |
19 | |
13 | |
11 |