topic tSalesForceInput Exception in Talend Studio

tSalesForceInput Exception

Anonymous — Sat, 16 Nov 2024 11:40:42 GMT

Hello,
This is the first time while i am connecting to sales force . When i try to connect to some module it again and again gives me same exception. I tried changing Modules but it displays the same exception
Any Help Will Be Great !!!

EXCEPTION
Starting job Session_1 at 14:40 22/04/2014.

connecting to socket on port 4038
connected
Exception in component tSalesforceInput_2
org.apache.axis2.AxisFault: org.apache.axis2.databinding.ADBException: Unexpected subelement {urn:enterprise.soap.sforce.com}done
at org.apache.axis2.AxisFault.makeFault(AxisFault.java:430)
at com.salesforce.soap.partner.SforceServiceStub.fromOM(SforceServiceStub.java:21015)
at com.salesforce.soap.partner.SforceServiceStub.query(SforceServiceStub.java:8076)
at org.talend.salesforce.SforceManagementImpl.query(SforceManagementImpl.java:825)
at daily_reporting.session_1_0_1.Session_1.tSalesforceInput_2Process(Session_1.java:780)
at daily_reporting.session_1_0_1.Session_1.tSalesforceConnection_1Process(Session_1.java:353)
at daily_reporting.session_1_0_1.Session_1.runJobInTOS(Session_1.java:1188)
at daily_reporting.session_1_0_1.Session_1.main(Session_1.java:1056)
Caused by: java.lang.Exception: org.apache.axis2.databinding.ADBException: Unexpected subelement {urn:enterprise.soap.sforce.com}done
at com.salesforce.soap.partner.QueryResult$Factory.parse(QueryResult.java:678)
disconnected
at com.salesforce.soap.partner.QueryResponse$Factory.parse(QueryResponse.java:340)
at com.salesforce.soap.partner.SforceServiceStub.fromOM(SforceServiceStub.java:19813)
... 6 more
Caused by: org.apache.axis2.databinding.ADBException: Unexpected subelement {urn:enterprise.soap.sforce.com}done
at com.salesforce.soap.partner.QueryResult$Factory.parse(QueryResult.java:562)
... 8 more
Job Session_1 ended at 14:40 22/04/2014.

Re: tSalesForceInput Exception

Anonymous — Wed, 23 Apr 2014 03:17:50 GMT

Hi,
I supposed you have checked component reference TalendHelpCenter:tSalesforceInput. Could you please upload your component setting screenshot into forum so that we can address your issue quickly.
Best regards
Sabrina

Re: tSalesForceInput Exception

Anonymous — Wed, 23 Apr 2014 06:56:45 GMT

Hi xdshi,
Thanks for your quick response , i am attaching the setting snapshot for the component. I have imported the schema by all modules and save them in Repository.

Re: tSalesForceInput Exception

Anonymous — Wed, 23 Apr 2014 07:08:20 GMT

It appears to be a very old version of the SOAP service (8.0). could that be the issue?

Re: tSalesForceInput Exception

Anonymous — Wed, 23 Apr 2014 08:30:46 GMT

Hi Ankit,
Whether the metadata of your Salesforce module and the metadata which you created are matching?
Vaibhav

Re: tSalesForceInput Exception

Anonymous — Wed, 23 Apr 2014 19:20:44 GMT

I've taken a slightly different approach to getting changes from Salesforce and I've described some of they key points here http://www.talendbyexample.com/salesforce-change-data-capture.html

Re: tSalesForceInput Exception

Anonymous — Thu, 24 Apr 2014 06:34:31 GMT

Hi sanvaibhav,
Yes , i have imported the metadata from salesforce itself, so it might not be the issue.

Re: tSalesForceInput Exception

Anonymous — Thu, 24 Apr 2014 06:37:28 GMT

Hi tal00000,
Its good that you are writing for talend but my problem is different and you had redirected us to some different scenario. please first look into the issue before redirecting...

Re: tSalesForceInput Exception

Anonymous — Thu, 24 Apr 2014 06:57:15 GMT

Hi Ankit,
When version of talend your are using?
>>
org.apache.axis2.AxisFault: org.apache.axis2.databinding.ADBException: Unexpected sub element {urn:enterprise.soap.sforce.com}done
This shows that issue with axis2, I think SOAP is not able to parse the data which is received from salesforce.
Can you try reading single column data which is plain integer?
Vaibhav

Re: tSalesForceInput Exception

Anonymous — Thu, 24 Apr 2014 10:13:41 GMT

Hi tal00000,
Its good that you are writing for talend but my problem is different and you had redirected us to some different scenario. please first look into the issue before redirecting...

Sorry, I posted this on the wrong thread. Sone asked about Salesforce change data capture. Not sure what happened here...
I still think you seem to be using and old SOAP version (8.0)

Re: tSalesForceInput Exception

Anonymous — Thu, 24 Apr 2014 11:36:02 GMT

Hi tal00000,
Thanks for the info but can you tell me what should i do to overcome this issue ???

Re: tSalesForceInput Exception

Anonymous — Thu, 24 Apr 2014 11:52:59 GMT

Your screenshot shows Web service "...Soap/c/8.0". Depending on your Talend version, I'd expect to see something more like "25.0".
I don't know this is your issue; but it does look odd...were did 8.0 come from?