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.
I am getting the below error when trying to hit Salesforce output connector.
Salesforce Output: Error transferring data: Failure when receiving data from the peer.
Background - We had made some changes to the Salesforce Output Connector - basically in the download tool, as in to have 'Data' selected from 'Headers' section in Download tool inside 'add batches to the job' sub module, propagated that forward to 'retrieve batch results' sub module, followed by some simple transformations to capture error record details along with the error message in a file.
While using the changed connector I am running into the above mentioned error.
I am not running into the above error -
1) If I am using the original salesforce output connector/deprecated salesforce output connector. This should imply that it has got something to do with changed/modified salesforce output connector.
2) If I am using the changed output salesforce output connector and the number of records is less (less than 152 - approx number).
This might hint towards -
1) Some kind of SFDC governor limits.
2) Data volume and related timeouts.
3) Some erroneous data etc.
On following earlier posts, I could see people being re-directed to have a look at LAN connection settings.
But I believe that since error is not occuring for original salesforce output connector, deprecated version of salesforce output connector, less number of records, it should be something other than LAN settings.
In case anyone has encountered such errors, or knows any related use case, please guide us in this regard.
The Salesforce BULK API has batch size limits. In the underlying Salesforce Output macro, there is a sub-macro called SalesforceOutput.convertToCsvAndBatch that respects these limits when chunking the data before sending to the API. I suspect that your customizations have overridden this logic.
I noticed that after using salesforce input or output connectors a couple of times, I always get this error : "Failure when recieving data from the peer". Also, another thing I noticed is that, when I reboot my laptop, I do not get the error for some time.
I would like to share my workaround here.
My workaround is to renew my IP address. When I renew my IP, I do not get the "Failure when recieving data from the peer" error.
To renew my IP, I was simply rebooting my laptop. Then I realized I could do it by using good old windows command promt. I was simply runnig following two commands in order;
Later on, I wrote above lines in a text file, and saved as renewIP.bat
I have this RenewIP file on my desktop, when I get the "Failure when recieving data from the peer" errror from alteryx, I simply run my renewIP and continue my work in alteryx.