topic Re: Crazy tSugarCRMInput Exception in Talend Studio

Crazy tSugarCRMInput Exception

_AnonymousUser — Sat, 16 Nov 2024 14:05:49 GMT

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. 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.encod

To see the whole post, download it here

Re: Crazy tSugarCRMInput Exception

_AnonymousUser — Fri, 20 Feb 2009 16:18:36 GMT

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

Re: Crazy tSugarCRMInput Exception

_AnonymousUser — Fri, 20 Feb 2009 16:26:36 GMT

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 !

Re: Crazy tSugarCRMInput Exception

_AnonymousUser — Thu, 05 Mar 2009 07:37:35 GMT

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.