Crazy tSugarCRMInput Exception

One Star

Crazy tSugarCRMInput Exception

I get the below exceptions when running tSugarCRMInput. I verified the user name, password, web url to make sure they are all correct. Both exceptions happen on with module selected from the drop down. I also experience with the latest version of JasperETL.
Funny thing is that it works fine until you modify the "Query Condition". But of course "name='Talend'" does you no good. Smiley Happy I also get another funny error when I specify "Query Condition" This has been tried ageist two development SugarCRM servers.
Java Version: 5 and 6
Studio Version: 3.0.3.r20205
SugarCRM Version: 5.1 OS and 5.2 OS
-----First Error Message with no Query Condition -----------
Starting job Test at 17:45 20/01/2009.
Jan 20, 2009 5:45:10 PM org.apache.axis.client.Call invoke
SEVERE: Exception:
org.xml.sax.SAXException: Invalid element in org.talend.sugarws.Field - default_value
at org.apache.axis.encoding.ser.BeanDeserializer.onStartChild(BeanDeserializer.java:258)
at org.apache.axis.encoding.DeserializationContext.startElement(DeserializationContext.java:1035)
at org.apache.axis.message.SAX2EventRecorder.replay(SAX2EventRecorder.java:165)
at org.apache.axis.message.MessageElement.publishToHandler(MessageElement.java:1141)
at org.apache.axis.message.RPCElement.deserialize(RPCElement.java:236)
at org.apache.axis.message.RPCElement.getParams(RPCElement.java:384)
at org.apache.axis.client.Call.invoke(Call.java:2467)
at org.apache.axis.client.Call.invoke(Call.java:2366)
at org.apache.axis.client.Call.invoke(Call.java:1812)
at org.talend.sugarws.SugarsoapBindingStub.get_entry_list(SugarsoapBindingStub.java:1865)
at org.talend.SugarManagement.SugarManagementImpl.getRecordswithQuery(SugarManagementImpl.java:110)
at lead_to_sugarcrm.test_0_1.Test.tSugarCRMInput_1Process(Test.java:1735)
at lead_to_sugarcrm.test_0_1.Test.runJobInTOS(Test.java:2711)
at lead_to_sugarcrm.test_0_1.Test.main(Test.java:2613)
Exception in component tSugarCRMInput_1
AxisFault
faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException
faultSubcode:
faultString: org.xml.sax.SAXException: Invalid element in org.talend.sugarws.Field - default_value
faultActor:
faultNode:
faultDetail:
{http://xml.apache.org/axis/}stackTraceSmiley Surprisedrg.xml.sax.SAXException: Invalid element in org.talend.sugarws.Field - default_value
at org.apache.axis.encoding.ser.BeanDeserializer.onStartChild(BeanDeserializer.java:258)
at org.apache.axis.encoding.DeserializationContext.startElement(DeserializationContext.java:1035)
at org.apache.axis.message.SAX2EventRecorder.replay(SAX2EventRecorder.java:165)
at org.apache.axis.message.MessageElement.publishToHandler(MessageElement.java:1141)
at org.apache.axis.message.RPCElement.deserialize(RPCElement.java:236)
at org.apache.axis.message.RPCElement.getParams(RPCElement.java:384)
at org.apache.axis.client.Call.invoke(Call.java:2467)
at org.apache.axis.client.Call.invoke(Call.java:2366)
at org.apache.axis.client.Call.invoke(Call.java:1812)
at org.talend.sugarws.SugarsoapBindingStub.get_entry_list(SugarsoapBindingStub.java:1865)
at org.talend.SugarManagement.SugarManagementImpl.getRecordswithQuery(SugarManagementImpl.java:110)
at lead_to_sugarcrm.test_0_1.Test.tSugarCRMInput_1Process(Test.java:1735)
at lead_to_sugarcrm.test_0_1.Test.runJobInTOS(Test.java:2711)
at lead_to_sugarcrm.test_0_1.Test.main(Test.java:2613)
{http://xml.apache.org/axis/}hostname:admin
org.xml.sax.SAXException: Invalid element in org.talend.sugarws.Field - default_value
at org.apache.axis.AxisFault.makeFault(AxisFault.java:101)
at org.apache.axis.client.Call.invoke(Call.java:2470)
at org.apache.axis.client.Call.invoke(Call.java:2366)
at org.apache.axis.client.Call.invoke(Call.java:1812)
at org.talend.sugarws.SugarsoapBindingStub.get_entry_list(SugarsoapBindingStub.java:1865)
at org.talend.SugarManagement.SugarManagementImpl.getRecordswithQuery(SugarManagementImpl.java:110)
at lead_to_sugarcrm.test_0_1.Test.tSugarCRMInput_1Process(Test.java:1735)
at lead_to_sugarcrm.test_0_1.Test.runJobInTOS(Test.java:2711)
at lead_to_sugarcrm.test_0_1.Test.main(Test.java:2613)
Caused by: org.xml.sax.SAXException: Invalid element in org.talend.sugarws.Field - default_value
at org.apache.axis.encoding.ser.BeanDeserializer.onStartChild(BeanDeserializer.java:258)
at org.apache.axis.encoding.DeserializationContext.startElement(DeserializationContext.java:1035)
at org.apache.axis.message.SAX2EventRecorder.replay(SAX2EventRecorder.java:165)
at org.apache.axis.message.MessageElement.publishToHandler(MessageElement.java:1141)
at org.apache.axis.message.RPCElement.deserialize(RPCElement.java:236)
at org.apache.axis.message.RPCElement.getParams(RPCElement.java:384)
at org.apache.axis.client.Call.invoke(Call.java:2467)
... 7 more
Job Test ended at 17:45 20/01/2009.
-----End First Error Message with no Query Condition -----------
-----Second Error Message with Query Condition set to "" -----------
Starting job Test at 17:53 20/01/2009.
Jan 20, 2009 5:54:12 PM org.apache.axis.client.Call invoke
SEVERE: Exception:
org.xml.sax.SAXException: Invalid element in org.talend.sugarws.Field - default_value
at org.apache.axis.encoding.ser.BeanDeserializer.onStartChild(BeanDeserializer.java:258)
at org.apache.axis.encoding.DeserializationContext.startElement(DeserializationContext.java:1035)
at org.apache.axis.message.SAX2EventRecorder.replay(SAX2EventRecorder.java:165)
at org.apache.axis.message.MessageElement.publishToHandler(MessageElement.java:1141)
at org.apache.axis.message.RPCElement.deserialize(RPCElement.java:236)
at org.apache.axis.message.RPCElement.getParams(RPCElement.java:384)
at org.apache.axis.client.Call.invoke(Call.java:2467)
at org.apache.axis.client.Call.invoke(Call.java:2366)
at org.apache.axis.client.Call.invoke(Call.java:1812)
at org.talend.sugarws.SugarsoapBindingStub.get_entry_list(SugarsoapBindingStub.java:1865)
at org.talend.SugarManagement.SugarManagementImpl.getRecordswithQuery(SugarManagementImpl.java:110)
at lead_to_sugarcrm.test_0_1.Test.tSugarCRMInput_1Process(Test.java:2262)
at lead_to_sugarcrm.test_0_1.Test.runJobInTOS(Test.java:3508)
at lead_to_sugarcrm.test_0_1.Test.main(Test.java:3410)
Exception in component tSugarCRMInput_1
AxisFault
faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException
faultSubcode:
faultString: org.xml.sax.SAXException: Invalid element in org.talend.sugarws.Field - default_value
faultActor:
faultNode:
faultDetail:
{http://xml.apache.org/axis/}stackTraceSmiley Surprisedrg.xml.sax.SAXException: Invalid element in org.talend.sugarws.Field - default_value
at org.apache.axis.encoding.ser.BeanDeserializer.onStartChild(BeanDeserializer.java:258)
at org.apache.axis.encoding.DeserializationContext.startElement(DeserializationContext.java:1035)
at org.apache.axis.message.SAX2EventRecorder.replay(SAX2EventRecorder.java:165)
at org.apache.axis.message.MessageElement.publishToHandler(MessageElement.java:1141)
at org.apache.axis.message.RPCElement.deserialize(RPCElement.java:236)
at org.apache.axis.message.RPCElement.getParams(RPCElement.java:384)
at org.apache.axis.client.Call.invoke(Call.java:2467)
at org.apache.axis.client.Call.invoke(Call.java:2366)
at org.apache.axis.client.Call.invoke(Call.java:1812)
at org.talend.sugarws.SugarsoapBindingStub.get_entry_list(SugarsoapBindingStub.java:1865)
at org.talend.SugarManagement.SugarManagementImpl.getRecordswithQuery(SugarManagementImpl.java:110)
at lead_to_sugarcrm.test_0_1.Test.tSugarCRMInput_1Process(Test.java:2262)
at lead_to_sugarcrm.test_0_1.Test.runJobInTOS(Test.java:3508)
at lead_to_sugarcrm.test_0_1.Test.main(Test.java:3410)
{http://xml.apache.org/axis/}hostname:admin
org.xml.sax.SAXException: Invalid element in org.talend.sugarws.Field - default_value
at org.apache.axis.AxisFault.makeFault(AxisFault.java:101)
at org.apache.axis.client.Call.invoke(Call.java:2470)
at org.apache.axis.client.Call.invoke(Call.java:2366)
at org.apache.axis.client.Call.invoke(Call.java:1812)
at org.talend.sugarws.SugarsoapBindingStub.get_entry_list(SugarsoapBindingStub.java:1865)
at org.talend.SugarManagement.SugarManagementImpl.getRecordswithQuery(SugarManagementImpl.java:110)
at lead_to_sugarcrm.test_0_1.Test.tSugarCRMInput_1Process(Test.java:2262)
at lead_to_sugarcrm.test_0_1.Test.runJobInTOS(Test.java:3508)
at lead_to_sugarcrm.test_0_1.Test.main(Test.java:3410)
Caused by: org.xml.sax.SAXException: Invalid element in org.talend.sugarws.Field - default_value
at org.apache.axis.encoding.ser.BeanDeserializer.onStartChild(BeanDeserializer.java:258)
at org.apache.axis.encoding.DeserializationContext.startElement(DeserializationContext.java:1035)
at org.apache.axis.message.SAX2EventRecorder.replay(SAX2EventRecorder.java:165)
at org.apache.axis.message.MessageElement.publishToHandler(MessageElement.java:1141)
at org.apache.axis.message.RPCElement.deserialize(RPCElement.java:236)
at org.apache.axis.message.RPCElement.getParams(RPCElement.java:384)
at org.apache.axis.client.Call.invoke(Call.java:2467)
... 7 more
Job Test ended at 17:54 20/01/2009.
Highlighted
One Star

Re: Crazy tSugarCRMInput Exception

Hi Aaron
I 've got the same problem with the latest version of Talend. The connection with sugarCRM seems to be OK, the web service works perfectly but if I don't write something like "name='John'" as query condition I have the same error.
Did you find any solution since this message ?
Thanks
One Star

Re: Crazy tSugarCRMInput Exception

One more thing, I tried to the same operation on an empty table of sugarCRM. In this case no problem happens: I suppose that Talend doesn't try to execute any "Query Condition" in this case". But once again this is not very useful !
One Star

Re: Crazy tSugarCRMInput Exception

This problem seems to relate to the fact that SugarCRM 5 has an incompatible change to the SOAP interface that includes a default_value Field object (see https://www.sugarforge.org/forum/message.php?msg_id=17975)
Can Talend address this problem on their connector? I know the Funambol connector realeased a version that fixed it...
Thanks! Hope this helps someone.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.