cancel
Showing results for 
Search instead for 
Did you mean: 

File Content Conversion issue

Former Member
0 Kudos

Dear Guru's,

I am having an issue with reading the file from my source .txt file.

Here is my Sender File adapter information of the file content Conversion probelm

Source File test.txt

00000142JANE FRAGAX29.09.200930.09.2009

Document Name: MT_Customer (My Source Side Message Type Name)

Document Namespace:urn://sap.com/customer

Docuemtn Offset:

Recordset Name:Record

Recordset Namespace:

REcordset Structure: Row,*

Recordset per Message:

KeyField Name:

KeyField Type:

Conversion

Row.fieldFixedLength ===> 8,10,10,10

Row.fieldNames ===> CUSTNO,NAME,STARTDATE,ENDDATE

Row.processFieldNames ==> fromConfiguration

Getting the below error in the CC monitoring:

Conversion initialization failed: java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found: Parameter 'Row.fieldFixedLengths' or 'Row.fieldSeparator' is missing Consistency check: no. of arguments in 'Row.fieldFixedLength' does not match 'Row.fieldNames' (0 <> 😎

For this error I added Row.fieldSeparator ='nl'

Then it works fine and it is failing in the SXMB_MONI with RED flag. First Row is printing in the fist Colum like the below.

<?xml version="1.0" encoding="utf-8" ?>

- <ns:MT_Customer xmlns:ns="urn://sap.com/customer">

- <Record>

- <Row>

<CUSTNO>00000142JANE FRAGAX29.09.200930.09.2009</CUSTNO>

</Row>

</Record>

</ns:MT_Customer >

Thanks,

Jane.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

The Problem got figured out just a small mistake in the spelling.

Row.fieldFixedLength

I missed the Row.fieldFixedLengths char.

Thanks,

Jane

prateek
Active Contributor
0 Kudos

Try Row.fieldFixedLength ===> 8,11,10,10

There is an X after your name.

Regards,

Prateek

Former Member
0 Kudos

The Problem got figured out just a small mistake in the spelling.

Row.fieldFixedLength

I missed the Row.fieldFixedLengths char.

Thanks,

Jane