Skip to Content
0
Jul 21, 2016 at 06:47 PM

Fixed Length Flat File to XML issue.

194 Views

Hi All,

We are using the below structure for extracting Header and Line Items. The file should ideally come as

File Header

Document Header

Line Item

Document Header

Line Item

Line Item

Document Header

Line Item

File Trailer

Our structure is

<MT_Message> 1..1

<RecordSet> 1..1

<FieldHeader> 1..1

<DocumentHeader> 0..n

<LineItem> 0..n

<Trailer> 1..1

We are using SAP SFTP Adapter and using MTB.

When we are getting the file as 1 fileheader 1 document header 1 or many line items and 1 trailer we are able pick the file

However when we get the file as 1 fileheader 1st document header 1 or many line items 2nd document header 1 line item 1 trailer. The message throws error in the

channel as Error Consistency Check in recordset structure validation. And it gives a line number which always belongs to the 2nd set of Document Header.

We have verified that the data is correct by running each pair of Document Header and single or Multiple LineItems but the issue happens when a multiple set of Document Header and Line Items occur.

What are we missing here that we are unable to read the second set starting from Document Header .

Thanks,

Shaibayan