Re: Pipeline error with Flat File Disassembler and Optional XSD attributes

Massimo Lisignoli — Mon, 22 Jun 2009 14:09:28 GMT

I found a solution adding the Optional attribute, set the Use Requirement property to Optional, then at the schema level I set this properties:

Allow Early Termination = yes

Early Terminate Option Field = yes

Parser Optimization = Complexity

Here the article where I found the solution: http://blog.solidsoft.com/blogs/russells_blog/archive/2006/06/15/39.aspx

Hope this helps!

Pipeline error with Flat File Disassembler and Optional XSD attributes

Massimo Lisignoli — Mon, 22 Jun 2009 09:05:55 GMT

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

BizTalk 2006 R2

Re: Pipeline error with Flat File Disassembler and Optional XSD attributes

Pipeline error with Flat File Disassembler and Optional XSD attributes