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

Six 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
Six 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
Six 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.
Six 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 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog