Not able to connect salesforce prod environment

[Anonymous]

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

[TRF]

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

[Anonymous]

I tried with and without proxy. But no luck.

[TRF]

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.

[Anonymous]

Hi TRF,

I am working in remote system and in Production environment.

Please refer the attached snapshots.

[TRF]

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

[Anonymous]

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

[TRF · Accepted solution]

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

[Anonymous]

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?

[TRF]

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?