topic Re: Not able to connect salesforce prod environment in Talend Studio

Not able to connect salesforce prod environment

Anonymous — Sat, 16 Nov 2024 09:37:33 GMT

Hi,
I am getting below error while connecting to salesforce using tsalesforceinput. Please help me.
It was working in 5.6v later I imported into 6.3v, now the error is coming.
Is it related to SSL certificate? If it is,then how to enable SSL connection in Talend 6.3?

Exception in component tSalesforceInput_1
java.io.IOException: com.sforce.ws.ConnectionException: *Failed to send request to https://eu3.salesforce.com/services/Soap/u/33.0/00D200000000MZB*
    at org.talend.components.salesforce.runtime.SalesforceInputReader.start(SalesforceInputReader.java:104)
    at ccp_project.e_billing_td_to_sfdc_edit_0_1.e_billing_td_to_sfdc_EDIT.tSalesforceInput_1Process(e_billing_td_to_sfdc_EDIT.java:7434)
    at ccp_project.e_billing_td_to_sfdc_edit_0_1.e_billing_td_to_sfdc_EDIT.tWarn_8Process(e_billing_td_to_sfdc_EDIT.java:6963)
    at ccp_project.e_billing_td_to_sfdc_edit_0_1.e_billing_td_to_sfdc_EDIT.tWarn_7Process(e_billing_td_to_sfdc_EDIT.java:6830)
    at ccp_project.e_billing_td_to_sfdc_edit_0_1.e_billing_td_to_sfdc_EDIT.tJava_3Process(e_billing_td_to_sfdc_EDIT.java:6709)
    at ccp_project.e_billing_td_to_sfdc_edit_0_1.e_billing_td_to_sfdc_EDIT.tWarn_3Process(e_billing_td_to_sfdc_EDIT.java:6590)
    at ccp_project.e_billing_td_to_sfdc_edit_0_1.e_billing_td_to_sfdc_EDIT.tMysqlInput_1Process(e_billing_td_to_sfdc_EDIT.java:6416)
    at ccp_project.e_billing_td_to_sfdc_edit_0_1.e_billing_td_to_sfdc_EDIT.tSetProxy_2Process(e_billing_td_to_sfdc_EDIT.java:10814)
    at ccp_project.e_billing_td_to_sfdc_edit_0_1.e_billing_td_to_sfdc_EDIT.tJava_6Process(e_billing_td_to_sfdc_EDIT.java:11897)
    at ccp_project.e_billing_td_to_sfdc_edit_0_1.e_billing_td_to_sfdc_EDIT.tWarn_5Process(e_billing_td_to_sfdc_EDIT.java:11784)
    at ccp_project.e_billing_td_to_sfdc_edit_0_1.e_billing_td_to_sfdc_EDIT.tTeradataInput_2Process(e_billing_td_to_sfdc_EDIT.java:11611)
    at ccp_project.e_billing_td_to_sfdc_edit_0_1.e_billing_td_to_sfdc_EDIT.tJava_4Process(e_billing_td_to_sfdc_EDIT.java:9586)
    at ccp_project.e_billing_td_to_sfdc_edit_0_1.e_billing_td_to_sfdc_EDIT.runJobInTOS(e_billing_td_to_sfdc_EDIT.java:16229)
    at ccp_project.e_billing_td_to_sfdc_edit_0_1.e_billing_td_to_sfdc_EDIT.main(e_billing_td_to_sfdc_EDIT.java:15658)
Caused by: com.sforce.ws.ConnectionException: Failed to send request to https://eu3.salesforce.com/services/Soap/u/33.0/00D200000000MZB
    at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:121)
    at com.sforce.soap.partner.PartnerConnection.query(PartnerConnection.java:1171)
    at org.talend.components.salesforce.runtime.SalesforceInputReader.executeSalesforceQuery(SalesforceInputReader.java:143)
    at org.talend.components.salesforce.runtime.SalesforceInputReader.start(SalesforceInputReader.java:91)
    ... 13 more
Caused by: java.net.SocketException: Unexpected end of file from server
    at sun.net.www.http.HttpClient.parseHTTPHeader(Unknown Source)
    at sun.net.www.http.HttpClient.parseHTTP(Unknown Source)
    at sun.net.www.protocol.http.HttpURLConnection.getInputStream0(Unknown Source)
    at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
    at sun.net.www.protocol.https.HttpsURLConnectionImpl.getInputStream(Unknown Source)
    at com.sforce.ws.transport.JdkHttpTransport.getContent(JdkHttpTransport.java:204)
    at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:97)
    ... 16 more

Re: Not able to connect salesforce prod environment

TRF — Fri, 16 Jun 2017 11:32:25 GMT

You probably need to configure a proxy on Talend side using tSetProxy.

Re: Not able to connect salesforce prod environment

Anonymous — Fri, 16 Jun 2017 11:36:29 GMT

I tried with and without proxy. But no luck.

Re: Not able to connect salesforce prod environment

TRF — Fri, 16 Jun 2017 11:51:11 GMT

To be sure the proxy is configured as expected, you can bypass it using your mobile connection (this suppose you have a mobile with the appropriate network such as 4g).

Also carefully check Salesforce URL parameter expected for connection.

Maybe can you share the tSalesforceInput component configuration.

Re: Not able to connect salesforce prod environment

Anonymous — Fri, 16 Jun 2017 11:53:44 GMT

Hi TRF,

I am working in remote system and in Production environment.

Please refer the attached snapshots.

Re: Not able to connect salesforce prod environment

TRF — Fri, 16 Jun 2017 12:14:49 GMT

check the value of context.salesforce_url, it should be https://login.salesforce.com/services/Soap/u/39.0

Re: Not able to connect salesforce prod environment

Anonymous — Fri, 16 Jun 2017 12:17:01 GMT

I tried...

Exception in component tSalesforceInput_2
java.lang.RuntimeException: com.sforce.ws.ConnectionException: Failed to send request to https://login.salesforce.com/services/Soap/u/33.0
   at ccp_project.e_billing_td_to_sfdc_edit_0_1.e_billing_td_to_sfdc_EDIT.tSalesforceInput_2Process(e_billing_td_to_sfdc_EDIT.java:6523)
   at ccp_project.e_billing_td_to_sfdc_edit_0_1.e_billing_td_to_sfdc_EDIT.runJobInTOS(e_billing_td_to_sfdc_EDIT.java:9581)
   at ccp_project.e_billing_td_to_sfdc_edit_0_1.e_billing_td_to_sfdc_EDIT.main(e_billing_td_to_sfdc_EDIT.java:9023)
[statistics] disconnected

Re: Not able to connect salesforce prod environment

TRF — Fri, 16 Jun 2017 12:59:08 GMT

I'm pretty sure it's coming from your proxy.

Please, refer to this post https://community.talend.com/t5/Design-and-Development/Talend-Salesforce-Connection-Error-com-sforce-ws/m-p/68119

Re: Not able to connect salesforce prod environment

Anonymous — Fri, 16 Jun 2017 13:22:10 GMT

Hi TRF,

Thanks for you reply.

As per my job design, I have used tsetproxy in the Prejob.

And after that so many subjobs available, and in middle the error causing subjob exist. In this case, when I am running I am getting the above mentioned error.

But when I disabled all other subjobs (only prejob components and one subjob) and tried to run, It is working!.

So do we need to use the proxy component in multiple places?

Re: Not able to connect salesforce prod environment

TRF — Fri, 16 Jun 2017 13:25:31 GMT

Usually not, you set the proxy when the job starts and that's all.

Can you share your job design, maybe something wrong regarding how subjobs are linked with each other?

Re: Not able to connect salesforce prod environment

Anonymous — Fri, 16 Jun 2017 13:28:08 GMT

In between I have used trunjob to call child job. So the control will go to child and coming back to parent. I suspect this causes the issue.

Re: Not able to connect salesforce prod environment

TRF — Fri, 16 Jun 2017 13:39:01 GMT

Difficult to answer without an idea of the job design

Re: Not able to connect salesforce prod environment

Anonymous — Fri, 16 Jun 2017 14:04:28 GMT

Could you please let me know the use of proxy in this case? why it is not working without proxy?? any idea?

Re: Not able to connect salesforce prod environment

TRF — Fri, 16 Jun 2017 14:15:57 GMT

Because there is a proxy on your network somewhere between the computer where you run the jobs and the Internet network.

Refer to your network administrator for details.

Re: Not able to connect salesforce prod environment

Anonymous — Wed, 21 Jun 2017 13:46:23 GMT

Hi TRF,

This problem is coming again even I have included tsetproxy.

It is working sometimes but not always.

Re: Not able to connect salesforce prod environment

Anonymous — Fri, 15 Dec 2017 12:49:39 GMT

Hello,

Have you find a solution for this problem ?

Re: Not able to connect salesforce prod environment

TRF — Fri, 15 Dec 2017 13:02:58 GMT

Try to change API version from 33.0 to 39.0

Forget this post, I thought the same problem come again (but using the last compatible API version is sometime a good idea).

Re: Not able to connect salesforce prod environment

Anonymous — Fri, 15 Dec 2017 14:34:00 GMT

Talend 631 not support 39.0 salesforce api, i have in my job 35.0, it works with 35.0 but its random.

It is working sometimes but not always.

Re: Not able to connect salesforce prod environment

Anonymous — Tue, 19 Dec 2017 14:31:34 GMT

Hello,

Have you find a solution for this problem ?

Thanks

Re: Not able to connect salesforce prod environment

Anonymous — Tue, 19 Dec 2017 15:49:21 GMT

Hi,

Its due to a large data in salesforce component on select, so my solution is to use bulk mode on tsalesforceinput