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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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.