You can translate the question and the replies:

Query timeout after 15 mins

In our case we connected Spotfire to Denodo and querying Oracle DB. Query's that are taking more than exactly 15 mins (running time+data fetching time) are failing with the below error. Failed to get data: Error executing query. Total time 900.002 seconds. QUERY [VIRTUAL] [QUERY_TIMEOUT] QUERY [JDBC WRAPPER] [PROCESSING] QUERY [JDBC ROUTE] [PROCESSING] (HRESULT: 80131500) I have configured query time out setting @ Tools-> admin tool configuration-> connections and changed the query timeout to 0. Now I can see query timeout value as 9223372036854775807 and same for chunk time out. But all of my queries that are running are still failing with timeout error. Please advise at the earliest.
02-04-2016 05:02:27 -0400

1 Answer

Hi, If you are connecting to VDP through the JDBC interface then you need to change the "queryTimeout" JDBC parameter. The default value is 900000 milliseconds. Refer to the section 'PARAMETERS OF THE JDBC CONNECTION URL' of the Virtual DataPort Developer Guide to know more about this option. Hope this helps.
Denodo Team
04-04-2016 12:21:33 -0400
You must sign in to add an answer. If you do not have an account, you can register here