Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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
12 - Quasar
12 - Quasar

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