- This topic has 4 replies, 1 voice, and was last updated 9 years, 2 months ago by
.
-
Posts
-
-
It is looking for a ‘,’ in the first position of the file.
Do you have the [b:7728acde56]Child Order[/b:7728acde56] property set to prefix-
The schema has the following property set [b:04dbcd1612]codepage=\”1200\”[/b:04dbcd1612] which is Little-Endian-UTF16.
The data being received is ASCII or UTF-8
-
There a bug in my flat file schema but I can’t find it.
I receive order in a queue with just one line in each message seperated by a comma.Example:
order0001,car,5
This is the queue message:
6F 72 64 65 72 30 30 30 38 order0008
32 2C 76 6F 6F 72 72 75 69 2,voorrui
74 2C 37 33 0A t,73.While testing, I get following error:
There was a failure executing the receive pipeline: \”BizTalkEindwerk.ReceivePipelineMSMQ, BizTalkEindwerk, Version=1.0.0.0, Culture=neutral, PublicKeyToken=868284ea4d391221\” Source: \”Flat file disassembler\” Receive Port: \”ReceivePortMSMQ\” URI: \”FORMATNAME:DIRECT=OS:AWS00293\\PRIVATE$\\PRODUCTIE\” Reason: Unexpected data found while looking for:
‘,’
The current definition being parsed is Root. The stream offset where the error occured is 0. The line number where the error occured is 1. The column where the error occured is 0.Any idea’s?
Greetings
-
It’s set to Infix
[code:1:bdf9aad782]<?xml version=\"1.0\" encoding=\"utf-16\"?>
<xs:schema xmlns:ns0=\"http://BizTalkEindwerk.Property\" xmlns:b=\"http://schemas.microsoft.com/BizTalk/2003\" xmlns=\"http://BizTalkEindwerk.ReceiveMSMQ\" targetNamespace=\"http://BizTalkEindwerk.ReceiveMSMQ\" 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=\"1200\" 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=\"Root\" />
<b:imports>
<b:namespace prefix=\"ns0\" uri=\"http://BizTalkEindwerk.Property\" location=\".\\property.xsd\" />
</b:imports>
</xs:appinfo>
</xs:annotation>
<xs:element name=\"Root\">
<xs:annotation>
<xs:appinfo>
<b:recordInfo structure=\"delimited\" child_delimiter_type=\"char\" child_delimiter=\",\" child_order=\"infix\" sequence_number=\"1\" preserve_delimiter_for_empty_data=\"true\" suppress_trailing_delimiters=\"false\" />
<b:properties>
<b:property name=\"ns0:OrderNumber\" xpath=\"/*[local-name()=’Root’ and namespace-uri()=’http://BizTalkEindwerk.ReceiveMSMQ’]/*[local-name()=’OrderID’ and namespace-uri()=”]\" />
</b:properties>
</xs:appinfo>
</xs:annotation>
<xs:complexType>
<xs:sequence>
<xs:annotation>
<xs:appinfo>
<groupInfo sequence_number=\"0\" xmlns=\"http://schemas.microsoft.com/BizTalk/2003\" />
</xs:appinfo>
</xs:annotation>
<xs:element name=\"OrderID\" type=\"xs:string\">
<xs:annotation>
<xs:appinfo>
<b:fieldInfo justification=\"left\" sequence_number=\"1\" />
</xs:appinfo>
</xs:annotation>
</xs:element>
<xs:element name=\"Product\" type=\"xs:string\">
<xs:annotation>
<xs:appinfo>
<b:fieldInfo justification=\"left\" sequence_number=\"2\" />
</xs:appinfo>
</xs:annotation>
</xs:element>
<xs:element name=\"Aantal\" type=\"xs:int\">
<xs:annotation>
<xs:appinfo>
<b:fieldInfo justification=\"left\" sequence_number=\"3\" />
</xs:appinfo>
</xs:annotation>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>[/code:1:bdf9aad782]
-
-
-
-
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.