message properties filter in HAT
Hi, Dear all,
Is there anyone have ever used the message properties filter drop down in HAT (When you choose find message from menu)? I enabled all the tracking on the receive port and did propmt a few properties in message. However, never seen any thing showed up in the dropdown list within that message properties filter in HAT. It is really hard for me to find the message based on a particular value for it.
Any suggestions would be very appreciated.
Thanks,
Henry
Answers
Thanks for reply.
All you said here have been done before. That's why we can find all the messages in HAT and we can saved them to the disk for viewing. However, for this particular request: "using this message properties" we have to do some more things.
As what I mentioned on my question, I have already enabled tracking on receive port, (For tracking the outbound message, send port tracking should be enabled). Message has its own prompted property.
In Biztalk 2006, you have to enable schemas level tracking for using this "message property filter" in HAT. Here is how to:
http://msdn2.microsoft.com/EN-US/library/aa578241.aspx
"After you set the tracking options for the message property, it can take a few minutes before you can view the properties" -- quote from MSDN. It depends how you set up the job to move the message from message database to the tracking database.
So in summary:
1) If you enabled the port level / orchestration / pipeline level tracking, (http://msdn2.microsoft.com/en-us/library/aa559964.aspx) then you could find the message by using HAT. However, it is so hard for you to find a particular message you want. (Notes, there are some other things like Saravan mentioned, you need to make sure sql agent is running, jobs are ok and you configura at least one host as tracking host.
2) If you enabled the message level tracking, you could query the message by using prompted properties (only the one you defined, not all the Biztalk build in one), which is super for us to do the audit and debug.
(I spend most of my time to "deal" with the thrid party softwares vendor to figure out whether or when the particular message has been delivered and process by Biztalk. I also saw lots of my clients just dumped the HAT to build their own logging mechanism for Biztalk tracking. )
I hope this article helps myself but also could bring some helps for other reviewers. :-)
All Replies
Hi henry,
Few things you have to take care while you are enabling the tracking.
Please make sure that SQL Agent is running in the Message Box.
Make sure all the jobs (which moves the message from Message Box to tracking database) is running.
Make sure that you have restarted the BizTalk?
Thanks,
Saravana Kumar
Thanks for reply.
All you said here have been done before. That's why we can find all the messages in HAT and we can saved them to the disk for viewing. However, for this particular request: "using this message properties" we have to do some more things.
As what I mentioned on my question, I have already enabled tracking on receive port, (For tracking the outbound message, send port tracking should be enabled). Message has its own prompted property.
In Biztalk 2006, you have to enable schemas level tracking for using this "message property filter" in HAT. Here is how to:
http://msdn2.microsoft.com/EN-US/library/aa578241.aspx
"After you set the tracking options for the message property, it can take a few minutes before you can view the properties" -- quote from MSDN. It depends how you set up the job to move the message from message database to the tracking database.
So in summary:
1) If you enabled the port level / orchestration / pipeline level tracking, (http://msdn2.microsoft.com/en-us/library/aa559964.aspx) then you could find the message by using HAT. However, it is so hard for you to find a particular message you want. (Notes, there are some other things like Saravan mentioned, you need to make sure sql agent is running, jobs are ok and you configura at least one host as tracking host.
2) If you enabled the message level tracking, you could query the message by using prompted properties (only the one you defined, not all the Biztalk build in one), which is super for us to do the audit and debug.
(I spend most of my time to "deal" with the thrid party softwares vendor to figure out whether or when the particular message has been delivered and process by Biztalk. I also saw lots of my clients just dumped the HAT to build their own logging mechanism for Biztalk tracking. )
I hope this article helps myself but also could bring some helps for other reviewers. :-)
Yuhang,
Not sure HAT is the good tool for audit.
BAM is the primary tool for tracking.
DebugView, test direct ports, Event Viewer are the primary debug tools (+HAT in 2004 or Hub in 2006).
For auditing we use custom logic in orchestrations and direct ports. The BAM database... not sure.
Regards,Leonid GanelinePlease correct me if I was wrong.
In my opinion, HAT is mostly used by technical guy, it does not need any extra development to be used. It is primitive tool but it could be useful if everthing can be setup properly.
BAM is a powerful tools which could be used by business users since we can setup a portal so everyone with web expolorer can use it. However it needs more extra development effort (not only configuration) and we do need to setup more database for it.
Debugview (oh, I love sysinternals) and event viewer are good tools for real time debug. However, when user is asking "Hi, Dear Biztalk guy, can you help me to look up the message I send one month ago, what happened to it?", that would be hard for using event viewer (well, you can set it up to keep one month history...)
I am not quiet sure about Microsoft strategy for these tools. So if some Microsoft guys are here and can give us a hint what is their purpose, that would be great! :-)
