Flat File parsing error 80131940

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Flat File parsing error 80131940 › Flat File parsing error 80131940

October 4, 2005 at 5:31 PM #12021
community-content

    Here is the schema, flat file, and command script to test it.

    Any help is greatly appreciated.

    Schema \”80131940.xsd\”
    [code:1:85c9b9bcb0]
    <?xml version=\"1.0\" encoding=\"utf-16\"?>
    <xs:schema xmlns=\"http://TimeLoad_TimeLoad\" xmlns:b=\"http://schemas.microsoft.com/BizTalk/2003\" xmlns:xs=\"http://www.w3.org/2001/XMLSchema\" targetNamespace=\"http://TimeLoad_TimeLoad\">
    <xs:annotation>
    <xs:appinfo>
    <b:schemaInfo standard=\"Flat File\" root_reference=\"TimeLoadRoot\" parser_optimization=\"complexity\" lookahead_depth=\"15\" suppress_empty_nodes=\"true\" generate_empty_nodes=\"true\" allow_early_termination=\"true\" count_positions_by_byte=\"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=\"TimeLoadRoot\">
    <xs:annotation>
    <xs:appinfo>
    <b:recordInfo structure=\"delimited\" preserve_delimiter_for_empty_data=\"true\" suppress_trailing_delimiters=\"false\" sequence_number=\"1\" child_delimiter_type=\"hex\" child_delimiter=\"0x0D 0x0A\" child_order=\"postfix\"/>
    </xs:appinfo>
    </xs:annotation>
    <xs:complexType>
    <xs:sequence minOccurs=\"0\">
    <xs:annotation><xs:appinfo><b:groupInfo sequence_number=\"0\"/></xs:appinfo></xs:annotation>
    <xs:element name=\"TimeLoadCollection\">
    <xs:annotation><xs:appinfo>
    <b:recordInfo sequence_number=\"1\" structure=\"delimited\" child_delimiter_type=\"hex\" child_delimiter=\"0x0D 0x0A\" preserve_delimiter_for_empty_data=\"true\" suppress_trailing_delimiters=\"true\" 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=\"tlDate\" type=\"xs:string\" nillable=\"true\">
    <xs:annotation><xs:appinfo><b:fieldInfo justification=\"left\" sequence_number=\"1\"/></xs:appinfo></xs:annotation>
    </xs:element>
    <xs:element name=\"tlTimeKeeperInitials\" type=\"xs:string\" nillable=\"true\">
    <xs:annotation><xs:appinfo><b:fieldInfo justification=\"left\" sequence_number=\"2\"/></xs:appinfo></xs:annotation>
    </xs:element>
    <xs:element name=\"tlClientName\" type=\"xs:string\" nillable=\"true\">
    <xs:annotation><xs:appinfo><b:fieldInfo justification=\"left\" sequence_number=\"3\"/></xs:appinfo></xs:annotation>
    </xs:element>
    <xs:element name=\"tlMatterNumber\" type=\"xs:string\" nillable=\"true\">
    <xs:annotation><xs:appinfo><b:fieldInfo justification=\"left\" sequence_number=\"4\"/></xs:appinfo></xs:annotation>
    </xs:element>
    <xs:element name=\"tlBillStatus\" type=\"xs:string\" nillable=\"true\">
    <xs:annotation><xs:appinfo><b:fieldInfo justification=\"left\" sequence_number=\"5\"/></xs:appinfo></xs:annotation>
    </xs:element>
    <xs:element name=\"tlHoursAmount\" type=\"xs:string\" nillable=\"true\">
    <xs:annotation><xs:appinfo><b:fieldInfo justification=\"left\" sequence_number=\"6\"/></xs:appinfo></xs:annotation>
    </xs:element>
    <xs:element name=\"BlankLine\" type=\"xs:string\" nillable=\"true\">
    <xs:annotation><xs:appinfo><b:fieldInfo justification=\"left\" sequence_number=\"7\"/></xs:appinfo></xs:annotation>
    </xs:element>
    </xs:sequence>
    </xs:complexType>
    </xs:element>
    </xs:sequence>
    </xs:complexType>
    </xs:element>
    </xs:schema>
    [/code:1:85c9b9bcb0]

    Flat File \”80131940.txt\”
    [code:1:85c9b9bcb0]
    2005-06-21
    1125
    LA
    455133
    B
    2.25

    2005-06-21
    2351
    LA
    455134
    B
    8.00

    2005-06-21
    1026
    LA
    455135
    B
    5.50

    [/code:1:85c9b9bcb0]

    Test Command File \”80131940.cmd\”
    [code:1:85c9b9bcb0]
    \"C:\\Program Files\\Microsoft BizTalk Server 2004\\SDK\\Utilities\\PipelineTools\\FFDAsm.exe\" 80131940.txt -bs \"80131940.xsd\" -c -v

    pause
    [/code:1:85c9b9bcb0]

    Output
    [code:1:85c9b9bcb0]
    Creating objects.
    Creating message.
    Adding message to a pipeline.
    Executing pipeline.
    Getting processed message(s).

    Message 1:
    ————————————–

    <TimeLoadRoot xmlns=\"http://TimeLoad_TimeLoad\"><TimeLoadCollection xmlns=\"\"><tlDate>2005-0
    6-21</tlDate><tlTimeKeeperInitials>1125</tlTimeKeeperInitials><tlClientName>LA</tlClientNa
    me><tlMatterNumber>455133</tlMatterNumber><tlBillStatus>B</tlBillStatus><tlHoursAmount>2.2
    5</tlHoursAmount></TimeLoadCollection></TimeLoadRoot>

    Message 2:
    ————————————–

    <TimeLoadRoot xmlns=\"http://TimeLoad_TimeLoad\"><TimeLoadCollection xmlns=\"\"><tlDate>2005-0
    6-21</tlDate><tlTimeKeeperInitials>2351</tlTimeKeeperInitials><tlClientName>LA</tlClientNa
    me><tlMatterNumber>455134</tlMatterNumber><tlBillStatus>B</tlBillStatus><tlHoursAmount>8.0
    0</tlHoursAmount></TimeLoadCollection></TimeLoadRoot>

    Message 3:
    ————————————–

    <TimeLoadRoot xmlns=\"http://TimeLoad_TimeLoad\"><TimeLoadCollection xmlns=\"\"><tlDate>2005-0
    6-21</tlDate><tlTimeKeeperInitials>1026</tlTimeKeeperInitials><tlClientName>LA</tlClientNa
    me><tlMatterNumber>455135</tlMatterNumber><tlBillStatus>B</tlBillStatus><tlHoursAmount>5.5
    0</tlHoursAmount></TimeLoadCollection></TimeLoadRoot>

    Error
    Source: Flat file disassembler
    Message: Unexpected end of stream while looking for:
    ‘\\r\\n’
    The current definition being parsed is TimeLoadCollection. The stream offset where the err
    or occured is 145.
    HRESULT: 80131940

    [/code:1:85c9b9bcb0]