Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

Timeout error on Alteryx gallery for SQL connection

joannasokolowska
8 - Asteroid

Dear Colleagues,

I need your advice regarding the error I receive on Alteryx gallery for scheduled workflows with SQL connections. 

 

The full message is as below. I receive it randomly for some workflows for some days ( Each day error for different workflow, and also on some days without any errors). I am wondering why this is happening randomly and how this can be fixed? 

 

Error SQLDriverConnect: [Microsoft][SQL Server Native Client 11.0]TCP Provider: Timeout error [258]. [Microsoft][SQL Server Native Client 11.0]Login timeout expired[Microsoft][SQL Server Native Client 11.0]Unable to complete login process due to delay in login response

 

Thank you in advance!

Asia

2 REPLIES 2
JagdeeshN
11 - Bolide

Hi @joannasokolowska ,

 

This seems to originate on the SQL Server side due to a timeout setting.

 

On gallery sometimes due to network delay i have encountered the same.

 

Can you please check with your database admin if they can increase the timeout value on the SQL server side?

 

Best,

Jagdeesh

joannasokolowska
8 - Asteroid

Thanks for the suggestion! we will test it with the proper team and check server properties. 

 

Thanks!

asia