|
Home > Archive > BizTalk Server General > July 2005 > Quick Question
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]
|
|
| Just Me 2005-07-28, 7:49 am |
| How do I remove all previous messages and instances of orchestrations from
BizTalk 2004? For instance lets assume that messages and even the
orchestrations that processed them had errors in them. I fix the problem
but some old messages are still in the message box, how to get rid of them?
Thanks.
| |
| Tomas Restrepo \(MVP\) 2005-07-28, 5:52 pm |
| > How do I remove all previous messages and instances of orchestrations from
> BizTalk 2004? For instance lets assume that messages and even the
> orchestrations that processed them had errors in them. I fix the problem
> but some old messages are still in the message box, how to get rid of
> them? Thanks.
You need to use HAT to terminate those instances. The bad news is that with
HAT, you need to do it one at a time, so it is a slow process. The other
option is to create a WMI script that those it in a more automated way.
There's also this:
http://blogs.msdn.com/biztalk_core_.../09/390996.aspx but
this is only for test environments and you should NEVER run it in a
production machine, ever.
--
Tomas Restrepo
tomasr@mvps.org
http://www.winterdom.com/
| |
| Scott Colestock 2005-07-28, 5:52 pm |
| Hmm, I haven't had trouble doing a "drag-select" in HAT and terminating
multiple message instances at a time.
Scott Colestock
www.traceofthought.net
"Tomas Restrepo (MVP)" <tomasr@mvps.org> wrote in message
news:%23tAX0Z4kFHA.1464@TK2MSFTNGP14.phx.gbl...
>
> You need to use HAT to terminate those instances. The bad news is that
> with HAT, you need to do it one at a time, so it is a slow process. The
> other option is to create a WMI script that those it in a more automated
> way.
>
> There's also this:
> http://blogs.msdn.com/biztalk_core_.../09/390996.aspx
> but this is only for test environments and you should NEVER run it in a
> production machine, ever.
>
>
> --
> Tomas Restrepo
> tomasr@mvps.org
> http://www.winterdom.com/
>
| |
| Tomas Restrepo \(MVP\) 2005-07-28, 5:52 pm |
| Hi Scott,
> Hmm, I haven't had trouble doing a "drag-select" in HAT and terminating
> multiple message instances at a time.
hummm... true. Then why couldn't I get it to work a few days ago I tried?
must be silly old me doing it wrong 
--
Tomas Restrepo
tomasr@mvps.org
http://www.winterdom.com/
| |
| Marvin Smit 2005-07-29, 8:03 am |
| Hi Tomas,
it's "where you click" in the list that allows single or multi-select.
It's not the default "Shift-Click" or "CTRL-Click" we're used to. But
it does work.
Marvin Smit
On Thu, 28 Jul 2005 10:45:11 -0500, "Tomas Restrepo \(MVP\)"
<tomasr@mvps.org> wrote:
>Hi Scott,
>
>
>hummm... true. Then why couldn't I get it to work a few days ago I tried?
>must be silly old me doing it wrong
| |
|
| Hi,
You can clean out the message box.Not adviced on production
In the <install dir>\schema directory you will find a file called
msgbox_cleanup_logic.sql (it is installed with SP1). This file contains the
definition for a stored procedure called bts_CleanupMsgbox. By default, this
stored procedure exists in your msgbox except that the default implementation
is empty so it does nothing. To use this script first run the .sql file
against all msgboxes using Query Analyzer. This will simply create the stored
procedure. It won't actually do anything to your box as far as cleanup goes
Then follow the steps below.
Stop BTS.
Do IISRESET to recycle your IIS.
Run "exec bts_CleanupMsgbox" on your message box database. This will mark
your instances for deletion and it will not actually delete it.
Run "exec bts_PurgeSubscriptions" on your message box database. This will
purge all your messages marked for deletion.
Restart your BTS.
"Marvin Smit" wrote:
> Hi Tomas,
>
> it's "where you click" in the list that allows single or multi-select.
> It's not the default "Shift-Click" or "CTRL-Click" we're used to. But
> it does work.
>
> Marvin Smit
>
> On Thu, 28 Jul 2005 10:45:11 -0500, "Tomas Restrepo \(MVP\)"
> <tomasr@mvps.org> wrote:
>
>
>
|
|
|
|
|