I have created a transformation that uses a flat file source to populate two tables (OE_HEADERS_IFACE_ALL and OE_LINES_IFACE_ALL) in our Oracle ERP database. After completing the mapping I try to test the transformation and get the error message below. Using the same source I setup another transformation using two custom tables in the same database and the transformation test was successful. So the source is okay, and access to the target is fine. So not sure why this transformation is not working?
Failed to test the transformation.
Error on the server: Error: DoXmlHfMap failed
TargetPath:'ONT:OE_HEADERS_IFACE_ALL.' SourcePath:'' [CODE:10395] file: TreeMapperWriter.cpp, line 292
Client version: 3.1.0.14-enterprise-mx
Server version: 3.1.0.9-internal
Client platform: Windows 2003 - Java 1.6.0_16
Server platform: Microsoft Windows Server 2003 R2, Standard Edition, 32-bit 5.2 SP 2.0 (Service Pack 2) Build 3790
CPU: GenuineIntel x86 Intel(R) Xeon(R) CPU X5660 @ 2.80GHz - x86 Family 6 Model 26 Stepping 4, 1 cores total.
RAM: 0.7625 GB in use, 0.1074 GB available, 0.4995 GB total.
Swap: 0.1323 GB in use, 1.826 GB available, 2 GB total.
Disk (where Jitterbit is installed): 12.58 GB in use, 7.418 GB available, 19.99 GB total.
org.jitterbit.integration.client.server.IntegrationServerException: Error on the server: Error: DoXmlHfMap failed
TargetPath:'ONT:OE_HEADERS_IFACE_ALL.' SourcePath:'' [CODE:10395] file: TreeMapperWriter.cpp, line 292
at org.jitterbit.integration.client.server.webservice.WebServiceConfiguration.convertToIntegrationServerException(WebServiceConfiguration.java:276)
at org.jitterbit.integration.client.server.webservice.WebServiceServerCall.convert(WebServiceServerCall.java:51)
at org.jitterbit.integration.server.implementation.webservice.interchange.treemapper.impl.TestTransformationProviderWsImpl.testTransformation(TestTransformationProviderWsImpl.java:72)
at org.jitterbit.integration.client.ui.interchange.entity.transformation.data.TestTransformationJob.runImpl(TestTransformationJob.java:70)
at org.jitterbit.application.ui.job.UiJob$2.run(UiJob.java:516)
at org.jitterbit.application.worker.DefaultApplicationWorker$RunnableWrapper.runSafely(DefaultApplicationWorker.java:200)
at org.jitterbit.application.worker.DefaultApplicationWorker$RunnableWrapper.run(DefaultApplicationWorker.java:192)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: Error: DoXmlHfMap failed
TargetPath:'ONT:OE_HEADERS_IFACE_ALL.' SourcePath:'' [CODE:10395] file: TreeMapperWriter.cpp, line 292
at org.apache.axis.message.SOAPFaultBuilder.createFault(SOAPFaultBuilder.java:223)
at org.apache.axis.message.SOAPFaultBuilder.endElement(SOAPFaultBuilder.java:130)
at org.apache.axis.encoding.DeserializationContext.endElement(DeserializationContext.java:1087)
at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.DTDConfiguration.parse(Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at javax.xml.parsers.SAXParser.parse(Unknown Source)
at org.apache.axis.encoding.DeserializationContext.parse(DeserializationContext.java:227)
at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:695)
at org.apache.axis.Message.getSOAPEnvelope(Message.java:435)
at org.apache.axis.transport.http.HTTPSender.readFromSocket(HTTPSender.java:807)
at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:144)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.client.AxisClient.invokeTransport(AxisClient.java:150)
at org.apache.axis.client.AxisClient.invoke(AxisClient.java:289)
at org.apache.axis.client.Call.invokeEngine(Call.java:2838)
at org.apache.axis.client.Call.invoke(Call.java:2824)
at org.apache.axis.client.Call.invoke(Call.java:2501)
at org.apache.axis.client.Call.invoke(Call.java:2424)
at org.apache.axis.client.Call.invoke(Call.java:1835)
at org.jitterbit.integration.server.implementation.webservice.interchange.treemapper.client.Konga_treemapper_infoproviderSoapBindingStub.testTransformationWithWarning(Konga_treemapper_infoproviderSoapBindingStub.java:500)
at org.jitterbit.integration.server.implementation.webservice.interchange.treemapper.impl.TestTransformationProviderWsImpl.testTransformation(TestTransformationProviderWsImpl.java:63)
... 10 more

