topic Re: Talend Salesforce Connection Error - com.sforce.ws.ConnectionException in Talend Studio

Talend Salesforce Connection Error - com.sforce.ws.ConnectionException

Anonymous — Sat, 16 Nov 2024 10:22:42 GMT

Hi,
I am stuck with this error from a long time now and would appreciate help with this. I am trying to connect Talend to Salesforce and am getting below error for Soap/u/34.0 of Salesforce URL. I am able to get the structure of entity after connecting but unable to load the data. Please help
connecting to socket on port 3944 --This port changes everytime I execute the job
connected
Exception in component tSalesforceOutput_1
java.lang.RuntimeException: com.sforce.ws.ConnectionException: Failed to send request to "Salesforce URL"
at local_project.test_user_load_salesforce_0_1.TEST_USER_LOAD_SALESFORCE.tFileInputDelimited_1Process(TEST_USER_LOAD_SALESFORCE.java:2812)
at local_project.test_user_load_salesforce_0_1.TEST_USER_LOAD_SALESFORCE.runJobInTOS(TEST_USER_LOAD_SALESFORCE.java:4290)
at local_project.test_user_load_salesforce_0_1.TEST_USER_LOAD_SALESFORCE.main(TEST_USER_LOAD_SALESFORCE.java:4147)

Re: Talend Salesforce Connection Error - com.sforce.ws.ConnectionException

Anonymous — Thu, 22 Sep 2016 08:36:59 GMT

Hi,
Could you please post your job setting screenshot into forum? Are you able to load data successfully by client without using talend tool?
Best regards
Sabrina

Re: Talend Salesforce Connection Error - com.sforce.ws.ConnectionException

Anonymous — Thu, 22 Sep 2016 15:42:10 GMT

Hi Sabrina,
Thanks for your response. Please see the job screenshot below.
Yes I am able to load the data into Salesforce from Salesforce data loader but getting this error from Talend. Also, from my local machine data load from Talend is also working fine but this issue is on client network. Is this something related to Firewall security of client?
Can you please tell what port numbers does Talend use to load data into Salesforce? Also, please let me know how Talend would work on Proxy server?

Re: Talend Salesforce Connection Error - com.sforce.ws.ConnectionException

Anonymous — Fri, 23 Sep 2016 08:08:43 GMT

Hi,
Could you please also post the setting screenshot of tSalesforceOutput into forum? Is the "Salesforce URL" Ok with you?
Best regards
Sabrina

Re: Talend Salesforce Connection Error - com.sforce.ws.ConnectionException

TRF — Fri, 23 Sep 2016 19:17:03 GMT

Hi,
If you have a proxy somewhere in the enterprise network, you need to use tSetProxy to declare it (uselly Http Proxy).
If the same job must work with and without this proxy, use a context variable (such as ProxyNeeded True/False).
Test the value of this variable to decide if you need to go on tSetProxy or not.
As a best practice, you should use tSalesforceConnection to connect, then reuse the connection in tSalesforcexxx components.
Regards,
TRF

Re: Talend Salesforce Connection Error - com.sforce.ws.ConnectionException

Anonymous — Mon, 26 Sep 2016 14:34:04 GMT

Hi,
This worked by using tSetProxy component. Thanks a lot for your help