tSugarCRMInput_1 and tSugarCRMOutput_1 Error on Job Run

[Anonymous]

Having issues setting up a tSugarCRMInput_1 and tSugarCRMOutput_1. With both components I can pull the table structure and automap the fields just fine. But when I run the job I get this error:

[statistics] connecting to socket on port 3447
[statistics] connected
[ERROR]: org.apache.axis.client.Call - Exception:
org.xml.sax.SAXException: Bad types (class org.talend.sugarws.Entry_value -> class org.talend.sugarws.Set_entry_result)
	at org.apache.axis.message.RPCHandler.onStartChild(RPCHandler.java:286)
	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.login(SugarsoapBindingStub.java:1203)
	at org.talend.SugarManagement.SugarManagementImpl.login(SugarManagementImpl.java:79)
	at sugarcrm.sugartocsv_0_1.SugarTOcsv.tSugarCRMInput_1Process(SugarTOcsv.java:1580)
	at sugarcrm.sugartocsv_0_1.SugarTOcsv.runJobInTOS(SugarTOcsv.java:3862)
	at sugarcrm.sugartocsv_0_1.SugarTOcsv.main(SugarTOcsv.java:3711)
Exception in component tSugarCRMInput_1 (SugarTOcsv)
AxisFault
 faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException
 faultSubcode: 
 faultString: org.xml.sax.SAXException: Bad types (class org.talend.sugarws.Entry_value -> class org.talend.sugarws.Set_entry_result)
 faultActor: 
 faultNode: 
 faultDetail: 
	{http://xml.apache.org/axis/}stackTrace:org.xml.sax.SAXException: Bad types (class org.talend.sugarws.Entry_value -> class org.talend.sugarws.Set_entry_result)
	at org.apache.axis.message.RPCHandler.onStartChild(RPCHandler.java:286)
	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.login(SugarsoapBindingStub.java:1203)
	at org.talend.SugarManagement.SugarManagementImpl.login(SugarManagementImpl.java:79)
	at sugarcrm.sugartocsv_0_1.SugarTOcsv.tSugarCRMInput_1Process(SugarTOcsv.java:1580)
	at sugarcrm.sugartocsv_0_1.SugarTOcsv.runJobInTOS(SugarTOcsv.java:3862)
	at sugarcrm.sugartocsv_0_1.SugarTOcsv.main(SugarTOcsv.java:3711)

	{http://xml.apache.org/axis/}hostname:SOTH-PC24

org.xml.sax.SAXException: Bad types (class org.talend.sugarws.Entry_value -> class org.talend.sugarws.Set_entry_result)
	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.login(SugarsoapBindingStub.java:1203)
	at org.talend.SugarManagement.SugarManagementImpl.login(SugarManagementImpl.java:79)
	at sugarcrm.sugartocsv_0_1.SugarTOcsv.tSugarCRMInput_1Process(SugarTOcsv.java:1580)
	at sugarcrm.sugartocsv_0_1.SugarTOcsv.runJobInTOS(SugarTOcsv.java:3862)
	at sugarcrm.sugartocsv_0_1.SugarTOcsv.main(SugarTOcsv.java:3711)
Caused by: org.xml.sax.SAXException: Bad types (class org.talend.sugarws.Entry_value -> class org.talend.sugarws.Set_entry_result)
	at org.apache.axis.message.RPCHandler.onStartChild(RPCHandler.java:286)
	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
[statistics] disconnected

Job SugarTOcsv ended at 13:14 27/11/2018. [exit code=1]

I am unsure why I am getting this connection error when I can connect to both sources to pull the fields just fine. Can someone point me in the right direction?

-Mark

[Anonymous]

Hi Mark,

     The error says bad types. So could you please double check the schema you have created with underlying SugarCRM schema to make sure that the number of elements, type of elements, URL etc. are correct?

Warm Regards,

Nikhil Thampi

[Anonymous]

Checked the schema and I feel it should be right.

[Anonymous]

Hi,

   Ideally yes but we might be missing some minor type casting.

   What about the last column with INT data type? Is it a nullable column? If not, it might be expecting an integer value. Similarly could you please check the boolean value whether it is getting auto converted to tiny int?

Warm Regards,

Nikhil Thampi