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
Lukas R.Lukas R. 

Data Import - Invalid white space character

Hi,
Im trying to import contacts using Talend ETL, but Im receiving error (see below). Im no coder or advanced user either so I dont know what it means and I would appreciate if you talk to me like if you were explaining to small child :) The import starts and seems to be running fine, some contacts get imported until one point where this error ocurres and job stops. See the job at the bottom.
Exception in component tSalesforceOutput_1
org.apache.axis2.AxisFault: Invalid white space character (0xe) in text to output (in xml 1.1, could output as a character entity)
	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)
[statistics] disconnected
	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.create(SforceServiceStub.java:7496)
	at org.talend.salesforce.SforceConnection.create(SforceConnection.java:84)
	at org.talend.salesforce.SforceManagementImpl.insert(SforceManagementImpl.java:344)
	at campersf.industrycontact_0_1.IndustryContact.tFileInputExcel_1Process(IndustryContact.java:4934)
	at campersf.industrycontact_0_1.IndustryContact.runJobInTOS(IndustryContact.java:8226)
	at campersf.industrycontact_0_1.IndustryContact.main(IndustryContact.java:8083)
Caused by: com.ctc.wstx.exc.WstxIOException: Invalid white space character (0xe) in text to output (in xml 1.1, could output as a character entity)
	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.Create.serialize(Create.java:127)
	at com.salesforce.soap.partner.Create.serialize(Create.java:100)
	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 white space character (0xe) in text to output (in xml 1.1, could output as a character entity)
	at com.ctc.wstx.api.InvalidCharHandler$FailingHandler.convertInvalidChar(InvalidCharHandler.java:55)
	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

The import job is composed of 4 components. The input xls file contains list of names and account Id (external), accounts have been already loaded. In tMap component Im matching account Id from the staff list with external account Id on Account object already loaded into salesforce in Accounts. Many thanks for help
TalendJob
SandhyaSandhya (Salesforce Developers) 
Hi Lukas,

Usually, this errors occurs when you have the white space character in your file.

Try to find that space in a file.

Please refer below link you can get more information.
https://www.talendforge.org/forum/viewtopic.php?id=30837

 Hope this helps you!

Thanks and Regards
Sandhya
Lukas R.Lukas R.
Thank you Sandhya, I was guessing so.. but my point is how can I find it? or how to narrow the search? I have huge spreadsheet and the error doesnt say where it is found.. if it said which row, it would be perfect. But even if I uncheck the "Die on Error" checkbox in Job setting and want to generate the log file.. the job dies anyway.