topic Re: Exception error in tsalesforce output component in Talend Studio

Exception error in tsalesforce output component

Anonymous — Sat, 16 Nov 2024 11:21:03 GMT

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

Re: Exception error in tsalesforce output component

Anonymous — Fri, 16 Jan 2015 06:49:13 GMT

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

Re: Exception error in tsalesforce output component

Anonymous — Fri, 16 Jan 2015 15:37:37 GMT

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.

Re: Exception error in tsalesforce output component

_AnonymousUser — Sat, 28 Feb 2015 00:51:40 GMT

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

Re: Exception error in tsalesforce output component

Anonymous — Tue, 02 Feb 2016 07:35:58 GMT

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

Re: Exception error in tsalesforce output component

Anonymous — Thu, 25 Feb 2016 06:01:15 GMT

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.

Re: Exception error in tsalesforce output component

Anonymous — Thu, 03 Mar 2016 04:53:39 GMT

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.

Re: Exception error in tsalesforce output component

Anonymous — Thu, 03 Mar 2016 08:35:43 GMT

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

Re: Exception error in tsalesforce output component

Anonymous — Thu, 03 Mar 2016 11:35:19 GMT

Hi Sabrina,
Than you!!
I'm using both https://test.salesforce.com/services/Soap/u/34.0 & https://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.

Re: Exception error in tsalesforce output component

Anonymous — Fri, 04 Mar 2016 09:00:27 GMT

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

Re: Exception error in tsalesforce output component

Anonymous — Tue, 16 Aug 2016 14:48:10 GMT

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

Re: Exception error in tsalesforce output component

Anonymous — Tue, 16 Aug 2016 18:57:31 GMT

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

Re: Exception error in tsalesforce output component

Anonymous — Wed, 17 Aug 2016 08:54:08 GMT

Hi macrui,
Thanks for your prompt reply and sharing the solution with us.
Best regards
Sabrina