Flat File parsing error 80131940

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

Viewing 2 reply threads
  • Author
    Posts
    • October 4, 2005 at 4:30 PM #12019
      community-content

        Hi, I am parsing a flat file. Each field is delimited with a crlf (HEX 0X0A 0X0D) and each record is seperated with a blank line. If the file has an extra blank line I get the error:

        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 error occured is 202.

        HRESULT: 80131940

        If I remove the blank line then everything works great.

        The flat file looks like this:

        [code:1:c546d6da96]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:c546d6da96]

        I would like to ignore any repeating delimiters as well as any trailing delimiters.

        I have found several posts concerning this error but none of the solutions seem to work.

        Please help :([/list]

      • October 4, 2005 at 5:11 PM #12020
        community-content

          Hi,

          My Child Order is currently Infix. When I change it to PostFix I get an the same error but earlier in the file. It cannot even read the first record. Whereas when I keep it Infix, it reads all the records but it seems to think there is another record and then fails.

          Thanks

          • 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]

              • October 4, 2005 at 4:57 PM #12022
                community-content

                  Hello.

                  What do you have your Default Child Order set to?

                  Try changing it to Infix or Post fix to see if that helps.

                  • October 4, 2005 at 5:15 PM #12023
                    community-content

                      If you want, you can email me your schema and sample file and I can take a look at it.

                      I’ll have some time tonight to take a look at it.

              • November 14, 2020 at 2:08 PM #50078
                biztalkgurus

                  The Dirty Girls Social Club : Alisa Valdés-Rodríguez : 9781250765864

              • Author
                Posts
              Viewing 2 reply threads
              • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.