Error in Converting File Content in a Sender Adapter

[Former Member]

Hi everyone.

We are using File content conversion as message protocol for a simple flat file (sender) .

In the sender communication channel we have configured the recordset structure as follows:

order_row.filedNames : orderid,item,quantity,price

order_row.filedSeparator : ,

order_row.endSeparator : 'nl'

<b>Conversion initialization failed: java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found: Parameter 'order_row.fieldFixedLengths' or 'order_row.fieldSeparator' is missing Mandatory parameter 'order_row.fieldNames': no value found </b>

In monitoring no XML messages are seen in IDX5.

What is the solution for this kind of problem.

[Shabarish_Nair · Accepted solution]

<i>order_row.filedNames : orderid,item,quantity,price

order_row.filedSeparator : ,</i>

>>>

there is a aspelling mistake. it sud be

<b>field</b> instead of filed

[Former Member · Accepted solution]

Thank you for the answer.

We have corrected that. Now we are getting the following error.

Conversion initialization failed: java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found: Format error in 'xml.recordset' argument: incomplete structure (name,number) pair.

What should be done further??

[Shabarish_Nair · Accepted solution]

you have to provide values for the recordset structure?

Below i am refering multiple blogs on Content conversion, please refer them to help you get a hand on the same.

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2

/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter - TAB delimited

/people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns

/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter

[Former Member · Accepted solution]

Thanks Shabarish.

That was really useful. We have successfully executed the scenario.

Now we are exploring all the possible options using file adapter

[Former Member]

hi durga,

you are using <b>both 'order_row.fieldFixedLengths' and 'order_row.fieldSeparator'</b>

try only one either <b>'order_row.fieldFixedLengths'</b> or <b>order_row.fieldSeparator'</b>

hope this will help

regards

HONEY

Message was edited by:

Honey Gyanani