I am testing talend to see if it can replace Pervasive Data Integrator in our environment. Today my goal was just to confirm that we can get data in and out of Salesforce, so I put together what I think is the simplest job.
tSalesforceConnection_1 (seems to work fine)
tSalesforceInput_1 (uses connection above, queries the Id on the User object--errors out)
tFileOutPutDelimited_1 (just trying to throw those Ids into the output file--error above keeps me from ever getting this far)
I've been searching forum posts and reading the documentation without much luck. I've also tried creating and using a repository connection without luck. The error always looks like the following:
Starting job Test at 16:26 13/08/2014. connecting to socket on port 3918 connected Aug 13, 2014 4:26:36 PM org.apache.axis2.transport.http.HTTPSender sendViaPost INFO: Unable to sendViaPost to url[] org.apache.axis2.AxisFault: Transport error: 411 Error: Length Required at org.apache.axis2.transport.http.HTTPSender.handleResponse(HTTPSender.java:310) at org.apache.axis2.transport.http.HTTPSender.sendViaPost(HTTPSender.java:194) 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.queryAll(SforceServiceStub.java:5133) at org.talend.salesforce.SforceManagementImpl.queryAll(SforceManagementImpl.java:900) at i360_test_2.test_0_1.Test.tSalesforceInput_1Process(Test.java:784) at i360_test_2.test_0_1.Test.runJobInTOS(Test.java:1210) at i360_test_2.test_0_1.Test.main(Test.java:1057) Exception in component tSalesforceInput_1 org.apache.axis2.AxisFault: Transport error: 411 Error: Length Required at org.apache.axis2.transport.http.HTTPSender.handleResponse(HTTPSender.java:310) at org.apache.axis2.transport.http.HTTPSender.sendViaPost(HTTPSender.java:194) 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.queryAll(SforceServiceStub.java:5133) at org.talend.salesforce.SforceManagementImpl.queryAll(SforceManagementImpl.java:900) disconnected at i360_test_2.test_0_1.Test.tSalesforceInput_1Process(Test.java:784) at i360_test_2.test_0_1.Test.runJobInTOS(Test.java:1210) at i360_test_2.test_0_1.Test.main(Test.java:1057) Job Test ended at 16:26 13/08/2014.
Here's the insert component, referencing the existing connection:
http://imgur.com/sXY8yaS,AykYfjy The existing connection:
http://imgur.com/sXY8yaS,AykYfjy#1 It doesn't seem to matter if I put the connection information directly into the Input component or not. The error is the same
