|
Home > Archive > BizTalk Server Administration > October 2004 > BizTalk DB Maintenence
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 |
BizTalk DB Maintenence
|
|
| Devdutt Patnaik 2004-10-07, 11:19 am |
| Is there any way to remove "Delivered but not consumed" messages from the
message box and also services referencing them through scripts (SQL or WMI).
Not through HAT.
Alternatively is there a script out there that just wipes everything from
the MessageBox DB.
Help is urgently reqd.
Regards
Dev
| |
| Niklas E 2004-10-28, 5:48 pm |
| Seems nice, but it didn't work for me. On line 105:
objQueue.TerminateServiceInstancesByID aryClassIDs, aryTypeIDs,
aryInstanceIDs
it stops with the following error:
The parameter is incorrect
80070057
SWbemOjbectEx
Any ideas?
Best regards
Niklas E
"btsuser" <spam@btsuser.com> wrote in message
news:OAbit92rEHA.1816@TK2MSFTNGP09.phx.gbl...
> Attached script will allow terminate instances based on serviceclass and
> service status. With regards to wiping entire messagebox, log a support
call
> with MS or wait for SP1 (info provided as per previous posting)
>
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxx
>
> "Devdutt Patnaik" <aquarius@taurus.com> wrote in message
> news:uqbvCwHrEHA.3608@TK2MSFTNGP14.phx.gbl...
the[vbcol=seagreen]
from[vbcol=seagreen]
>
>
>
| |
| Vladimir Pogrebinsky 2004-10-28, 5:48 pm |
| I think the issue here is with number of isntances you try to terminate.
There is a 2K limit.
You need to modify the script to make sure you don't attempt to terminate
more then 2047 instances at a time.
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------[vbcol=seagreen]
<OAbit92rEHA.1816@TK2MSFTNGP09.phx.gbl>[vbcol=seagreen]
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGP08
.phx.gbl!TK2MSFTNGP14.phx.gbl[vbcol=seagreen]
|
|
|
|
|