Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

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

To see the whole post, download it here
Labels (5)
3 Replies
_AnonymousUser
Specialist III
Specialist III
Author

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
_AnonymousUser
Specialist III
Specialist III
Author

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 !
_AnonymousUser
Specialist III
Specialist III
Author

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.