Flat file schema issue- Unexpected data found while looking for:

[Sunil]

I am having trouble creating one input flat file. Could you please some one
help me to resolve my issues. Here is the sample layout of my records. I
have different types of records such as 10,15,20,30,40,50,60 and 70, some of
them are optional and may or may not be present and can occur more than one
too. (All these records are same length but diffent layout for each records)
And this set will repeat in my input file. Could you please help me to
generate a flat file based on this kind of data ?
One time I was getting Unexpected data found while looking for: $Delimited$
I changed my schema's default child order to Postfix/Infix and character
type hexadecimal 0x0A 0x0D and both cases I am getting " Unexpected data
found while looking for:
'\n\r'"

10aaa1111bbbccc
15bbb2222xxxxxx
203333333qqq222
25tttttttttt333
50xxxx11112222x
50www22223333yy
10aaa1111bbbccc
15bbb2222xxxxxx
203333333qqq222
25tttttttttt333
50xxxx11112222x
60www22223333yy
70sss111133333q

url:http://www.ureader.com/gp/1207-1.aspx

[Dan Rosanova]

Hello,
This is basically the only message the Flat File Disassembler gives
you and I'm affraid it's not always the best. It looks to me what you
want to do is define the schema to be Delimited, then define repeating
records inside of it (each with a Tag Identifier). Then go and define
each of these records themselves as Positional. Be sure to include
their Tag Identifier so BizTalk can find them.

Here's a good walk through article: http://www.winterdom.com/dev/bts/BTSFFSchemaTut2.html

The Flat File stuff can be hard to get into in BizTalk, but once you
do you'll never write code to do it again and it's easy, fast, and
powerful.

Kind Regards,
-Dan

[WenJun Zhang[msft]]

Hi,

Dan's susggestion just addressed the problem. If you still cannot figure
out the problem and the error persists, feel free to send a copy of your
problematic schema and expected input file to me at:
wjz...@online.microsoft.com (please remove online.) I will look into it
and help on turning up where the problem is.

Have a nice day.

Sincerely,

WenJun Zhang

Microsoft Online Community Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
msd...@microsoft.com.

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://support.microsoft.com/select/default.aspx?target=assistance&ln=en-us.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

[WenJun Zhang[msft]]

Hi,

Just wonder if you still have any further question for this issue?

Thanks.

[brucebullock]

I encounter the same error, but my data does not have the benefit of record tags. The data is positional, fixed length records of 1020 bytes. Here is the beginning of the schema.

<?xml version="1.0" encoding="utf-16"?>
<xs:schema xmlns:b="http://schemas.microsoft.com/BizTalk/2003" xmlns="http://Mycorp.BizTalk.Myapp.Schemas.MySchema" elementFormDefault="qualified" targetNamespace="http://Mycorp.BizTalk.Myapp.Schemas.MySchema" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:annotation>
<xs:appinfo>
<b:schemaInfo count_positions_by_byte="false" parser_optimization="complexity" lookahead_depth="0" suppress_empty_nodes="false" generate_empty_nodes="true" allow_early_termination="true" standard="Flat File" root_reference="MySchema" default_pad_char=" " pad_char_type="char" early_terminate_optional_fields="true" allow_message_breakup_of_infix_root="false" compile_parse_tables="false" />
<schemaEditorExtension:schemaInfo namespaceAlias="b" extensionClass="Microsoft.BizTalk.FlatFileExtension.FlatFileExtension" standardName="Flat File" xmlns:schemaEditorExtension="http://schemas.microsoft.com/BizTalk/2003/SchemaEditorExtensions" />
</xs:appinfo>
</xs:annotation>
<xs:element name="MySchema">
<xs:annotation>
<xs:appinfo>
<b:recordInfo structure="delimited" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" sequence_number="1" child_order="postfix" child_delimiter_type="hex" child_delimiter="0x0D 0x0A" />
</xs:appinfo>
</xs:annotation>
<xs:complexType>
<xs:sequence>
<xs:annotation>
<xs:appinfo>
<b:groupInfo sequence_number="0" />
</xs:appinfo>
</xs:annotation>
<xs:element maxOccurs="unbounded" name="Records">
<xs:annotation>
<xs:appinfo>
<b:recordInfo sequence_number="1" structure="delimited" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" child_delimiter_type="hex" child_delimiter="0x0D 0x0A" child_order="infix" />
</xs:appinfo>
</xs:annotation>
<xs:complexType>
<xs:sequence>
<xs:annotation>
<xs:appinfo>
<b:groupInfo sequence_number="0" />
</xs:appinfo>
</xs:annotation>
<xs:element name="FirstPart">
<xs:annotation>
<xs:appinfo>
<b:recordInfo structure="positional" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" sequence_number="1" />
</xs:appinfo>
</xs:annotation>
...

wjzhan wrote:

Hi,Just wonder if you still have any further question for this issue?
13-Oct-08

Hi,

Thanks.

Sincerely,

WenJun Zhang

Microsoft Online Community Support

Previous Posts In This Thread:

On Wednesday, October 08, 2008 10:38 AM
Sunil wrote:

Flat file schema issue- Unexpected data found while looking for:

url:http://www.ureader.com/gp/1207-1.aspx

On Thursday, October 09, 2008 12:11 AM
Dan Rosanova wrote:

Hello,This is basically the only message the Flat File Disassembler givesyou

Kind Regards,
-Dan

On Thursday, October 09, 2008 6:23 AM
wjzhan wrote:

Hi,Dan's susggestion just addressed the problem.
Hi,

Dan's susggestion just addressed the problem. If you still cannot figure
out the problem and the error persists, feel free to send a copy of your
problematic schema and expected input file to me at:
wjz...@online.microsoft.com (please remove online.) I will look into it
and help on turning up where the problem is.

Have a nice day.

Sincerely,

WenJun Zhang

Microsoft Online Community Support

On Monday, October 13, 2008 11:19 PM
wjzhan wrote:

Hi,Just wonder if you still have any further question for this issue?
Hi,

Thanks.

Sincerely,

WenJun Zhang

Microsoft Online Community Support

EggHeadCafe - Software Developer Portal of Choice
Aelita ERDisk for Active Directory
http://www.eggheadcafe.com/tutorials/aspnet/fe3106a9-0b0d-48c0-a37a-fd9e59e1b14e/aelita-erdisk-for-active.aspx