Import from SQL error message

1

Hi,

I have a flow that is set up to read from Microsoft SQL database, every 15 minutes, however, from time to time, it starts returning :

"A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The wait operation timed out.) The wait operation timed out

Location: action "Import from database" "

it fails 2 times in succession and then it resumes running without issues.
Is this something that can be mitigated by using any custom property for trusted connection ?

image
image488×308 3.62 KB

Thanks in advance !

Kind regards,
Mihai

2

Hi Mihai,

If you are using EasyMorph's native SQL Server connector, you can try setting the Connect Timeout custom property. The default value of that property is 15.

You can also try adding the ConnectRetryCount and ConnectRetryInterval properties.

Here is a full list of supporter connection properties: