This discussion is archived
5 Replies Latest reply: Mar 5, 2013 2:48 PM by vladodias RSS

'Write' failed due to: Translation Error.

akdasari Newbie
Currently Being Moderated
I'm trying to convert csv and write to a file using FielAdapters in 11g. While reading input i created .xsd using native builder. and using same for write fileadapter. my flow is ReadFileAdapter-->Receive-->invoke-->writeFileAdapter.
Is this right? when I deploy and run I'm getting

<01-Mar-2013 10:09:23 o'clock GMT> <Error> <oracle.soa.adapter> <BEA-000000> <JCABinding=> ReadInput ReadInputAdapter Service ReadInput was unable to perform delivery of inbound message to the composite default/ReadWriteFile!1.0*soa_40862c80-62ba-4425-b7e6-5fcfb5c5b4e4 due to: faultName: {{}bindingFault}
messageType: {{}RuntimeFaultMessage}
parts: {{
summary=<summary>Exception occured when binding was invoked.
Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'Write' failed due to: Translation Error.
Translation Error.
Error while translating message to native format.
Please make sure that the payload for the outbound interaction conforms to the schema.
The invoked JCA adapter raised a resource exception.
Please examine the above error message carefully to determine a resolution.
,detail=<detail>Element not completed: 'TestRoot'</detail>

I want to convert csv and write as an xml to output file. can some body help me whats is wrong?

here is my xsd

<xsd:schema xmlns:xsd=""


<xsd:element name="TestRoot">
<xsd:element name="TestRecord" minOccurs="1" maxOccurs="unbounded">
<xsd:element name="C1" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="," />
<xsd:element name="C2" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="," />
<xsd:element name="C3" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="," />
<xsd:element name="C4" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}" />


and csv file
12, John, ryegate, Essex
23, Will, wilow, orlean

I also tried inbuild advane function on invoke activity

even this didn't work.

can somebody help me how to write as xml from csv?

Edited by: user11132693 on Mar 1, 2013 3:01 AM


  • Correct Answers - 10 points
  • Helpful Answers - 5 points