Simple SalesforceInput not working

Anonymous — Sat, 16 Nov 2024 11:32:44 GMT

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.

Any help would be appreciated.
Thanks!

Re: Simple SalesforceInput not working

Anonymous — Wed, 13 Aug 2014 23:39:52 GMT

Can you post a screenshot of your SFDC input component config (make sure to blank out username/password)?

Re: Simple SalesforceInput not working

Anonymous — Thu, 14 Aug 2014 00:01:15 GMT

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

topic Re: Simple SalesforceInput not working in Talend Studio

Simple SalesforceInput not working

Re: Simple SalesforceInput not working

Re: Simple SalesforceInput not working