community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

IN-Database Error: Microsoft OLE DB Provider for SQL Server: Protocol error in TDS stream

Highlighted
Meteoroid

Hi,

 

I have a scheduled workflow which accesses data from a SQL server. Once in a while, the flow errors out with the following message:

 

Error: Microsoft OLE DB Provider for SQL Server: Protocol error in TDS stream\HY000

 

Do you have any insights as to what might be causing this issue? 

 

Thanks

Sanjaya

Alteryx Partner

I would there are three possible reasons for this error:

 

1) SQL Server is actually generating incorrect TDS.
2) Something crashes inside SQL Server, and the connection is broken.
3) A network glitch.

 

The fact that the error is intermittent to some extent rules out the first. It does certainly not rule out network problem, as the issue can be a bad cable or similar. Bad does not have to mean completely broken, but contact is only broken when the cable is a certain angle or whatever. It is very common for hardware errors to be intermittent.

You should investigate the SQL Server error log for stack dumps. If you can find stack dumps that coincide with these errors in SSAS, then you know that it is an issue in SQL Server. If there are no stack dumps, I would suspect a hardware problem.

Labels