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
Post a Comment