Pipeline error with Flat File Disassembler and Optional XSD attributes

Massimo Lisignoli posted on Mon, Jun 22 2009 4:05 AM

rated by 0 users

Hi All,

I have created an xsd shema with Flat File Schema Wizard, starting from a flat file.

This flat files comes from a BackOffice styem and I have noticed a change in the flat file structure:

from specs, there is a header line, some lines containing data and a trailer line. The header lenght is 23, but it is possible that a flalt file can be created with some other chars at the end of the header line, so the lenght is not 23, but could be more and I can't know the size.

So I added an attribute, called Optional with pos_lenght set to 50 and added the "use" attibute set to "Optional".

I send the flat file with the "alternative schema" but the pipeline gives me an error, despite the attribute is optional.

Error before adding Optional attribute:

Exception - There was a failure executing pipeline "pipeline_name". Error details: "Unexpected data found while looking for:
'\r\n'
The current definition being parsed is Header. The stream offset where the error occured is 23. The line number where the error occured is 1. The column where the error occured is 23.".

Error with Optional attribute:

Exception - There was a failure executing pipeline "pipeline_name". Error details: "Unexpected data found while looking for:
'\r\n'
The current definition being parsed is Header. The stream offset where the error occured is 73. The line number where the error occured is 2. The column where the error occured is 42.".

Someone have an idea in order to support this scenario?

Thanks in advice.

Massimo