function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
john s.john s. 

java Error in Talend: org.apache.axis2.AxisFault: Invalid null character in text to output

SF-Edition: Prof.
Packages: Worfklow and API

Hello Community

We try to Import our ERP Data Records to Salesforce   with the Help of the ETL Tool Talend.

But when i try to start the Job, there come the following error on the 2000 Record.
 
Exception in component tSalesforceOutput_1
org.apache.axis2.AxisFault: Invalid null character in text to output
	at org.apache.axis2.AxisFault.makeFault(AxisFault.java:430)
	at org.apache.axis2.transport.http.SOAPMessageFormatter.writeTo(SOAPMessageFormatter.java:78)
	at org.apache.axis2.transport.http.AxisRequestEntity.writeRequest(AxisRequestEntity.java:84)
	at org.apache.commons.httpclient.methods.EntityEnclosingMethod.writeRequestBody(EntityEnclosingMethod.java:499)
	at org.apache.commons.httpclient.HttpMethodBase.writeRequest(HttpMethodBase.java:2114)
	at org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.java:1096)
	at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:398)
	at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171)
	at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397)
	at org.apache.axis2.transport.http.AbstractHTTPSender.executeMethod(AbstractHTTPSender.java:621)
	at org.apache.axis2.transport.http.HTTPSender.sendViaPost(HTTPSender.java:193)
	at org.apache.axis2.transport.http.HTTPSender.send(HTTPSender.java:75)
	at org.apache.axis2.transport.http.CommonsHTTPTransportSender.writeMessageWithCommons(CommonsHTTPTransportSender.java:404)
	at org.apache.axis2.transport.http.CommonsHTTPTransportSender.invoke(CommonsHTTPTransportSender.java:231)
	at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:443)
	at org.apache.axis2.description.OutInAxisOperationClient.send(OutInAxisOperation.java:406)
	at org.apache.axis2.description.OutInAxisOperationClient.executeImpl(OutInAxisOperation.java:229)
	at org.apache.axis2.client.OperationClient.execute(OperationClient.java:165)
	at com.salesforce.soap.partner.SforceServiceStub.upsert(SforceServiceStub.java:19013)
	at org.talend.salesforce.SforceConnection.upsert(SforceConnection.java:110)
	at org.talend.salesforce.SforceManagementImpl.upsert(SforceManagementImpl.java:462)
	at sf_csv.sf_prod_data_migration_lookup_sf_all_companies_working_splitted_query_0_1.SF_Prod_Data_Migration_Lookup_SF_All_Companies_working_splitted_query.tOracleInput_1Process(SF_Prod_Data_Migration_Lookup_SF_All_Companies_working_splitted_query.java:4382)
	at sf_csv.sf_prod_data_migration_lookup_sf_all_companies_working_splitted_query_0_1.SF_Prod_Data_Migration_Lookup_SF_All_Companies_working_splitted_query.runJobInTOS(SF_Prod_Data_Migration_Lookup_SF_All_Companies_working_splitted_query.java:6312)
	at sf_csv.sf_prod_data_migration_lookup_sf_all_companies_working_splitted_query_0_1.SF_Prod_Data_Migration_Lookup_SF_All_Companies_working_splitted_query.main(SF_Prod_Data_Migration_Lookup_SF_All_Companies_working_splitted_query.java:6150)
Caused by: com.ctc.wstx.exc.WstxIOException: Invalid null character in text to output
	at com.ctc.wstx.sw.BaseStreamWriter.writeCharacters(BaseStreamWriter.java:467)
	at org.apache.axiom.util.stax.wrapper.XMLStreamWriterWrapper.writeCharacters(XMLStreamWriterWrapper.java:100)
	at org.apache.axiom.om.impl.MTOMXMLStreamWriter.writeCharacters(MTOMXMLStreamWriter.java:325)
	at org.apache.axiom.om.impl.llom.OMTextImpl.writeOutput(OMTextImpl.java:249)
	at org.apache.axiom.om.impl.llom.OMTextImpl.internalSerialize(OMTextImpl.java:400)
	at org.apache.axiom.om.impl.util.OMSerializerUtil.serializeChildren(OMSerializerUtil.java:556)
	at org.apache.axiom.om.impl.llom.OMElementImpl.internalSerialize(OMElementImpl.java:846)
	at org.apache.axiom.om.impl.llom.OMSerializableImpl.serialize(OMSerializableImpl.java:120)
	at org.apache.axiom.om.impl.llom.OMSerializableImpl.serialize(OMSerializableImpl.java:108)
	at com.salesforce.soap.partner.sobject.SObject.serialize(SObject.java:311)
	at com.salesforce.soap.partner.sobject.SObject.serialize(SObject.java:218)
	at com.salesforce.soap.partner.Upsert.serialize(Upsert.java:169)
	at com.salesforce.soap.partner.Upsert.serialize(Upsert.java:126)
	at org.apache.axis2.databinding.ADBDataSource.serialize(ADBDataSource.java:90)
	at org.apache.axiom.om.impl.llom.OMSourcedElementImpl.internalSerialize(OMSourcedElementImpl.java:638)
	at org.apache.axiom.om.impl.util.OMSerializerUtil.serializeChildren(OMSerializerUtil.java:563)
	at org.apache.axiom.om.impl.llom.OMElementImpl.internalSerialize(OMElementImpl.java:846)
	at org.apache.axiom.soap.impl.llom.SOAPEnvelopeImpl.serializeInternally(SOAPEnvelopeImpl.java:267)
	at org.apache.axiom.soap.impl.llom.SOAPEnvelopeImpl.internalSerialize(SOAPEnvelopeImpl.java:229)
	at org.apache.axiom.om.impl.llom.OMSerializableImpl.serializeAndConsume(OMSerializableImpl.java:188)
	at org.apache.axis2.transport.http.SOAPMessageFormatter.writeTo(SOAPMessageFormatter.java:74)
	... 22 more
Caused by: java.io.IOException: Invalid null character in text to output
	at com.ctc.wstx.api.InvalidCharHandler$FailingHandler.convertInvalidChar(InvalidCharHandler.java:51)
	at com.ctc.wstx.sw.XmlWriter.handleInvalidChar(XmlWriter.java:629)
	at com.ctc.wstx.sw.BufferingXmlWriter.writeCharacters(BufferingXmlWriter.java:497)
	at com.ctc.wstx.sw.BaseStreamWriter.writeCharacters(BaseStreamWriter.java:465)
	... 42 more
[statistics] disconnected
[trace] disconnected
Job SF_Prod_Data_Migration_Lookup_SF_All_Companies_working_splitted_query ended at 13:16 13/01/2016. [exit code=1]
I'm not sure but i think the reason is on the SF side and not one the Talend one ... otherwise correct me if I'm wrong 

So does anyone has an clue or an idea where i have to start to resolve my problem  ?

Thanks in advance for any help 

regards john