[resolved] Salesforce: whitespace error

Anonymous — Sat, 16 Nov 2024 11:57:39 GMT

Hi!
I'm working on a job to import data into salesforce, but I ran into an error that I just can't find the cause of. This is the error:

Exception in component tSalesforceOutput_1
org.apache.axis2.AxisFault: Invalid white space character (0x1f) 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.create(SforceServiceStub.java:6651)
	at org.talend.salesforce.SforceManagementImpl.insert(SforceManagementImpl.java:521)
	at salesforce_iadvise.loadcontactdata_0_1.LoadContactData.tFileInputDelimited_1Process(LoadContactData.java:4610)
	at salesforce_iadvise.loadcontactdata_0_1.LoadContactData.runJobInTOS(LoadContactData.java:5830)
	at salesforce_iadvise.loadcontactdata_0_1.LoadContactData.main(LoadContactData.java:5696)
Caused by: com.ctc.wstx.exc.WstxIOException: Invalid white space character (0x1f) in text to output
	at com.ctc.wstx.sw.BaseStreamWriter.writeCharacters(BaseStreamWriter.java:511)
	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)
	... 21 more
Caused by: java.io.IOException: Invalid white space character (0x1f) in text to output
	at com.ctc.wstx.sw.XmlWriter.throwInvalidChar(XmlWriter.java:545)
	at com.ctc.wstx.sw.BufferingXmlWriter.writeCharacters(BufferingXmlWriter.java:531)
	at com.ctc.wstx.sw.BaseStreamWriter.writeCharacters(BaseStreamWriter.java:509)
	... 41 more

I've checked my input file, and I can't find any special characters there, but I don't really know how to look for a character by hex-code either, so I might just have missed it.
The job is attached, it's nothing complex.

Re: [resolved] Salesforce: whitespace error

Anonymous — Thu, 25 Jul 2013 14:48:26 GMT

Nevermind, after looking up how to find the character via its hex, I managed to find the error in the file.

Re: [resolved] Salesforce: whitespace error

Anonymous — Thu, 26 Jul 2018 03:28:54 GMT

Hi, Couldn't see the solution? Please share it again if I missed it. thanks in advance

topic [resolved] Salesforce: whitespace error in Talend Studio

[resolved] Salesforce: whitespace error

Re: [resolved] Salesforce: whitespace error

Re: [resolved] Salesforce: whitespace error