Four Stars

SFDC Salesforce connection error

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

 

 

19 REPLIES
Forteen Stars TRF
Forteen Stars

Re: SFDC Salesforce connection error

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.


TRF
Four Stars

Re: SFDC Salesforce connection error

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
Forteen Stars TRF
Forteen Stars

Re: SFDC Salesforce connection error

Share your component settings.


TRF
Four Stars

Re: SFDC Salesforce connection error

this is my configuration,

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

 

 

Twelve Stars

Re: SFDC Salesforce connection error

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

Manohar B
Four Stars

Re: SFDC Salesforce connection error

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

Re: SFDC Salesforce connection error

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

Manohar B
Four Stars

Re: SFDC Salesforce connection error

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

Re: SFDC Salesforce connection error

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

TRF
Four Stars

Re: SFDC Salesforce connection error

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

Re: SFDC Salesforce connection error

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

Manohar B
Four Stars

Re: SFDC Salesforce connection error

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

Re: SFDC Salesforce connection error

Can you check same java settup you do have in Windows and Ubuntu systems.
Manohar B
Twelve Stars

Re: SFDC Salesforce connection error

@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.

Untitled.png

Manohar B
Twelve Stars

Re: SFDC Salesforce connection error

@elioueg,still do yoou have this issue?

Manohar B
Four Stars

Re: SFDC Salesforce connection error

Yes i alwyas have the issue
Two Stars

Re: SFDC Salesforce connection error

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 Smiley Sad I am starting to believe this might be a java 1.8 related issue

Forteen Stars TRF
Forteen Stars

Re: SFDC Salesforce connection error

Any proxy to configure before to run the test?


TRF
Four Stars

Re: SFDC Salesforce connection error

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"