Not able to connect salesforce prod environment

Highlighted
Seven 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


Accepted Solutions
Forteen Stars TRF
Forteen 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://community.talend.com/t5/Design-and-Development/Talend-Salesforce-Connection-Error-com-sforce...


TRF

All Replies
Forteen Stars TRF
Forteen Stars

Re: Not able to connect salesforce prod environment

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


TRF
Seven Stars

Re: Not able to connect salesforce prod environment

I tried with and without proxy. But no luck.

Forteen Stars TRF
Forteen 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
Seven 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

 

Forteen Stars TRF
Forteen 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
Seven 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

Forteen Stars TRF
Forteen 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://community.talend.com/t5/Design-and-Development/Talend-Salesforce-Connection-Error-com-sforce...


TRF
Seven 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?

 

Forteen Stars TRF
Forteen 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
Seven 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.

Forteen Stars TRF
Forteen Stars

Re: Not able to connect salesforce prod environment

Difficult to answer without an idea of the job design


TRF
Seven 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?

Forteen Stars TRF
Forteen 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
Seven 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

Five Stars

Re: Not able to connect salesforce prod environment

Hello,

Have you find a solution for this problem ?

Forteen Stars TRF
Forteen Stars

Re: Not able to connect salesforce prod environment

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


TRF
Five Stars

Re: Not able to connect salesforce prod environment

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.

Five Stars

Re: Not able to connect salesforce prod environment

Hello,

Have you find a solution for this problem ?

Thanks

Five Stars

Re: Not able to connect salesforce prod environment

Hi,

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

Moderator

Re: Not able to connect salesforce prod environment

Hi,

Talend V 6.4 support for salesforce V39 and earlier.

Here is online document about:TalendHelpCenter: Supported systems, databases and business applications by Talend components

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.