Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Biznoob problem with flat file ReceivePipeline
- This topic has 3 replies, 1 voice, and was last updated 9 years, 2 months ago by
community-content.
-
AuthorPosts
-
-
October 15, 2008 at 9:57 AM #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> -
October 15, 2008 at 12:40 PM #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)
-
October 16, 2008 at 6:42 AM #20988
I did try that but I am getting the same error.
-
October 16, 2008 at 10:57 AM #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.
-
-
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.