MS SQL Server - Timeout setting seems to not be working

Questions
1

I am using the MS SQL Server node to Insert data into a database. However, the dataset is moderately large (± 10.000 records) which caused the query to take more than 15.000 ms.

In order to fix this I set the ‘Connect Timeout’ in the Credential of the MS SQL Server to 300.000 ms:

Screenshot 2021-07-06 at 15.54.27
Screenshot 2021-07-06 at 15.54.271309×164 11 KB

However, when I execute an SQL Server node with the Insert operation I still get the error that the 15.000 ms are exceeded:

Screenshot 2021-07-06 at 15.54.00
Screenshot 2021-07-06 at 15.54.001065×420 72.7 KB

Any tips on how to solve this?

2

Got fixed. It will be available in the next release.

https://github.com/n8n-io/n8n/pull/1971

3

Thanks Ricardo!