Q&A BY TAG 'QUERY_TIMEOUT'

You must sign in to ask a question. If you do not have an account, you can register here

Push down not working in Dendo Version 7
answered 26-06-2019 08:31:56 -0400

we recently went though an upgrade from Denodo 6 to Denodo 7. We followed the migration guide provided by Denodo. All seemed to have worked. Data was flowing and users logging in. However, some users started placing queries that worked just fine in den...

Answers: 2

RANK Function Migration QUERY_TIMEOUT Rank Upgrade

How to solve QUERY_TIMEOUT
answered 13-08-2018 11:26:05 -0400

How can I solve the QUERY_TIMEOUT after 900 seconds. My connection is: Driver class: oracle.jdbc.OracleDriver Database URI: jdbc:oracle:thin:@10.187.18.24:1521/DOKO As explained in Developer guide, I tried: jdbc:oracle:thin:@10.187.18.24:1521/DOKO?que...

Answers: 3

QUERY_TIMEOUT

Denodo base view times out in 15 minutes (Microsoft SQL Server 2014 (MS Driver))
answered 03-08-2018 12:20:58 -0400

Denodo Server times out when I try to access the base view that takes more than 15 minutes to execute. Since query timeouts are a client side concept only, I have already altered below settings on BOTH the clients: Admin Tool Preference -> Connect...

Answers: 1

JDBC QUERY_TIMEOUT

Denodo Base view times out in 15 minutes
answered 17-07-2018 16:52:34 -0400

Denodo Server still times out when I try to access the base view that takes more than 15 minutes to execute. I have already changed Admin Tool Preference -> Connection -> Query timeout(milliseconds) to ZERO. Admin -> Server Configuration -&g...

Answers: 1

Connection Time out QUERY_TIMEOUT

Max Query Timeout allowed by Denodo
answered 22-06-2017 08:08:39 -0400

I have set the Query Timeout value to Zero (which means no timeout limit). I ran the Gather Statistics for my Base View and the Timeout occurred after 900 seconds (15 minutes). Is the maximum statistics time allowed by Denodo = 15 minutes (900 secon...

Answers: 3

QUERY_TIMEOUT

Connection often timeout
answered 30-06-2016 07:30:37 -0400

we have to use denodo connect the oracle db to retrieve some data. but recently, we find the connection often occur timeout. we checked the interaction between 2 servers and it's ok. sometimes, i open a admin tool to run some sql demo in the denodo ser...

Answers: 1

QUERY_TIMEOUT

Query timeout after 15 mins
answered 04-04-2016 12:21:33 -0400

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 se...

Answers: 1

QUERY_TIMEOUT