Q&A BY TAG 'QUERY_TIMEOUT'
VDP configuration
answered
19-04-2022 23:51:32 -0400
Hi Team, How can i configure the VDP configuration in sigle command cetralized location like setting query limit in all vdp in sigle query or command without login every vdp admin tool to do the changes. Thanks
Answers:
1
Remote table creation timesout in Design Studio
answered
17-11-2021 17:53:32 -0500
Hi Team, When creating Remote Table from Design Studio for a fairly large data set, the query times out and thus the creation of remote table. Is there a way to run it in backgroud? Atleast the population of data in background? After increasing the q...
Answers:
2
How to solve QUERY_TIMEOUT
answered
24-06-2020 16:51:48 -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:
8
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
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
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
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
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 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