community-content

Forum Replies Created

Viewing 15 posts - 2,176 through 2,190 (of 9,648 total)
  • Author
    Posts
  • in reply to: Evaluating on the amount of items returned in a message #23402

    Hi Grant,

     

       In my previous post, I mentioned that your Decide shape should have the If Branch rule with its conditional statement set to nMessageCount == 30 , with nMessageCount being a secondary counter that you would use as a message batch counter, and you would reset that counter in the If Branch rule workflow.

       Also, are you iterating through your original message in your loop, because you should not be getting the same message each time your loop comes around? To concatenate your messages together after extracting each one from your original message, define a Scope shape with transaction type Atomic, and inside that scope shape, define two variables, one of type System.Xml.XmlNode and the other of type System.Xml.XmlNodeList (let’s call them vXmlNode and vXmlNodeList). Then define an Expression shape in your Scope shape, that have the following lines of code (let’s call your original message InputMessage):

    vXmlNodeList = xpath(InputMessage, “/*[local-name()=’Employees’ and namespace-uri()=”]/*[local-name()=’Employee’ and namespace-uri()=”][” + nLoopCount + “]”);

    vXmlNode = vXmlNodeList.Item(0);

    myVar = myVar + vXmlNode.InnerText;

     

       This should help you achieve what you want. Let me know how you make out on this.

     

       Daniel.

    in reply to: File Splitter #23400

    Hi,

     

       Let’s say your X12 message has the following XML contents (I’m taking the example of an X12 format of transaction type 271 and showing just a snippet of it), let’s call it mX12:

    <gen0:X12_00401_271 xmlns:gen0=”http://schemas.microsoft.com/BizTalk/EDI/X12/2006″><ST><ST01>271</ST01><ST02>ST02</ST02></ST&gt;

    … </gen0:X12_00401_271>

       Now, let’s say you just want to extract the ST node and put that into your output message mOut. First of all, in your orchestration, declare a String variable vXPath and a variable vXmlDocument of type System.Xml.XmlDocument, and define a Scope shape of transaction type Atomic. In your scope shape, define two variables of type System.Xml.XmlNode and System.Xml.XmlNodeList, let’s call them vXmlNode and vXmlNodeList.

       Then, in your scope shape, define an Expression shape and put the following code in it:

    vXPath = “/*[local-name()=’X12_00401_271′ and namespace-uri()=’http://schemas.microsoft.com/BizTalk/EDI/X12/2006′%5D/*%5Blocal-name()=’ST&#8217; and namespace-uri()=”]”;

    vXmlNodeList = xpath(mX12, vXPath);

    vXmlNode = vXmlNodeList.Item(0);

    vXmlDocument.LoadXml(“<ns0:YourSchemaName xmlns:ns0=” + System.Char.ToString(‘”‘) + “http://YourSchemaNamespace” + System.Char.ToString(‘”‘) + “>” + vXmlNode.InnerText + “</ns0:YourSchemaName>”;

    mOut = vXmlDocument;

     

       And you would follow the same pattern for your other output message.

     

       I hope this is enough information to get you going.

     

       Daniel.

     

    in reply to: WCF-custom error with SQL adapter #23399

    This does it’s work!

     

    Thanx !

    in reply to: Evaluating on the amount of items returned in a message #23396

    Hi Daniel,
                     Sorry to bother you again on this subject, I went to implement what you had suggested which seems correct but I have run into the following issue:

    my decide shapes are there job ie. nLoopCount <= 30 and then the expression has the following RemitXmlDoc.LoadXml(strHeaderRemitMsg + MyVar + strTrailerRemitMsg); But what I get is for the 43 records being returned in the count I get 43 times the same message beiong repeated in the out put file:

    Any ideas
    Grant

    in reply to: Mapping name value pairs #23395

    One more detail.. The name element specifies the destination element it should be mapped to..

    eg <Name>Org</Name><Value>Contoso</Value> means the <Org> element (will be present in destination schema) should have value Contoso..

    in reply to: Mapping name value pairs #23394

    Hi Brunchey,

    Thanks for the look.. The property pairs are part of a large Order Request. Since this is a generic request it caters to different kind of orders and hence the data required for each order is passed as name-value pairs. Our orchestration has to extract the data and populate the actual order which will be passed to the back end system.

    Please let me know if this info is enough or you would like to know more.. 🙂

    in reply to: File Splitter #23393

    Thanks Daniel for your reply

    Can you provide me with an example of how to use the XLANGs and XPATH..I am new to BizTalk. Kindly bear with me.

    Thanks you

    in reply to: File Splitter #23392

    Hi PV,

     

       In both cases, you can use XLANGs and XPath (in an orchestration) to split your original message and construct your outgoing messages.

     

       Best,

     

       Daniel.

    in reply to: Singleton in clustered envrioment #23390

    Hi,

     

       Have you thought about using a different pattern to address your need, say the Scatter-and-Gather approach described in the following link:

    http://www.richardhallgren.com/a-loosely-coupled-scatter-and-gather-implementation-in-biztalk-2006/

     

       Hope this helps.

     

       Daniel.

    in reply to: Singleton in clustered envrioment #23389

    http://onjava.com/pub/a/onjava/2003/08/20/jboss_clustering.html

    Jboss does what I need, how do i accomplish this in BizTalk?

    in reply to: Mapping name value pairs #23386

    is there something wrapping the Property elements in the source schema that lets you know that the two go together?

    in reply to: Using dynamic SMTP port fails. #23382

    The problem was (my guess) with default adapter. Smtp host was set incorrectly in default adapter and even though I specified host dynamically default value was used.

    in reply to: WCF-custom error with SQL adapter #23381

    I’ll check that 🙂

    Thank you.

     

    in reply to: Creating Flat File Schemas #23380

    Hi Daniel,

    I’ve tried that and no luck. Currently y schema is like this

    Schema
         Root — Postfix 0x0d 0x0a
            HeaderLine – Positional (maxoccurs – 1)
            DataLines – Infix 0x0d 0x0a (maxoccurs – unbounded)
                <Sequence Group> (maxoccurs – unbounded)
                        Line1 (maxoccurs – unbounded)
                        Line2 (maxoccurs – unbounded)
            TrailerLine – Positional (maxoccurs – 1)

    If i have only 1 set of data DataLines, its getting validated successfully. But it fails for 2 set of the same. Let me know if you have any suggestions.

    Cheers,
    Karthick G.

    in reply to: BAM – Failure Milestone not working #23378

    Still having this issue…. I’m thinking it’s not raising an error to track that exception.  The send is a one-way and is not getting any response back (async).  If I unenlist the send port it will generate the failure stage in the dimension.

    For now, I have set up a new activity and view to subscribe to failed messages on the send/rcv ports found at this url: http://msdn.microsoft.com/en-us/library/cc546584(BTS.10).aspx.  This is basically a subscriber to the ErrorType context.  I had to enable tracking for the ports that I want to report failures on. 

    Any other thoughts on this?

Viewing 15 posts - 2,176 through 2,190 (of 9,648 total)