Communication Link Error with and without BCP Sendrow Failed Error on Designer

[ricko99]

Hi all,

I am currently working on a database migration project, re-creating datasets that exist on my company's on-premise SQL database to new Azure SQL DB and Azure Synapse Analytics server. I am facing difficulties in loading certain tables to both Azure environments, with myself kept receiving these two errors sporadically on Alteryx Designer outputs:

Communication link failure with BCP sendrow fail

Communication link failure without BCP sendrow fail (usually happens once the workflow tries to execute the PostSQL statements, which I have tested and worked when I executed from SQL Server management studio).

These are some of the Alteryx details that I can provide:

Alteryx Designer version: 2020.1.5.25447

ODBC Driver version: 03.80

Connection type: BULK

I doubt the errors are due to the size of the tables as I was able to load the same exact tables to my on-premise SQL database without facing these two issues. I have tried increasing the transaction size on the designer from the default 10000 to other numbers eg. 30000 or 60000 but the errors still happened every now and then.

Could anyone provide a hint on a possible solution for me to escalate to my company's Alteryx server administrator?

Thanks.

[danilang]

Hi @ricko99 

Since you mention that you've been able to load similar sized datasets to your internal SQL DB, you should probably reach out to to your Azure administrators to see if you running into limitations imposed by the Azure platform.  I think that the "Host" in the error messages that you're receiving refer to the Azure DD host and not the Alteryx Gallery host.   Perhaps there is an enforced timeout, or maximum transaction size imposed on the receiving end.

Dan

[ricko99]

Hi @danilang

Thank you for the reply. Noted on that, I will try to get in touch with my company's data enablement team and check if there's any settings within Azure platform that they need to configure to cater for bigger datasets.