One Star

Exception error in tsalesforce output component

My job is failing when i populate data into account module in salesforce...i dont  understand the reason..
Exception in component tSalesforceOutput_1
org.apache.axis2.AxisFault: Read timed out
at org.apache.axis2.AxisFault.makeFault(AxisFault.java:430)
at org.apache.axis2.transport.http.HTTPSender.sendViaPost(HTTPSender.java:197)
at org.apache.axis2.transport.http.HTTPSender.send(HTTPSender.java:75)
at org.apache.axis2.transport.http.CommonsHTTPTransportSender.writeMessageWithCommons(CommonsHTTPTransportSender.java:404)
at org.apache.axis2.transport.http.CommonsHTTPTransportSender.invoke(CommonsHTTPTransportSender.java:231)
at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:443)
at org.apache.axis2.description.OutInAxisOperationClient.send(OutInAxisOperation.java:406)
at org.apache.axis2.description.OutInAxisOperationClient.executeImpl(OutInAxisOperation.java:229)
at org.apache.axis2.client.OperationClient.execute(OperationClient.java:165)
at com.salesforce.soap.partner.SforceServiceStub.create(SforceServiceStub.java:6651)
at org.talend.salesforce.SforceManagementImpl.insert(SforceManagementImpl.java:574)
disconnected
at enclarity_to_staging.sf_enclarity_master_0_1.SF_ENCLARITY_MASTER.tMSSqlInput_1Process(SF_ENCLARITY_MASTER.java:4851)
at enclarity_to_staging.sf_enclarity_master_0_1.SF_ENCLARITY_MASTER.runJobInTOS(SF_ENCLARITY_MASTER.java:5229)
at enclarity_to_staging.sf_enclarity_master_0_1.SF_ENCLARITY_MASTER.main(SF_ENCLARITY_MASTER.java:5045)
Caused by: java.net.SocketTimeoutException: Read timed out
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(Unknown Source)
at java.net.SocketInputStream.read(Unknown Source)
at sun.security.ssl.InputRecord.readFully(Unknown Source)
at sun.security.ssl.InputRecord.read(Unknown Source)
at sun.security.ssl.SSLSocketImpl.readRecord(Unknown Source)
at sun.security.ssl.SSLSocketImpl.readDataRecord(Unknown Source)
at sun.security.ssl.AppInputStream.read(Unknown Source)
at java.io.BufferedInputStream.fill(Unknown Source)
at java.io.BufferedInputStream.read(Unknown Source)
at org.apache.commons.httpclient.HttpParser.readRawLine(HttpParser.java:78)
at org.apache.commons.httpclient.HttpParser.readLine(HttpParser.java:106)
at org.apache.commons.httpclient.HttpConnection.readLine(HttpConnection.java:1116)
at org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$HttpConnectionAdapter.readLine(MultiThreadedHttpConnectionManager.java:1413)
at org.apache.commons.httpclient.HttpMethodBase.readStatusLine(HttpMethodBase.java:1973)
at org.apache.commons.httpclient.HttpMethodBase.readResponse(HttpMethodBase.java:1735)
at org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.java:1098)
at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:398)
at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171)
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397)
at org.apache.axis2.transport.http.AbstractHTTPSender.executeMethod(AbstractHTTPSender.java:621)
at org.apache.axis2.transport.http.HTTPSender.sendViaPost(HTTPSender.java:193)
... 12 more

please help me out
12 REPLIES
Moderator

Re: Exception error in tsalesforce output component

Hi,
Do you have several tSalesforceInput components using the same account to connect to the server at the same time? Could you please show us your job design screenshots?

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

Re: Exception error in tsalesforce output component

Im using this module/component only once in my job....As you can se from screen shot it is just sql server table,tmap and output component...It is able to populate 200 rows and after that it says read out and job fails.....Im working for the first time with salesforce component..so have no idea about it....i tried running it with 600000 milliseconds than the regular 60000..but it is stilll giving same issues.
One Star

Re: Exception error in tsalesforce output component

Hi,
Do you have several tSalesforceInput components using the same account to connect to the server at the same time? Could you please show us your job design screenshots?

Best regards
Sabrina

I've been having the same behavior as well.  And yes I'm using multiple tSalesForceInput components.
Should I use tSalesforceConnection to establish a connection and then use an existing connection on the tSalesForceInput?
Please help
Thanks
Chris
Four Stars

Re: Exception error in tsalesforce output component

Hi Sabrina,
I'm facing the same issue while connecting with Sales force.  I'm using only one Tsalesforce Input component and reading the data into one csv file or tLog row.
But it throws the below error,
>>>>>>>
connecting to socket on port 3366
connected
Exception in component tSalesforceInput_2
org.apache.axis2.AxisFault: www.salesforce.com
at org.apache.axis2.AxisFault.makeFault(AxisFault.java:430)
at org.apache.axis2.transport.http.HTTPSender.sendViaPost(HTTPSender.java:197)
at org.apache.axis2.transport.http.HTTPSender.send(HTTPSender.java:75)
at org.apache.axis2.transport.http.CommonsHTTPTransportSender.writeMessageWithCommons(CommonsHTTPTransportSender.java:404)
at org.apache.axis2.transport.http.CommonsHTTPTransportSender.invoke(CommonsHTTPTransportSender.java:231)
at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:443)
at org.apache.axis2.description.OutInAxisOperationClient.send(OutInAxisOperation.java:406)
at org.apache.axis2.description.OutInAxisOperationClient.executeImpl(OutInAxisOperation.java:229)
at org.apache.axis2.client.OperationClient.execute(OperationClient.java:165)
at com.salesforce.soap.partner.SforceServiceStub.login(SforceServiceStub.java:17180)
at org.talend.salesforce.SforceBasicConnection.renewSession(SforceBasicConnection.java:77)
at org.talend.salesforce.SforceBasicConnection.init(SforceBasicConnection.java:71)
at org.talend.salesforce.SforceBasicConnection.<init>(SforceBasicConnection.java:49)
at org.talend.salesforce.SforceBasicConnection.<init>(SforceBasicConnection.java:25)
at org.talend.salesforce.SforceBasicConnection$Builder.build(SforceBasicConnection.java:125)
at local_project.my_sf_0_1.my_SF.tSalesforceInput_2Process(my_SF.java:1268)
at local_project.my_sf_0_1.my_SF.runJobInTOS(my_SF.java:2569)
at local_project.my_sf_0_1.my_SF.main(my_SF.java:2426)
Caused by: java.net.UnknownHostException: www.salesforce.com
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.security.ssl.SSLSocketImpl.connect(Unknown Source)
at sun.security.ssl.SSLSocketImpl.<init>(Unknown Source)
at sun.security.ssl.SSLSocketFactoryImpl.createSocket(Unknown Source)
at org.apache.commons.httpclient.protocol.SSLProtocolSocketFactory.createSocket(SSLProtocolSocketFactory.java:82)
at org.apache.commons.httpclient.protocol.ControllerThreadSocketFactory$1.doit(ControllerThreadSocketFactory.java:91)
at org.apache.commons.httpclient.protocol.ControllerThreadSocketFactory$SocketTask.run(ControllerThreadSocketFactory.java:158)
at java.lang.Thread.run(Unknown Source)
disconnected
Job my_SF ended at 12:45 02/02/2016.
<<<<<<


Four Stars

Re: Exception error in tsalesforce output component

Hi Sabrina / Talend Team,
Is there any update on this below Issue!!
Why I'm getting this AxisFault error, when I'm trying to run any job with the SF component.
Note - I could able to connect the metadata successfully, with out any issue.
Four Stars

Re: Exception error in tsalesforce output component

Hello Team,
Any update on the below "org.apache.axis2.AxisFault: test.salesforce.com" issue?
I could able to connect the same SF instances with any number of jobs when i use open Internet.  But since my organization have proxy settings it throws error.
Is there any where I have to do changes for proxy setting?
Note - In metadata level I can successfully connect to SF with proxy, but while running the job I'm facing this error.
Moderator

Re: Exception error in tsalesforce output component

Hi,
Are you using a test account for your SF? Can you successfully access through
https://test.salesforce.com and https://www.salesforce.com by using your account?
Could you please show us your tsalesforceInput component setting screenshot?
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.
Four Stars

Re: Exception error in tsalesforce output component

Hi Sabrina,
Than you!!
I'm using both https://test.salesforce.com/services/Soap/u/34.0https://login.salesforce.com/services/Soap/u/34.0 but for both i could able to retrieve the schema using proxy.  But we could not able to run the job with any salesforce input component.
Screenshot could not be uploaded, due to some server unavailablity in talend forge.
Moderator

Re: Exception error in tsalesforce output component

Hi,
Could you please indicate the build version you are using?
How did you set Salesforce Webservice URL in your tSalesforceInput?
Do you get any proplem when upload screenshots into forum now?
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.
One Star

Re: Exception error in tsalesforce output component

Hi,
I having this issue also. I'm able to connect to test.salesforce.com with the credentials provided and I can list the tables on the component tSalesForce_Input but when running the job it gives me:
%% Invalidated:
main, SEND TLSv1.2 ALERT: fatal, description = certificate_unknown

main, WRITE: TLSv1.2 Alert, length = 2

Exception in component tSalesforceInput_1

org.apache.axis2.AxisFault: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at org.apache.axis2.AxisFault.makeFault(AxisFault.java:430)
at org.apache.axis2.transport.http.SOAPMessageFormatter.writeTo(SOAPMessageFormatter.java:78)
...

I used to have the certificate issue before I imported the certificate from salesforce website but afterwards I managed to connect but using it is not working. I'm missing anything here?
The version i'm using is Talend-Tools-Studio-20151214_1327-V6.1.1
One Star

Re: Exception error in tsalesforce output component

It's working now. My cacerts (java keystore) was corrupted and just had to restore the backup and then it worked. Issue solved
Moderator

Re: Exception error in tsalesforce output component

Hi macrui,
Thanks for your prompt reply and sharing the solution with us.
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.