SFDC Salesforce connection error

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

 

 

Fifteen Stars TRF
Fifteen 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
Fifteen Stars TRF
Fifteen 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.

 

 

Forteen 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
Don't forget to give kudos/accept the solution when a replay is helpful.
Four Stars

Re: SFDC Salesforce connection error

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

Re: SFDC Salesforce connection error

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

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Four Stars

Re: SFDC Salesforce connection error

@mandwhb Yes i'am able to ping the server with ip of tSetProxy
Fifteen Stars TRF
Fifteen 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
Forteen Stars

Re: SFDC Salesforce connection error

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

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Four Stars

Re: SFDC Salesforce connection error

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

Re: SFDC Salesforce connection error

Can you check same java settup you do have in Windows and Ubuntu systems.
Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Forteen 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
Don't forget to give kudos/accept the solution when a replay is helpful.
Forteen Stars

Re: SFDC Salesforce connection error

@elioueg,still do yoou have this issue?

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
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

Fifteen Stars TRF
Fifteen 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"

 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download