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
Highlighted
Three Stars

Re: Error in tSalesforceConnection component

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

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

Highlighted
Three Stars

Re: Error in tSalesforceConnection component

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