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?

[ Post a follow-up to this message ]

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.

[ Post a follow-up to this message ]

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:
>
> [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/migration/h[/ur
l]
> 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.
>

[ Post a follow-up to this message ]

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:
[url]http://devdutt10.blogspot.com/2004/08/event-log-message-interception-with.html[/ur
l]

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?
>

[ Post a follow-up to this message ]