You can translate the question and the replies:

Incremental Cache Stored Procedure times out after 80 seconds

We are running the incremental cache stored procedure to insert/update records since the @LASTCACHEREFRESH. The procedure continues to fail with a generic error 'Finished with error: ERROR executing query update of cache [Rows updated in cache: 0].'. In order to troubleshoot we changed our log settings to trace and took a look in vdp.log. This reveals that we are getting a timeout at 80 seconds. The error states 'Caused by: java.sql.SQLException: Error: Time out processing data' and it happens each time after exactly 80 seconds. My question is whether this error is stating we have a timeout in the source (Azure SQL DW which seems unlikely) the cache db (SQL Server) or in Denodo? In the VDP Admin tool we have the timeout set to 1 hour. The chunk timeout is 15 seconds. Is there a timeout for the stored procedure executions anywhere? I'm stumped on where/how to troubleshoot. Thanks!
user
18-06-2020 13:55:41 -0400

2 Answers

Answered my own question. I missed that there's a separate setting for stored procedure query timeouts. https://community.denodo.com/docs/html/browse/7.0/vdp/administration/server_administration_-_configuring_the_server/configuring_runtime_parameters_for_stored_procedures/configuring_runtime_parameters_for_stored_procedures
user
18-06-2020 13:59:34 -0400
Hi, I am glad you are able to solve the problem. For more details, you can refer to the Timeout Consideration Section of the [Denodo Incremental Cache Load Stored Procedure - User Manual](https://community.denodo.com/docs/html/document/denodoconnects/7.0/Denodo%20Incremental%20Cache%20Load%20Stored%20Procedure%20-%20User%20Manual). Hope this helps!
Denodo Team
29-06-2020 06:16:49 -0400
You must sign in to add an answer. If you do not have an account, you can register here