[community-content]

Here is a schema that will parse what you request. Just added a field after the tag identifiers to test, so the tested file looks like this:

 

000111

000222

000333

000334

000444

000223

000335

000445

000777

 

Here is the schema:

<?xml version=”1.0″ encoding=”utf-16″ ?> 

– <xs:schema xmlns=”http://BizTalk_Server_Project1.FlatFileSchema1&#8243; xmlns:b=”http://schemas.microsoft.com/BizTalk/2003&#8243; targetNamespace=”http://BizTalk_Server_Project1.FlatFileSchema1” xmlns:xs=”http://www.w3.org/2001/XMLSchema”>&nbsp;

– <xs:annotation> 

– <xs:appinfo> 

<b:schemaInfo standard=”Flat File” root_reference=”Root” 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” /> 

<schemaEditorExtension:schemaInfo namespaceAlias=”b” extensionClass=”Microsoft.BizTalk.FlatFileExtension.FlatFileExtension” standardName=”Flat File” xmlns:schemaEditorExtension=”http://schemas.microsoft.com/BizTalk/2003/SchemaEditorExtensions&#8221; /> 

</xs:appinfo> 

</xs:annotation> 

– <xs:element name=”Root“> 

– <xs:annotation> 

– <xs:appinfo> 

<b:recordInfo structure=”delimited” preserve_delimiter_for_empty_data=”true” suppress_trailing_delimiters=”false” sequence_number=”1” child_delimiter_type=”hex” child_delimiter=”0x0D 0x0A” child_order=”postfix” /> 

</xs:appinfo> 

</xs:annotation> 

– <xs:complexType> 

– <xs:sequence> 

– <xs:annotation> 

– <xs:appinfo> 

<b:groupInfo sequence_number=”0” /> 

</xs:appinfo> 

</xs:annotation> 

– <xs:element minOccurs=”1” maxOccurs=”1” name=”node0001“> 

– <xs:annotation> 

– <xs:appinfo> 

<b:recordInfo sequence_number=”1” structure=”positional” preserve_delimiter_for_empty_data=”true” suppress_trailing_delimiters=”false” tag_name=”0001” child_delimiter_type=”hex” child_order=”infix” child_delimiter=”0x0D 0x0A” /> 

</xs:appinfo> 

</xs:annotation> 

– <xs:complexType> 

– <xs:sequence> 

– <xs:annotation> 

– <xs:appinfo> 

<b:groupInfo sequence_number=”0” /> 

</xs:appinfo> 

</xs:annotation> 

– <xs:element name=”Tag” type=”xs:string“> 

– <xs:annotation> 

– <xs:appinfo> 

<b:fieldInfo sequence_number=”1” justification=”left” pos_length=”4” /> 

</xs:appinfo> 

</xs:annotation> 

</xs:element> 

– <xs:element name=”Field” type=”xs:string“> 

– <xs:annotation> 

– <xs:appinfo> 

<b:fieldInfo sequence_number=”2” justification=”left” pos_length=”2” /> 

</xs:appinfo> 

</xs:annotation> 

</xs:element> 

</xs:sequence> 

</xs:complexType> 

</xs:element> 

– <xs:element minOccurs=”1” maxOccurs=”999999” name=”Loop“> 

– <xs:annotation> 

– <xs:appinfo> 

<b:recordInfo sequence_number=”2” structure=”delimited” preserve_delimiter_for_empty_data=”true” suppress_trailing_delimiters=”false” child_order=”infix” child_delimiter_type=”hex” child_delimiter=”0x0D 0x0A” /> 

</xs:appinfo> 

</xs:annotation> 

– <xs:complexType> 

– <xs:sequence> 

– <xs:annotation> 

– <xs:appinfo> 

<b:groupInfo sequence_number=”0” /> 

</xs:appinfo> 

</xs:annotation> 

– <xs:element minOccurs=”1” maxOccurs=”1” name=”node0002“> 

– <xs:annotation> 

– <xs:appinfo> 

<b:recordInfo structure=”positional” preserve_delimiter_for_empty_data=”true” suppress_trailing_delimiters=”false” tag_name=”0002” child_order=”infix” child_delimiter_type=”hex” child_delimiter=”0x0D 0x0A” sequence_number=”1” /> 

</xs:appinfo> 

</xs:annotation> 

– <xs:complexType> 

– <xs:sequence> 

– <xs:annotation> 

– <xs:appinfo> 

<b:groupInfo sequence_number=”0” /> 

</xs:appinfo> 

</xs:annotation> 

– <xs:element name=”Tag” type=”xs:string“> 

– <xs:annotation> 

– <xs:appinfo> 

<b:fieldInfo sequence_number=”1” justification=”left” pos_length=”4” /> 

</xs:appinfo> 

</xs:annotation> 

</xs:element> 

– <xs:element name=”Field” type=”xs:string“> 

– <xs:annotation> 

– <xs:appinfo> 

<b:fieldInfo sequence_number=”2” justification=”left” pos_length=”2” /> 

</xs:appinfo> 

</xs:annotation> 

</xs:element> 

</xs:sequence> 

</xs:complexType> 

</xs:element> 

– <xs:element minOccurs=”1” maxOccurs=”999999” name=”node0003“> 

– <xs:annotation> 

– <xs:appinfo> 

<b:recordInfo structure=”positional” preserve_delimiter_for_empty_data=”true” suppress_trailing_delimiters=”false” tag_name=”0003” sequence_number=”2” /> 

</xs:appinfo> 

</xs:annotation> 

– <xs:complexType> 

– <xs:sequence> 

– <xs:annotation> 

– <xs:appinfo> 

<b:groupInfo sequence_number=”0” /> 

</xs:appinfo> 

</xs:annotation> 

– <xs:element name=”Tag” type=”xs:string“> 

– <xs:annotation> 

– <xs:appinfo> 

<b:fieldInfo sequence_number=”1” justification=”left” pos_length=”4” /> 

</xs:appinfo> 

</xs:annotation> 

</xs:element> 

– <xs:element name=”Field” type=”xs:string“> 

– <xs:annotation> 

– <xs:appinfo> 

<b:fieldInfo sequence_number=”2” justification=”left” pos_length=”2” /> 

</xs:appinfo> 

</xs:annotation> 

</xs:element> 

</xs:sequence> 

</xs:complexType> 

</xs:element> 

– <xs:element minOccurs=”1” maxOccurs=”1” name=”node0004“> 

– <xs:annotation> 

– <xs:appinfo> 

<b:recordInfo structure=”positional” preserve_delimiter_for_empty_data=”true” suppress_trailing_delimiters=”false” tag_name=”0004” sequence_number=”3” /> 

</xs:appinfo> 

</xs:annotation> 

– <xs:complexType> 

– <xs:sequence> 

– <xs:annotation> 

– <xs:appinfo> 

<b:groupInfo sequence_number=”0” /> 

</xs:appinfo> 

</xs:annotation> 

– <xs:element name=”Tag” type=”xs:string“> 

– <xs:annotation> 

– <xs:appinfo> 

<b:fieldInfo sequence_number=”1” justification=”left” pos_length=”4” /> 

</xs:appinfo> 

</xs:annotation> 

</xs:element> 

– <xs:element name=”Field” type=”xs:string“> 

– <xs:annotation> 

– <xs:appinfo> 

<b:fieldInfo sequence_number=”2” justification=”left” pos_length=”2” /> 

</xs:appinfo> 

</xs:annotation> 

</xs:element> 

</xs:sequence> 

</xs:complexType> 

</xs:element> 

</xs:sequence> 

</xs:complexType> 

</xs:element> 

– <xs:element minOccurs=”1” maxOccurs=”1” name=”node0007“> 

– <xs:annotation> 

– <xs:appinfo> 

<b:recordInfo sequence_number=”3” structure=”positional” preserve_delimiter_for_empty_data=”true” suppress_trailing_delimiters=”false” tag_name=”0007” /> 

</xs:appinfo> 

</xs:annotation> 

– <xs:complexType> 

– <xs:sequence> 

– <xs:annotation> 

– <xs:appinfo> 

<b:groupInfo sequence_number=”0” /> 

</xs:appinfo> 

</xs:annotation> 

– <xs:element name=”Tag” type=”xs:string“> 

– <xs:annotation> 

– <xs:appinfo> 

<b:fieldInfo sequence_number=”1” justification=”left” pos_length=”4” /> 

</xs:appinfo> 

</xs:annotation> 

</xs:element> 

– <xs:element name=”Field” type=”xs:string“> 

– <xs:annotation> 

– <xs:appinfo> 

<b:fieldInfo sequence_number=”2” justification=”left” pos_length=”2” /> 

</xs:appinfo> 

</xs:annotation> 

</xs:element> 

</xs:sequence> 

</xs:complexType> 

</xs:element> 

</xs:sequence> 

</xs:complexType> 

</xs:element> 

</xs:schema>

 

 

[community-content]

This is due to the pass-through in the sendport. Please try with the XML Assembler instead

[community-content]

The easiest way would be to create a flatfile assembler in a send pipeline from the same schema and use this in a sendport with filters set to the receiveport. This way you can have the file validated and sent to any destination.

Or is there any specific reason you cant assemble the disassembled version?

[community-content]

i am also getting same error while transforming the data from xml to sql through wcf-adapoter. i validated schema and test the mapping .. those are getting replay what i expected.

but i am getting error on wcf-adopter.: pasted bellow

The adapter failed to transmit message going to send port "WcfSendPort_SqlAdapterBinding_Procedures_DM_Custom" with URL "mssql://sdasyapu01//CVM_Testnet_DryRun20140122_CSD?". It will be retransmitted after the retry interval specified for this Send Port. Details:"Microsoft.ServiceModel.Channels.Common.XmlReaderParsingException: The start element with name "XSHT1841" and namespace "" was unexpected. Please ensure that your input XML conforms to the schema for the operation

Any help on this:

i used mapping in inbound in wcf_sql adopter and i am not using any orchestration

[community-content]

Need to set Set the Itinerary Status =Deployed or restart the host instance , check the table named select * from EsbItineraryDb.dbo.Itinerary, nStatus column value should be 1 now !

[community-content]

Thank you verymuch

[community-content]

Need to start ruleengineupdateservice services.

msdn.microsoft.com/…/dd298814.aspx

[community-content]

Got my answer……

It was a security issue and it drove me nuts for a long time.

[community-content]

Hi,

 You have to change your schema to set the "Min Occurs" property to value of 0 for the two elements Age and DOB, so that the receive port will accept your sample input XML without any instance of those two elements present in the contents.

  Good luck.

[community-content]

Check the GAC on your BizTalk server and make sure the version of the flat file schema is the latest that you deployed, otherwise uninstall the old one and reinstall the newer version. If you are deploying from Visual Studio to your BizTalk server, make sure that the setting "Install to Global Assembly Cache" is set to True in the Deployment tab of your project properties, before deploying the artifact.

[community-content]

Open BizTalk Server Configuration Console. (All Programs %u2192 Microsoft BizTalk Server %u2192 BizTalk Server Configuration)

Select the option “BAM Tools” in the left menu and check the option “Enable Analysis Services for BAM Aggregations”

Configure “BAM Analysis Database” and “BAM Star Schema Database”

BAM-Tools-Configuration

Click in “Apply Configuration”

On the Summary screen, Click “Next”

BAM-Tools-Configuration-summary

On the completed screen, click “Finish”

[community-content]

I tried remove-all, and then deploy-all, but still same error.  Activity Deployed successfully, View – Error as above

[community-content]

Envelop schema ia an another type of schema, with batch concepts, enable Envelop as Yes for <Schema> node

[community-content]

(MCTS): Microsoft BizTalk Server 2010 (70-595)

[community-content]

Hi,

  Here's a link to beginner's guide on BizTalk 2010:

social.technet.microsoft.com/…/5056.biztalk-server-2010-beginners-guide.aspx

  You can find more information about the Microsoft Exam for BizTalk 2010 certification at this link:

http://www.microsoft.com/…/exam-70-595.aspx

  Good luck.

[Author]

Posts