Forum Replies Created
-
AuthorPosts
-
August 3, 2010 at 11:59 AM 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”
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.
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.
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
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.
Hi.
Is this error message coming up by each edifact message?
Did you generate an instance of it?
Wolfgang
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
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.
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.
August 3, 2010 at 2:56 AM in reply to: Filter for Different Messages comming to a single folder #25482Thanks 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,
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.
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_0Flat 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_0Incoming 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>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.
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.
August 2, 2010 at 9:30 AM in reply to: Filter for Different Messages comming to a single folder #25476Hi,
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.
-
AuthorPosts