Error in tSalesforceConnection component

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.


Accepted Solutions
Four Stars

Re: Error in tSalesforceConnection component


All Replies
Five 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.

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

Re: Error in tSalesforceConnection component

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

Four Stars

Re: Error in tSalesforceConnection component

I also encountered this issue today.

Four Stars

Re: Error in tSalesforceConnection component

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

Re: Error in tSalesforceConnection component

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

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

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

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

Modern Data Engineering in the Cloud

Learn about modern data engineering in the Cloud

Watch Now

How to deploy Talend Jobs as Docker images to Amazon, Azure and Google Cloud reg...

Learn how to deploy Talend Jobs as Docker images to Amazon, Azure and Google Cloud registries

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog