This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Using the scheduler to download tables from Salesforce and write them into a MS SQL server. This works fine when run manually. But when run on the scheduler gets error "Error transferring data: Failure when receiving data from the peer"
This used to be a common error on the deprecated salesforce connector when running manually. So happy to say the new salesforce connector works without this error except when scheduled.
I am unable to set an alias and there is no other config I can change.
Agreed. First thing I'd do is check with your IT to make sure the Salesforce API isn't blocked by the firewall on your server. If you need immediate assistance on the Alteryx side I'd suggest you reach out to Support: http://www.alteryx.com/support
To elaborate, from your original post, it sounds as though when you run locally the Salesforce tool runs successfully. When you schedule to run on the server, that's when you start having issues. This indicates to me that the Salesforce tool is working properly - the problem is that the firewall on the server is blocking your connection to the Salesforce API. I'll again recommend that the fastest way to get a resolution to the problem is to contact Alteryx support here: http://www.alteryx.com/support. However if you you would prefer to continue the conversation here please answer the following questions.
What version of Alteryx are you running?
Does the scheduled process error every time in the same manner or does it sometimes complete successfully?
We have people here at Alteryx that successfully use the Salesforce Input tool in scheduled workflows. If you can, you could try to remote desktop into the server that is running the workflow and run the process manually there to test the connection.