topic SFDC Salesforce connection error in Talend Studio

SFDC Salesforce connection error

Anonymous — Sat, 16 Nov 2024 08:14:04 GMT

Hi all,

I have a problem that's blocking me,
I just installed talend version 7.0.1 on ubuntu and when I try to run the job, I get a connection error.
the error message is:

Starting job TestAccount_Copy at 09:29 23/05/2018.

[statistics] connecting to socket on port 3498

[statistics] connected

Exception in component tSalesforceConnection_1 (TestAccount_Copy)

java.lang.RuntimeException: IOException: com.sforce.ws.ConnectionException: Failed to send request to https://login.salesforce.com/services/Soap/u/42.0 at Test.testaccount_copy_0_1.testAccount_Copy.tSalesforceConnection_1Process(TestAccount_Copy.java:527)

at Test.Testaccount_copy_0_1.Test_Copy.runJobInTOS(TestAccount_Copy.java:3166)

at_0_1Test.Account_Copy.main(TestAccount_Copy.java:3015)

[statistics] disconnected

Re: SFDC Salesforce connection error

TRF — Wed, 23 May 2018 11:08:51 GMT

Hi,

Do you have a proxy between the machine where the job runs and the Internet?

If so, you need to add and configure a tSetProxy component in your job before the salesforce connection.

Else (not sure at all), try to change the version API from 42.0 to 39.0.

Re: SFDC Salesforce connection error

Anonymous — Wed, 23 May 2018 11:15:41 GMT

Thnx for your reply.
I called the company owner of server and they says : we dont have any proxy and any firewall.
i tried with API 39.0 and it not working

Re: SFDC Salesforce connection error

TRF — Wed, 23 May 2018 11:16:50 GMT

Share your component settings.

Re: SFDC Salesforce connection error

Anonymous — Wed, 23 May 2018 11:27:46 GMT

this is my configuration,

When i use talend with windows it work but on unbuntu it not work.

erreur.png

Re: SFDC Salesforce connection error

manodwhb — Wed, 23 May 2018 11:29:26 GMT

@elioueg,then you should set the proxy with tSetProxy,since in Ubunt it is not working right.

Re: SFDC Salesforce connection error

Anonymous — Wed, 23 May 2018 11:43:14 GMT

@manodwhb thnx for your reply
I add TSetProxy but have always the same errors

Re: SFDC Salesforce connection error

manodwhb — Wed, 23 May 2018 11:44:40 GMT

@elioueg,are you able to ping the serever which you used in tSetProxy from Ubunt?

Re: SFDC Salesforce connection error

Anonymous — Wed, 23 May 2018 11:54:11 GMT

@mandwhb Yes i'am able to ping the server with ip of tSetProxy

Re: SFDC Salesforce connection error

TRF — Wed, 23 May 2018 12:04:02 GMT

Just to be sure, are you able to connect to Salesforce from ubuntu and you browser

Re: SFDC Salesforce connection error

Anonymous — Wed, 23 May 2018 12:10:57 GMT

I just to try now with browser and i can to connect to salesforce from ubuntu and always mo with talend

Re: SFDC Salesforce connection error

manodwhb — Wed, 23 May 2018 12:13:49 GMT

@elioueg,make sure the credentials like URL,password,username,security Token.

Re: SFDC Salesforce connection error

Anonymous — Wed, 23 May 2018 12:29:50 GMT

i m sure it is OK because i use same configuration with windows and it work

Re: SFDC Salesforce connection error

manodwhb — Wed, 23 May 2018 17:34:07 GMT

Can you check same java settup you do have in Windows and Ubuntu systems.

Re: SFDC Salesforce connection error

manodwhb — Thu, 24 May 2018 04:48:57 GMT

@elioueg,if you still have issue,can you tick "Use specific JVM arguments in Advanced settings of Run tab and Build your job. this should fix your issue.

Re: SFDC Salesforce connection error

manodwhb — Tue, 29 May 2018 13:48:28 GMT

@elioueg,still do yoou have this issue?

Re: SFDC Salesforce connection error

Anonymous — Tue, 29 May 2018 16:04:26 GMT

Yes i alwyas have the issue

Re: SFDC Salesforce connection error

Anonymous — Mon, 18 Jun 2018 13:14:26 GMT

I am getting the same exact error.

- Fresh install of Talend Open Studio

- Update to the latest java version

- Create a new SF connection, enter working credentials

- Press 'test connection'

- Getting the afore mentioned error.

Just for fun, I tried the same in version 6.5.1. I picked a working project and created a new connection. To my surprise, I got the same error I am starting to believe this might be a java 1.8 related issue

Re: SFDC Salesforce connection error

TRF — Mon, 18 Jun 2018 13:17:25 GMT

Any proxy to configure before to run the test?

Re: SFDC Salesforce connection error

Anonymous — Mon, 18 Jun 2018 14:18:46 GMT

Hi vvandijk,

Thank you for your reply, I solved m y problem.

I have changed the server version and it works.

I have been ubuntu version and now i have change, i set "centos"