[resolved] Error while Data Export from Oracle to SF Import

Anonymous — Sat, 16 Nov 2024 10:52:05 GMT

Talend Open Studio for Data Integration

Version: 6.1.0
Hello Commmunity,
I've created an new Job for an Upload from our Oracle Database to Salesforce.
The Database Query Contains approx. 7000 rows.
It looks like this:
But when i start the job there comes an following error on row 2000:

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
 disconnected
 disconnected
Job SF_Prod_Data_Migration_Lookup_SF_All_Companies_working_splitted_query ended at 13:16 13/01/2016.

And here is the Data Record which may produced the error:

The Record ( Salesforce-output) contains no Mandatory-Fields with an null value.

Edit: Added an more detailed error output and the record which may cause the error
May someone knows anything about these errros
Thanks
best regards fireskyer

Re: [resolved] Error while Data Export from Oracle to SF Import

Anonymous — Thu, 14 Jan 2016 10:49:45 GMT

Do i forgot something ?
Or does no one know why these error occours
best regards fireskyer

Re: [resolved] Error while Data Export from Oracle to SF Import

Anonymous — Tue, 19 Jan 2016 08:13:07 GMT

Hello Folks,
I have researched ( debug) with an Java Skilled Colleague the error.
Our mistake was to forgot to set these option for all data sources ( in our case the oracle database connections) :

best reagards fireskyer

Re: [resolved] Error while Data Export from Oracle to SF Import

Anonymous — Tue, 19 Jan 2016 09:05:08 GMT

Hi fireskyer,
Thanks for posting that you resolved it by yourself.
Best regards
Sabrina

Re: [resolved] Error while Data Export from Oracle to SF Import

Anonymous — Wed, 20 Jan 2016 11:55:32 GMT

Hello xdishi
From my point of view it's essential for an Commmunity to offer an solution if i found one
and not these bearing in my mind where they are usless for other people.
regards john

topic Re: [resolved] Error while Data Export from Oracle to SF Import in Talend Studio

[resolved] Error while Data Export from Oracle to SF Import

Re: [resolved] Error while Data Export from Oracle to SF Import

Re: [resolved] Error while Data Export from Oracle to SF Import

Re: [resolved] Error while Data Export from Oracle to SF Import

Re: [resolved] Error while Data Export from Oracle to SF Import