Four Stars

tSalesforceconnection issue. Failed to send request to https://www.salesforce.com/services/Soap/u/37.0

Hi Community,

 

I am trying to connect Talend to Salesforce by using tSalesForceConnection component with my salesforce playground credentials.

And i always get the error message as :

 

connecting to socket on port 3372
connected
Exception in component tSalesforceConnection_1
java.lang.RuntimeException: com.sforce.ws.ConnectionException: Failed to send request to https://www.salesforce.com/services/Soap/u/37.0
at local_project.test_salesforce_connection_0_1.Test_Salesforce_connection.tSalesforceConnection_1Process(Test_Salesforce_connection.java:365)
at local_project.test_salesforce_connection_0_1.Test_Salesforce_connection.runJobInTOS(Test_Salesforce_connection.java:650)
at local_project.test_salesforce_connection_0_1.Test_Salesforce_connection.main(Test_Salesforce_connection.java:484)
[FATAL]: local_project.test_salesforce_connection_0_1.Test_Salesforce_connection - tSalesforceConnection_1 com.sforce.ws.ConnectionException: Failed to send request to https://www.salesforce.com/services/Soap/u/37.0
[statistics] disconnected

 

I am able to access salesforce.com with the same credentials in a browser but not in Talend.

I would really appreciate any help with this.

 

  • Data Integration
Tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions
Seven Stars TRF
Seven Stars

Re: tSalesforceconnection issue. Failed to send request to https://www.salesforce.com/services/Soap/u/37.0

Can you try to connect to Salesforce using data loader? If it works, the problem is local to TDI. Else, it's probably due to a proxy you need to cross to access Internet.
Maybe your colleagues are not on the same network you are. To be sure, you can also try using your mobile as access point to bypass any network component.
Here a link to a similar question I solved to someone in the past https://www.talendforge.org/forum/viewtopic.php?id=53151
Hope this helps.

TRF
8 REPLIES
Seven Stars TRF
Seven Stars

Re: tSalesforceconnection issue. Failed to send request to https://www.salesforce.com/services/Soap/u/37.0

Hi,

Are you try to connect to a production or a sandbox environment?

If trying to a sandbox, change the Salesforce URL to "https://test.salesforce.com/services/Soap/u/38.0".

Hope this helps.


TRF
Four Stars

Re: tSalesforceconnection issue. Failed to send request to https://www.salesforce.com/services/Soap/u/37.0

I have tried with test.salesforce.com/services/Soap/u/38.0 as well. It
still shows the same error Smiley Sad
Four Stars

Re: tSalesforceconnection issue. Failed to send request to https://www.salesforce.com/services/Soap/u/37.0

I failed to mention. I am using Talend DI 6.3.1 version.

Seven Stars TRF
Seven Stars

Re: tSalesforceconnection issue. Failed to send request to https://www.salesforce.com/services/Soap/u/37.0

Does this error arrives immediately or do you have to wait for some seconds before?

Do you have configured any proxy to touch Salesforce (using tSetProxy) or not?

Are you sure about the version (37 or 38)?

Else, can you share the job?


TRF
Four Stars

Re: tSalesforceconnection issue. Failed to send request to https://www.salesforce.com/services/Soap/u/37.0

It takes few seconds to throw this error.

And I haven't done any proxy settings with tSetproxy. Do I have to do that ?
But I tried the same job from my colleagues system and it just connected
without any proxy settings in DI 6.3.1
I am not sure what is the exact solution though.

Capture.PNG

 

 

 

Seven Stars TRF
Seven Stars

Re: tSalesforceconnection issue. Failed to send request to https://www.salesforce.com/services/Soap/u/37.0

Can you try to connect to Salesforce using data loader? If it works, the problem is local to TDI. Else, it's probably due to a proxy you need to cross to access Internet.
Maybe your colleagues are not on the same network you are. To be sure, you can also try using your mobile as access point to bypass any network component.
Here a link to a similar question I solved to someone in the past https://www.talendforge.org/forum/viewtopic.php?id=53151
Hope this helps.

TRF
Four Stars

Re: tSalesforceconnection issue. Failed to send request to https://www.salesforce.com/services/Soap/u/37.0

Hi TRF. In Windows Services there was a setting which disabled access to cloud service due to which I couldn't connect to salesforce.
After aborting it the connection was successful.
Thanks for the help. I really appreciate it.
Seven Stars TRF
Seven Stars

Re: tSalesforceconnection issue. Failed to send request to https://www.salesforce.com/services/Soap/u/37.0

Great!
Thank's for sharing this tip

TRF