Four Stars

Error in tSalesforceConnection component

Hi,
I have ETL job to extract data from Salesforce platform using SOAP API. I use tSalesforceConnection component for authentication purpose. I had no issues in the job until yesterday when suddenly this connection started throwing an error as follow:
(Error is reproduced using sample job. Screenshot is added at the end)

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

I am not sure what could have caused this. I am using Talend Open Studio for DI(6.3.1) and JDK 1.8 and running this job on windows server 2012.

I have also tried making the SOAP request manually and I am able to make the request successfully. I think I am facing this issue in the Talend only.
Any help would be appreciated.
Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Three Stars

Re: Error in tSalesforceConnection component

9 REPLIES
Four Stars

Re: Error in tSalesforceConnection component

I have also encountered the issue today, it appears to have come from nowhere!

 

I have played around with various token and url settings etc to no avail.

 

I am using Talend Open Studio for Data Integration 6.4.1, I am connecting with the tSalesforceInput connector. I'm on JDK 1.8 and Windows 10.

Forteen Stars TRF
Forteen Stars

Re: Error in tSalesforceConnection component

Hi,

Try to change the API version to 39.0


TRF
Four Stars

Re: Error in tSalesforceConnection component

Hi TRF,
I have tried this with API version 37.0, 39.0 and 42.0. Still getting the same error.
Four Stars

Re: Error in tSalesforceConnection component

Similarly, I was already using 39.0 and have tried changing to 42.0 with no success.

Three Stars

Re: Error in tSalesforceConnection component

I also encountered this issue today.

Three Stars

Re: Error in tSalesforceConnection component

Forteen Stars TRF
Forteen Stars

Re: Error in tSalesforceConnection component

It has been like this for a long time ago:
- login.salesfore.com for production
- test.salesforce.com for sandboxes

TRF
Four Stars

Re: Error in tSalesforceConnection component

Thank you for sharing the solution! It drove me mad yesterday afternoon.

Five Stars

Re: Error in tSalesforceConnection component

Check if You're able to login from data loader or SOAP UI.

 

If no then there is some proble with Talend Setting, like URL.

 

If you're not able to login from other tools also, then check login history from under manage users in SalesForce and you'll have to resolve it from there.