Cast your vote for the official 2025 Inspire Pin! Designs were submitted by fellow Community members and reflect the creativity and passion of Alteryx users across the globe. Vote now!
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Error on Data Stream Out

gabbie_391
5 - Atom

Hello,

 

Has anybody seen this issue before?

Error: Data Stream Out (1390): Error SQLExtendedFetch: [Microsoft][ODBC SQL Server Driver]Error in row[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.

 

Our workflow ran for 3.5 hrs with 1 error, and it's on the data stream out connector from Connect In-DB. Our SQL script runs fine in Management Studio with about 850k rows. 

 

Any inputs is appreciated. Thank you!

4 REPLIES 4
paultno
8 - Asteroid

Have you tried running with just a small sample of rows?

gabbie_391
5 - Atom
Yes, if I do Select Top # it works
paultno
8 - Asteroid

Is it possible to optimize the workflow?  That has helped me with data stream out errors. 

gabbie_391
5 - Atom
What I ended up doing is on my SQL script I put Select Top 1000000 (to give me wiggle room in case we have more than 850k data) then I deleted data stream out and re-added it again. My workflow ran in 9 mins.
Labels
Top Solution Authors