You need to sign in to do that
Don't have an account?
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.
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
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
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