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
View originalThe 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.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Data Connectors
ETL/ ELT Solutions
Cloud & API Connectivity
OEM & Custom Drivers
