Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
ALTER.NEXT:

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!

Salesforce SQL Server Bulk Load erroring out after 10,000 rows

Highlighted
6 - Meteoroid

I tried the SQL Server Bulk load both using in-db and without and I get the following message:

 

Info: Data Stream In (50): ODBC Driver version: 03.80
Error: Data Stream In (50): bcp_sendrow failed: [Microsoft][SQL Server Native Client 11.0]Communication link failure[Microsoft][SQL Server Native Client 11.0]Text column data incomplete[Microsoft][SQL Server Native Client 11.0]Communication link failure
Info: Data Stream In (50): The Temporary Table "##AYX4e2991d803d413de0fd8c36abd8946ed" has been created.

 

This works for many other Salesforce objects in the same workflow, but not for the task object.  

 

Does anyone know if I can fix this or just ignore whatever row is casing the issue?

 

Is there a way I can see what is really causing the issue?

 

Thanks

Highlighted
Moderator
Moderator

Hello,

Can you please upload a copy of your workflow and some sample data so we can see what you have set up?

There isnt quite enough information for the Community to begin troubleshooting for you.


Thanks

TrevorS

Community Moderator
Highlighted
6 - Meteoroid

This issue occurred multiple times the same day, but now the process has been working for the past two days.

 

Is there more logging or other places I can do to determine what is was causing the error or if the error reoccurs?

 

Thanks 

Highlighted
Moderator
Moderator

Hello Bob,


The Community would still need to see your workflow and some sample data in order to help you out further. There is not enough information currently for any successful troubleshooting.

 

Thanks
Trevor

Community Moderator
Labels