Biznoob problem with flat file ReceivePipeline

Home Page Forums BizTalk 2004 – BizTalk 2010 Biznoob problem with flat file ReceivePipeline

Viewing 1 reply thread
  • Author
    Posts
    • #20981

      Hi all,

      I am trying to receive a flat file.  I used the wizard to create the schema.

      When I drop the file into the receive location I get the following in the
      Application Log:
      A message received by adapter “FILE” on receive location “Receive Location1”
      with URI “C:\snb_import\Receive\*.txt” is suspended.
      Error details: There was a failure executing the receive pipeline:
      “snb_import_orc.ReceivePipeline1, snb_import_orc, Version=1.0.0.0,
      Culture=neutral, PublicKeyToken=b4d40fc94a6f0d07″ Source: “Flat file
      disassembler” Receive Port: “ReceivePort1” URI: “C:\snb_import\Receive\*.txt”
      Reason: Unable to match the data in the input stream. 
      MessageId:  {B0AE5B9D-D3E8-4AE0-8333-59932ECDF9FB}
      InstanceID: {9D978C10-A218-4101-9526-23C95CCBC738}

      I am hoping someone can help me … Thank you for any information

      Text file contents in the format of:

      PID{tab}Location_ID{tab}MUN_ID{tab}DPS_ID{tab}CIVIC_NUM{tab}CIVIC_NUM_Suffix{tab}STREET_NAME{tab}STREET_TYPE{tab}STREET_DIR_CD{tab}PLACENAME{tab}X{tab}Y{CR}{LF}

      Created the following schema:
      <?xml version=”1.0″ encoding=”utf-16″ ?>
      – <xs:schema xmlns:b=”http://schemas.microsoft.com/BizTalk/2003
      xmlns=”http://snb_import_orc.FlatFileSchema1
      targetNamespace=”http://snb_import_orc.FlatFileSchema1
      xmlns:xs=”http://www.w3.org/2001/XMLSchema“>
      – <xs:annotation>
      – <xs:appinfo>
        <schemaEditorExtension:schemaInfo namespaceAlias=”b”
      extensionClass=”Microsoft.BizTalk.FlatFileExtension.FlatFileExtension”
      standardName=”Flat File”
      xmlns:schemaEditorExtension=”http://schemas.microsoft.com/BizTalk/2003/SchemaEditorExtensions” />
        <b:schemaInfo standard=”Flat File” codepage=”65001″ default_pad_char=””
      pad_char_type=”char” count_positions_by_byte=”false”
      parser_optimization=”speed” lookahead_depth=”3″ suppress_empty_nodes=”false”
      generate_empty_nodes=”true” allow_early_termination=”false”
      early_terminate_optional_fields=”false”
      allow_message_breakup_of_infix_root=”false” compile_parse_tables=”false”
      root_reference=”SNB_IMPORT” />
        </xs:appinfo>
        </xs:annotation>
      – <xs:element name=”SNB_IMPORT”>
      – <xs:annotation>
      – <xs:appinfo>
        <b:recordInfo structure=”delimited” child_delimiter_type=”hex”
      child_delimiter=”0x9″ child_order=”infix” sequence_number=”1″
      preserve_delimiter_for_empty_data=”true” suppress_trailing_delimiters=”false”
      />
        </xs:appinfo>
        </xs:annotation>
      – <xs:complexType>
      – <xs:sequence minOccurs=”1″ maxOccurs=”unbounded”>
      – <xs:annotation>
      – <xs:appinfo>
        <groupInfo sequence_number=”0″
      xmlns=”http://schemas.microsoft.com/BizTalk/2003” />
        </xs:appinfo>
        </xs:annotation>
      – <xs:element name=”PID” type=”xs:string”>
      – <xs:annotation>
      – <xs:appinfo>
        <b:fieldInfo justification=”left” sequence_number=”1″ />
        </xs:appinfo>
        </xs:annotation>
        </xs:element>
      – <xs:element name=”Location_ID” type=”xs:string”>
      – <xs:annotation>
      – <xs:appinfo>
        <b:fieldInfo justification=”left” sequence_number=”2″ />
        </xs:appinfo>
        </xs:annotation>
        </xs:element>
      – <xs:element name=”MUN_ID” type=”xs:string”>
      – <xs:annotation>
      – <xs:appinfo>
        <b:fieldInfo justification=”left” sequence_number=”3″ />
        </xs:appinfo>
        </xs:annotation>
        </xs:element>
      – <xs:element name=”DPS_ID” type=”xs:string”>
      – <xs:annotation>
      – <xs:appinfo>
        <b:fieldInfo justification=”left” sequence_number=”4″ />
        </xs:appinfo>
        </xs:annotation>
        </xs:element>
      – <xs:element name=”CIVIC_NUM” type=”xs:string”>
      – <xs:annotation>
      – <xs:appinfo>
        <b:fieldInfo justification=”left” sequence_number=”5″ />
        </xs:appinfo>
        </xs:annotation>
        </xs:element>
      – <xs:element name=”CIVIC_NUM_Suffix” type=”xs:string”>
      – <xs:annotation>
      – <xs:appinfo>
        <b:fieldInfo justification=”left” sequence_number=”6″ />
        </xs:appinfo>
        </xs:annotation>
        </xs:element>
      – <xs:element name=”STREET_NAME” type=”xs:string”>
      – <xs:annotation>
      – <xs:appinfo>
        <b:fieldInfo justification=”left” sequence_number=”7″ />
        </xs:appinfo>
        </xs:annotation>
        </xs:element>
      – <xs:element name=”STREET_TYPE” type=”xs:string”>
      – <xs:annotation>
      – <xs:appinfo>
        <b:fieldInfo justification=”left” sequence_number=”8″ />
        </xs:appinfo>
        </xs:annotation>
        </xs:element>
      – <xs:element name=”STREET_DIR_CD” type=”xs:string”>
      – <xs:annotation>
      – <xs:appinfo>
        <b:fieldInfo justification=”left” sequence_number=”9″ />
        </xs:appinfo>
        </xs:annotation>
        </xs:element>
      – <xs:element name=”PLACENAME” type=”xs:string”>
      – <xs:annotation>
      – <xs:appinfo>
        <b:fieldInfo justification=”left” sequence_number=”10″ />
        </xs:appinfo>
        </xs:annotation>
        </xs:element>
      – <xs:element name=”X” type=”xs:string”>
      – <xs:annotation>
      – <xs:appinfo>
        <b:fieldInfo justification=”left” sequence_number=”11″ />
        </xs:appinfo>
        </xs:annotation>
        </xs:element>
      – <xs:element name=”Y” type=”xs:string”>
      – <xs:annotation>
      – <xs:appinfo>
        <b:fieldInfo justification=”left” sequence_number=”12″ />
        </xs:appinfo>
        </xs:annotation>
        </xs:element>
        </xs:sequence>
        </xs:complexType>
        </xs:element>
        </xs:schema>

       

    • #20982

      It looks like your Flat File will have more than 1 line? If so you need to defined an envelope schema where you can set the child delimiter as a CRLF (0x0A 0x0D)

      • #20988

         I did try that but I am getting the same error.

        • #20990

           Solution …

          In the end I had to make sure that my dll version on my orchestration application was updated.  For some reason, even though it was uninstalled from the GAC it must have been caching the old version somehow. 

          Changing the version fixed everything for me.

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.