Timeout Error in Connect Cloud

  • 23 March 2023
  • 1 reply

Userlevel 1

I’m facing a timeout error when executing queries to tables for a given connection in Connect Cloud. The error message is as follows: 

[ERROR] Execution of the SELECT query failed. Error: Timeout when wait response.

I tried to increase the Timeout value in the connection Advanced Settings tab, but nothing changed. What should I do? 


Best answer by Rodrigo de Albuquerque 23 March 2023, 22:20

View original

1 reply

Userlevel 1

The default value for the timeout in the Advanced Settings Tab is 30 seconds. That means that after 30 seconds of execution of the query, the process will timeout no matter the state of completion of the query. Therefore, if the query takes longer than 30 seconds to execute due to the amount of data or for other reasons, then the Timeout property in the Advanced Settings tab should be changed to something other than 30 seconds.

The best option here is to make Timeout = 0, because Timeout set to 0 will make the query run until it fully completes or until it encounters an error.  It is essential that you hit the "Save Changes" button before you proceed in order to save the new Timeout value.