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

Five Stars

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

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
Five Stars

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

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

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

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 
Moderator

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

Hi fireskyer,
Thanks for posting that you resolved it by yourself.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

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

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