unexpected end of stream on Flat File disassemble


<p>i have 3 comma-delimited flat files. strip off headers in pipeline component, , there no footers. created schemas using wizard, , moved root node down level set debatching in pipeline. </p><p>on three, "unexpected end of stream" error on last column of last row of data. </p><p></p><p>i have </p>

down there somewhere, ones , zeros.

i cut/pasted schema , test data post , believe the  xsd below should work.  if csv file contains <cr><lf> after each record, change <batchdetail> postfix , <schema> property allow message breakup @ infix root no <invoicedetail> element child order changed infix.

i tested it with ffdasm.exe using following command line:

ffdasm.exe elbodata.txt -bs elboendofstream.xsd

note: have pipelinetools folder in current command window path using set path=%path%;%btsinstallpath%\sdk\utilities\pipelinetools;

<?xml version="1.0" encoding="utf-16"?> <xs:schema xmlns="http://redcross.biztalk.integration.exportok2pay.schemas.ariba_exportok2pay_invoicedetail" xmlns:b="http://schemas.microsoft.com/biztalk/2003" targetnamespace="http://redcross.biztalk.integration.exportok2pay.schemas.ariba_exportok2pay_invoicedetail" 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="true" compile_parse_tables="false" root_reference="batchdetail" child_delimiter_type="hex" default_child_delimiter="0x0d 0x0a" default_child_order="postfix" />     </xs:appinfo>   </xs:annotation>   <xs:element name="batchdetail">     <xs:annotation>       <xs:appinfo>         <b:recordinfo sequence_number="1" structure="delimited" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" child_delimiter_type="hex" child_delimiter="0x0d 0x0a" 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 maxoccurs="1" name="invoicedetail">           <xs:annotation>             <xs:appinfo>               <b:recordinfo structure="delimited" child_delimiter_type="char" child_delimiter="," child_order="infix" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" sequence_number="1" />             </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="paymentid" type="xs:string">                 <xs:annotation>                   <xs:appinfo>                     <b:fieldinfo justification="left" sequence_number="1" />                   </xs:appinfo>                 </xs:annotation>               </xs:element>               <xs:element name="amount" type="xs:string">                 <xs:annotation>                   <xs:appinfo>                     <b:fieldinfo justification="left" sequence_number="2" />                   </xs:appinfo>                 </xs:annotation>               </xs:element>               <xs:element name="unitprice" type="xs:string">                 <xs:annotation>                   <xs:appinfo>                     <b:fieldinfo justification="left" sequence_number="3" />                   </xs:appinfo>                 </xs:annotation>               </xs:element>               <xs:element name="description" type="xs:string">                 <xs:annotation>                   <xs:appinfo>                     <b:fieldinfo justification="left" sequence_number="4" />                   </xs:appinfo>                 </xs:annotation>               </xs:element>               <xs:element name="taxtype" type="xs:string">                 <xs:annotation>                   <xs:appinfo>                     <b:fieldinfo justification="left" sequence_number="5" />                   </xs:appinfo>                 </xs:annotation>               </xs:element>               <xs:element name="taxcode" type="xs:string">                 <xs:annotation>                   <xs:appinfo>                     <b:fieldinfo justification="left" sequence_number="6" />                   </xs:appinfo>                 </xs:annotation>               </xs:element>               <xs:element name="taxadjustmentamount" type="xs:string">                 <xs:annotation>                   <xs:appinfo>                     <b:fieldinfo justification="left" sequence_number="7" />                   </xs:appinfo>                 </xs:annotation>               </xs:element>               <xs:element name="isaccrual" type="xs:string">                 <xs:annotation>                   <xs:appinfo>                     <b:fieldinfo justification="left" sequence_number="8" />                   </xs:appinfo>                 </xs:annotation>               </xs:element>               <xs:element name="linenumber" type="xs:string">                 <xs:annotation>                   <xs:appinfo>                     <b:fieldinfo justification="left" sequence_number="9" />                   </xs:appinfo>                 </xs:annotation>               </xs:element>               <xs:element name="erporderlinenumber" type="xs:string">                 <xs:annotation>                   <xs:appinfo>                     <b:fieldinfo justification="left" sequence_number="10" />                   </xs:appinfo>                 </xs:annotation>               </xs:element>               <xs:element name="invoicereconciliationid" type="xs:string">                 <xs:annotation>                   <xs:appinfo>                     <b:fieldinfo justification="left" sequence_number="11" />                   </xs:appinfo>                 </xs:annotation>               </xs:element>               <xs:element name="erporderid" type="xs:string">                 <xs:annotation>                   <xs:appinfo>                     <b:fieldinfo justification="left" sequence_number="12" />                   </xs:appinfo>                 </xs:annotation>               </xs:element>               <xs:element name="linetypecategory" type="xs:string">                 <xs:annotation>                   <xs:appinfo>                     <b:fieldinfo justification="left" sequence_number="13" />                   </xs:appinfo>                 </xs:annotation>               </xs:element>               <xs:element name="purchasingunit" type="xs:string">                 <xs:annotation>                   <xs:appinfo>                     <b:fieldinfo justification="left" sequence_number="14" />                   </xs:appinfo>                 </xs:annotation>               </xs:element>               <xs:element name="parentlinenumber" type="xs:string">                 <xs:annotation>                   <xs:appinfo>                     <b:fieldinfo justification="left" sequence_number="15" />                   </xs:appinfo>                 </xs:annotation>               </xs:element>               <xs:element name="erpcommoditycode" type="xs:string">                 <xs:annotation>                   <xs:appinfo>                     <b:fieldinfo justification="left" sequence_number="16" />                   </xs:appinfo>                 </xs:annotation>               </xs:element>               <xs:element name="amountcurrency" type="xs:string">                 <xs:annotation>                   <xs:appinfo>                     <b:fieldinfo justification="left" sequence_number="17" />                   </xs:appinfo>                 </xs:annotation>               </xs:element>             </xs:sequence>           </xs:complextype>         </xs:element>       </xs:sequence>     </xs:complextype>   </xs:element> </xs:schema>


david downing... if answers question, please mark answer. if post helpful, please vote helpful.




BizTalk Server  >  BizTalk Server General



Comments

Popular posts from this blog

Azure DocumentDB Owner resource does not exist

BizTalk Server 2013 Azure VM Log Shipping and HA for hosts

How to send non-standard Content-Type header ?