Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Difficult to answer without an idea of the job design
Could you please let me know the use of proxy in this case? why it is not working without proxy?? any idea?
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.
Hi TRF,
This problem is coming again even I have included tsetproxy.
It is working sometimes but not always.
Hello,
Have you find a solution for this problem ?
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).
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.
Hello,
Have you find a solution for this problem ?
Thanks
Hi,
Its due to a large data in salesforce component on select, so my solution is to use bulk mode on tsalesforceinput