|
Home > Archive > BizTalk Server General > September 2004 > Suspended messages in BTS2004
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Suspended messages in BTS2004
|
|
| Birgitta 2004-09-22, 9:53 pm |
| We're abuot to upgrade from BTS2000 to BTS2004.
We have a small app which we have written ourselves, it reads all suspended
messages from the SQL table cs_SuspendedQ and notifies the operator by email.
Now I need to know if this table exists in BTS2004 and under what name? Is
there any otherway you can get failed messages etc from the database?
| |
| Jack Blalock 2004-09-22, 9:53 pm |
| First of all, know that there is no "upgrade" to 2004. There are pieces
that can be migrated however..a good starting point is:
http://msdn.microsoft.com/library/d...-us/migration/h
tm/ebiz_migration_bkdz.asp
In 2004 there is no Suspended queue in an MMC console nor does this table
exist, product is totally rearchitected. There is a tool included called
Health and Activity Tracking (HAT) that lets you query on messages that are
suspended, etc.
Hope this helps...
Jack Blalock [MSFT]
This posting is provided "AS IS", with no warranties, and confers no rights.
| |
| Todd Sussman 2004-09-22, 9:53 pm |
| If you go to GotDotNet.com, someone wrote a SuspendedQ listener. It is a
service, that uses WMI to listen for suspended messages.
Todd
"Jack Blalock" <jackbl@online.microsoft.com> wrote in message
news:P2dPZrKoEHA.2864@cpmsftngxa06.phx.gbl...
> First of all, know that there is no "upgrade" to 2004. There are pieces
> that can be migrated however..a good starting point is:
>
> http://msdn.microsoft.com/library/d...-us/migration/h
> tm/ebiz_migration_bkdz.asp
>
> In 2004 there is no Suspended queue in an MMC console nor does this table
> exist, product is totally rearchitected. There is a tool included called
> Health and Activity Tracking (HAT) that lets you query on messages that
> are
> suspended, etc.
>
> Hope this helps...
>
> Jack Blalock [MSFT]
> This posting is provided "AS IS", with no warranties, and confers no
> rights.
>
| |
| Devdutt Patnaik 2004-09-23, 5:51 pm |
| The tables you are looking for are:
BizTalkServerApplicationQ_Suspended
and
BizTalkServerIsolatedHostQ_Suspended
tables in the BizTalkMsgBoxDb.
These tables map to more tables like MessageParts, which maps to Parts etc.
Having said that I cannot see how you would actually reassemble the message
easily.
The best course would be to use Martinjn's suspended queue windows service,
which employs WMI:
http://martijnh.blogspot.com/2004_0...nh_archive.html
If you want interception of error messages originating from BizTalk and
being written into the Event Log, I have posted code for a Windows service
which does that (WMI again), on my blog:
http://devdutt10.blogspot.com/2004/...ption-with.html
HTH
Regards
Dev
"Birgitta" <Birgitta@discussions.microsoft.com> wrote in message
news:33B7A477-713E-477C-B2E3-4713C3ABD30A@microsoft.com...
> We're abuot to upgrade from BTS2000 to BTS2004.
> We have a small app which we have written ourselves, it reads all
suspended
> messages from the SQL table cs_SuspendedQ and notifies the operator by
email.
> Now I need to know if this table exists in BTS2004 and under what name? Is
> there any otherway you can get failed messages etc from the database?
>
|
|
|
|
|