tSugarCRMInput_1 and tSugarCRMOutput_1 Error on Job Run

Anonymous — Fri, 30 Nov 2018 15:52:34 GMT

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 -&gt; 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 -&gt; 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

Re: tSugarCRMInput_1 and tSugarCRMOutput_1 Error on Job Run

Anonymous — Mon, 03 Dec 2018 03:57:31 GMT

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

Re: tSugarCRMInput_1 and tSugarCRMOutput_1 Error on Job Run

Anonymous — Mon, 03 Dec 2018 17:34:10 GMT

Checked the schema and I feel it should be right.

Re: tSugarCRMInput_1 and tSugarCRMOutput_1 Error on Job Run

Anonymous — Tue, 04 Dec 2018 05:21:31 GMT

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

topic Re: tSugarCRMInput_1 and tSugarCRMOutput_1 Error on Job Run in Talend Studio

tSugarCRMInput_1 and tSugarCRMOutput_1 Error on Job Run

Re: tSugarCRMInput_1 and tSugarCRMOutput_1 Error on Job Run

Re: tSugarCRMInput_1 and tSugarCRMOutput_1 Error on Job Run

Re: tSugarCRMInput_1 and tSugarCRMOutput_1 Error on Job Run