How can I query Tracked data including promoted properties?

[Mikael Håkansson]

I have a property schema with some properties (all set to
MessageContextPropertyBase). I then use a pipeline component where I set
these proprties using inmsg.Context.Promote(...). The promoted properties are
visible through the BizTalk Console, but not in HAT. I can't even select my
property schema in the Reports/Find message dialog in HAT(?).

When viewing the Message Flow, and saving it to disk, the properties are
visible.

At the end of the day, I would like to show a end-user report of all
messages included with these message properties.

[Jan Eliasen]

On Tue, 21 Aug 2007 13:48:01 -0700, Mikael Håkansson

Post by Mikael HÃ¥kansson
I have a property schema with some properties (all set to
MessageContextPropertyBase). I then use a pipeline component where I set
these proprties using inmsg.Context.Promote(...). The promoted properties are
visible through the BizTalk Console, but not in HAT. I can't even select my
property schema in the Reports/Find message dialog in HAT(?).

You are not supposed to find your property schema, you are supposed to
find the schema from which you have promoted some properties.

Post by Mikael HÃ¥kansson
When viewing the Message Flow, and saving it to disk, the properties are
visible.

First step complete :-)

Post by Mikael HÃ¥kansson
At the end of the day, I would like to show a end-user report of all
messages included with these message properties.

In order to use the properties in the Find message reporting window,
you need to enable tracking on the relevant ports, and you need to go
into BizTalk Server Administration and go to the application, in which
you want to track them. Then go to the schema you want to track
properties from, and right click it and choose properties. In here you
can select which of the promoted properties you want to track, so that
they can be used in the filter in HAT. Wait up til 60 seconds or
restart the host instance.

Should work now.

[Mikael Håkansson]

Thanks (but...),
Since I don't have a schema (Passthrough) other than my property schema,
I've selected the property schema and chacked the properties to track. And I
guess they are tracked since they are visible when saving the message to
disk. But where are they stored in the database???

Post by Jan Eliasen
You are not supposed to find your property schema

WHY NOT? Why else would I want to track them if I can't filter then (there
is a separate dialog for tracking property schemas).

Post by Jan Eliasen
On Tue, 21 Aug 2007 13:48:01 -0700, Mikael Håkansson

Post by Mikael HÃ¥kansson
I have a property schema with some properties (all set to
MessageContextPropertyBase). I then use a pipeline component where I set
these proprties using inmsg.Context.Promote(...). The promoted properties are
visible through the BizTalk Console, but not in HAT. I can't even select my
property schema in the Reports/Find message dialog in HAT(?).

You are not supposed to find your property schema, you are supposed to
find the schema from which you have promoted some properties.

Post by Mikael HÃ¥kansson
When viewing the Message Flow, and saving it to disk, the properties are
visible.

First step complete :-)

Post by Mikael HÃ¥kansson
At the end of the day, I would like to show a end-user report of all
messages included with these message properties.

In order to use the properties in the Find message reporting window,
you need to enable tracking on the relevant ports, and you need to go
into BizTalk Server Administration and go to the application, in which
you want to track them. Then go to the schema you want to track
properties from, and right click it and choose properties. In here you
can select which of the promoted properties you want to track, so that
they can be used in the filter in HAT. Wait up til 60 seconds or
restart the host instance.
Should work now.
--
eliasen, representing himself and not the company he works for.
Private blog: http://blog.eliasen.dk

[Jan Eliasen]

On Wed, 22 Aug 2007 15:46:01 -0700, Mikael Håkansson

Post by Mikael HÃ¥kansson
Since I don't have a schema (Passthrough) other than my property schema,
I've selected the property schema and chacked the properties to track. And I
guess they are tracked since they are visible when saving the message to
disk. But where are they stored in the database???

I don't know where they are stored in the database. And finding out
and depending on it may be dangerous, since the database model can be
changed in the next service pack.

Post by Mikael HÃ¥kansson

Post by Jan Eliasen
You are not supposed to find your property schema

WHY NOT? Why else would I want to track them if I can't filter then (there
is a separate dialog for tracking property schemas).

Because you choose the schema that has elements promoted into the
property schema. And then you can get all the Orders that had
orderamount > 10000 or something, if orderamount is a promoted field
that is tracked. And the reason for you to be able to turn on tracking
of promoted properties is that if you only need the body and not the
properties, then you save disc space in the tracking database.