This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hello to you all,
Maybe you can help me with this recurrent error I am facing
I have the following error when trying to connect with IN-DB to Microsoft SQL.
ERROR: Microsoft OLE DB Provider for SQL Server: Délai d'attente de requete expiré
The table I am trying to read is no more than 250k lignes with 40 columns. I tried reading it with select * , but even when trying to read only one or two columns the error persists
What is strange is that if I persist and launch my workflow 10 times or so, it eventually works. I am trying to find the reason why it doesn't work every time.
I recently installed the version 2019.1 but it doesn't solve the problem.
Did someone encountered this situation before? Do you have any advice ?
Thank you in advance for your help
Hello @badiu ,
It sounds like a problem with the timeout settings. You need to increment the period of time until the connection is suspended.
Set it to 30 or 60 seconds to ensure that the connection is performed.
Thank you @afv2688 for your reply. How and where can I do that?
Thank you for your reply @afv2688 . But where/how can I do these changes?
Depends on who is the one timing out the connection. Usually the server is the one interrupting the connection, therefore it has to be your IT department the one who reconfigures those settings.
If you have remote admin access to the server you could try to use this guide:
The IT team informed me that they extended the timeout from 10 to 20 minutes, but it did not solve the issue.
The timeout error message appears in less than one minute every time the workflow is launched...
Thank you for you answer @afv2688 but it did not resolve my problem. What other origin can this error message have?
Next would be to assure that you are using the right driver and it has been set up correctly. You can check here:
Then try a very simple query to make sure it works.
After, if you want to change the setting you would need to edit the odbc settings.