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