topic Re: Error in tSalesforceConnection component in Talend Studio

Error in tSalesforceConnection component

Anonymous — Sat, 16 Nov 2024 08:21:48 GMT

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.

Re: Error in tSalesforceConnection component

Anonymous — Mon, 23 Apr 2018 15:47:25 GMT

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.

Re: Error in tSalesforceConnection component

TRF — Mon, 23 Apr 2018 16:09:37 GMT

Hi,

Try to change the API version to 39.0

Re: Error in tSalesforceConnection component

Anonymous — Mon, 23 Apr 2018 16:12:47 GMT

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

Re: Error in tSalesforceConnection component

Anonymous — Mon, 23 Apr 2018 16:30:28 GMT

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

Re: Error in tSalesforceConnection component

Anonymous — Mon, 23 Apr 2018 17:15:28 GMT

I also encountered this issue today.

Re: Error in tSalesforceConnection component

Anonymous — Mon, 23 Apr 2018 18:36:50 GMT

Uggghhh super simple It looks like the API endpoints have changed...

Update your URLs to "https://login.salesforce.com/services/Soap/u/39.0"

https://help.salesforce.com/articleView?id=000229717&type=1

https://help.salesforce.com/articleView?id=Updating-Hard-Coded-References-FAQ&type=1

Re: Error in tSalesforceConnection component

TRF — Mon, 23 Apr 2018 20:29:38 GMT

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

Re: Error in tSalesforceConnection component

Anonymous — Tue, 24 Apr 2018 10:21:02 GMT

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

Re: Error in tSalesforceConnection component

Anonymous — Mon, 11 Jun 2018 17:29:05 GMT

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.