Four Stars

Not able to connect salesforce prod environment

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

  • Data Integration
1 ACCEPTED SOLUTION

Accepted Solutions
Nine Stars TRF
Nine Stars

Re: Not able to connect salesforce prod environment

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

Please, refer to this post https://www.talendforge.org/forum/viewtopic.php?id=53151


TRF
14 REPLIES
Nine Stars TRF
Nine Stars

Re: Not able to connect salesforce prod environment

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


TRF
Four Stars

Re: Not able to connect salesforce prod environment

I tried with and without proxy. But no luck.

Nine Stars TRF
Nine Stars

Re: Not able to connect salesforce prod environment

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.


TRF
Four Stars

Re: Not able to connect salesforce prod environment

Hi TRF,

 

I am working in remote system and in Production environment.

Please refer the attached snapshots.

1.JPG2.JPG

 

Nine Stars TRF
Nine Stars

Re: Not able to connect salesforce prod environment

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


TRF
Four Stars

Re: Not able to connect salesforce prod environment

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

Nine Stars TRF
Nine Stars

Re: Not able to connect salesforce prod environment

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

Please, refer to this post https://www.talendforge.org/forum/viewtopic.php?id=53151


TRF
Four Stars

Re: Not able to connect salesforce prod environment

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?

 

Nine Stars TRF
Nine Stars

Re: Not able to connect salesforce prod environment

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?


TRF
Four Stars

Re: Not able to connect salesforce prod environment

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.

Nine Stars TRF
Nine Stars

Re: Not able to connect salesforce prod environment

Difficult to answer without an idea of the job design


TRF
Four Stars

Re: Not able to connect salesforce prod environment

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

Nine Stars TRF
Nine Stars

Re: Not able to connect salesforce prod environment

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.


TRF
Four Stars

Re: Not able to connect salesforce prod environment

Hi TRF,

 

This problem is coming again even I have included tsetproxy.

It is working sometimes but not always.

billing_connection_error.JPG