community-content

Forum Replies Created

Viewing 15 posts - 751 through 765 (of 9,648 total)
  • Author
    Posts
  • in reply to: Filter for Different Messages comming to a single folder #25495

    When you promoted field in a schema, there should be created property schema, with a field same to that promoted field name. After you deploy those schemas, (your schema and your property schema), you should see in Filter expression of an orchestration or Filter in Send port – your promoted field.

    You should choose it, and in each orchestration, to set filtering on YourSchemaNameSpace.UniqueField == “SomeValueYouExpectToGet”

    in reply to: subscription/correlation question #25494

    Hi,

    1. I like your avatar!!  :)) 

    2. In one of our project, we used some field in an incoming schema, as a field served for for correlation. It was promoted in receive pipeline, and the value of that field was set to context of an outgoing message.

    in reply to: Logging WCF SQL Adapter #25493

    Hi Wolfgang,

     

        Just for your WCF adapter scenario, you can go to the Transport Advanced Options tab on your Send port and check the “Enable routing for failed messages” checkbox to capture any failed messages that come back in the response from the call to the WCF adapter. You can then set up another Send port to filter on these failed messages from the WCF adapter and save them as files to the file system, and you can have a third-party file watcher program to notify you of any new files created in that folder.

     

        Just a suggestion which does not involve any external logging component, and something more substantial than periodically checking the Event Viewer for any error messages logged by BizTalk engine.

     

        Daniel.

     

    in reply to: Logging WCF SQL Adapter #25492

    Hi Daniel.

    Yes, you’re right, it make sense to me, if I have an orchestration or some more programming stuff in it. But just to see if a WCF Adapter is up and running each 5 minutes?? I think this will work fine and just in case of an error there will be the BTS log enough, I’m I right?

    Thanks.

    Wolfgang

    in reply to: Logging WCF SQL Adapter #25491

    Hi Wolfgang,

     

       We use separate logging system in production to troubleshoot our BizTalk orchestrations, so that we can pinpoint what is failing when some BizTalk process goes down. The error messages in the Event Viewer are sometimes too verbose, and you have to dig in deeply to find out the root cause of what is failing and that takes time and effort. So, for us anyway, there is a tremendous benefit in having a separate logging system.

     

       Cheers,

     

       Daniel.

     

    in reply to: Structural Errors #25490

    Hi.

    Is this error message coming up by each edifact message?

    Did you generate an instance of it?

    Wolfgang

    in reply to: Logging WCF SQL Adapter #25489

    Hi Daniel.

    Thanks a lot for reply and tipps.

    Actually I don’t know exactly what is the benefit of seperat logging system beside the one BTS has. Because BTS will only logging something if something runs into an error or BTS will run into an error. So for me it is fine if I get just an error message if something coming up and I get the error in the event viewer or in the normel BTS log.

    I don’t want thousends or more of logfiles and each says – “ok, everything is fine!”

    Do you think BTS’ logging system is sufficient?

    Thanks

    Wolfgang

    in reply to: Logging WCF SQL Adapter #25488

    Hi Wolfgang,

     

       BizTalk does not have a logging feature out of the box, you would either have to implement a separate external C# assembly (called from BizTalk) or implement Microsoft Enterprise Library’s Logging Application (and modify the BTSNTSvc.exe.config file in the BizTalk installation path). Those are the two options I can think of, you might also want to check the Codeplex website (http://www.codeplex.com) for any open source alternatives.

     

       Best,

     

       Daniel.

     

    in reply to: Create Positional Flat File #25487

    Hi sbrown63,

     

        I got the sample working now… You can download the updated version from the same area, under My Files section, and the zipped file is sbrown63.zip.

       It involved more work than I anticipated: I had to change the Positional Flat File schema setting the Max Occurs to unbounded on the Group node, and I modified the map to also use a Table Looping functoid (with table extractors) linking the Benefit node of the Xml Schema to the Benefit node in the Positional schema.

     

       Hope this works for you,

     

       Daniel.

     

    in reply to: Filter for Different Messages comming to a single folder #25482

    Thanks a lot Daniel.. It’s really helpfull.

    But when I tried to set the same in property dropdown of the filter expression, I didnt find the message type over there.

    Is there any other thing i need to set for this?

    Regards,

    in reply to: Create Positional Flat File #25480

    I also had to set the Ma Occurs on the Member and Benefit nodes of the XmlSchema in order to successfully validate it against the sample instance of xml.

    in reply to: Create Positional Flat File #25479

    Hi again,   its fours hour later and still no luck. With the above settings I still cannot get the output to include multiple members/benefits in the correct format. I’m starting to get the urge to throw things at my PC. If you could take one more look to see if there is anything obvious I’d greatly appreciate it.

    Flat file results:

    H2_0      H2_0
    Frank  Farmer 
    B1_0   B2_0   
    B5_0   B6_0   
    T1_0

    Flat file expected results:

    H2_0      H2_0
    Frank  Farmer 
    B1_0   B2_0   
    B3_0   B4_0   
    Jim Beam  
    B5_0   B6_0   
    B7_0   B8_0
    T1_0      

    Incoming xml:

    <ns0:Container xmlns:ns0=”http://sbrown63.XmlSchema“>
      <Header>
        <H1>H2_0</H1>
        <H2>H2_0</H2>
      </Header>
      <Members>
        <Member>
          <NameFirst>Frank</NameFirst>
          <NameLast>Farmer</NameLast>
          <Benefits>
            <Benefit>
              <B1>B1_0</B1>
              <B2>B2_0</B2>
            </Benefit>
            <Benefit>
              <B1>B3_0</B1>
              <B2>B4_0</B2>
            </Benefit>
          </Benefits>
        </Member>
        <Member>
          <NameFirst>Jim</NameFirst>
          <NameLast>Beam</NameLast>
          <Benefits>
            <Benefit>
              <B1>B5_0</B1>
              <B2>B6_0</B2>
            </Benefit>
            <Benefit>
              <B1>B7_0</B1>
              <B2>B8_0</B2>
            </Benefit>
          </Benefits>
        </Member>
      </Members>
      <Trailer>
        <T1>T1_0</T1>
      </Trailer>
    </ns0:Container>

     

    in reply to: Create Positional Flat File #25478

    Hi sbrown63,

     

       Don’t forget to change the XML schema if you want to generate more than one instance of member/benefits record:

    1. Set the Members node’s Max Occurs property to the unbounded value.

    2. Optionally, set the Benefits node’s Max Occurs property to the unbounded value, if you have more than one occurrence of the Benefit record per member.

     

       As for the Positional schema, you can just set the Max Occurs property of the Group node to the unbounded value, and optionally, set the Max Occurs property of the Benefit node to the unbounded value, if you did the same in item 2 above.

     

       Then, in your map, you would use a looping functoid connecting the Members node (in the Xml Schema) to the Group node (in the Positional schema), and map the remaining fields. Additionally, if you used item 2 above, you would use a second-level looping functoid to connect the Benefits node (in the Xml Schema) to the Benefit node (in the Positional schema).

     

       I hope this all makes sense to you…

     

       Daniel.

     

    in reply to: Create Positional Flat File #25477

    This is very close to what I need – Thanks a bunch!

    The only issue remaining is getting it to generate multiple Member and Benefit rows in the flat file. For some reason it only spits out the first one of each. I’ve tried a number of property changes to include:

    Set the Max Occurs property to unbounded for both the Member and Benefit nodes in the PositionalFF schema.  

    Set the Group Max Occurs to unbounded on the Group Node in the PositionalFF schema.

    I’m wondering if I need to have a looping functoid to the map on these nodes.

    in reply to: Filter for Different Messages comming to a single folder #25476

    Hi,

     

       Did you take the time to read Yonathan’s post above? Here’s an MSDN article that explains how to set the filter expression in your activatable Receive shape in an orchestration:

    http://msdn.microsoft.com/en-us/library/aa560178(BTS.70).aspx

     

       Basically, if you have a Distinguished property in your incoming message’s schema (e.g. UniqueField), then you should be able to set a filter expression like the following (in the Filter Expression property of your Receive shape):

    YourMessageType.UniqueField == 1

     

       So, one of your orchestrations will have the above kind of filter expression, then for your next orchestration, you can set a filter expression something like this:

    YourMessageType.UniqueField == 2

     

    (and so on and so forth)

    etc.

     

        Is this clear enough for you?

     

        Daniel.

     

Viewing 15 posts - 751 through 765 (of 9,648 total)