BizTalk DB Maintenence
Web Server forum
Back To The Forum Home!Search!Private Messaging System

Web Server Talk Web Server Talk > Web Servers reviews > BizTalk Server > BizTalk Server Administration > BizTalk DB Maintenence




  Last Thread   Next Thread Next
  Show Printable Version Email this Page Subscribe to this Thread      Post New Thread    Post A Reply      

    BizTalk DB Maintenence  
Devdutt Patnaik


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
10-07-04 04:19 PM

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








[ Post a follow-up to this message ]



    Re: BizTalk DB Maintenence  
Niklas E


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
10-28-04 10: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] 
>
>
>







[ Post a follow-up to this message ]



    Re: BizTalk DB Maintenence  
Vladimir Pogrebinsky


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
10-28-04 10: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] 






[ Post a follow-up to this message ]



    Sponsored Links  




 





   All times are GMT. The time now is 12:20 PM.      Post New Thread    Post A Reply      
  Last Thread   Next Thread Next


Most Popular forums 

Forum Jump:
Rate This Thread:

Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is OFF
vB code is ON
Smilies are ON
[IMG] code is OFF
 
Medical and Health forum | Computer Games Reviews | Graphics design forum

Back To The Top
Home | Usercp | Faq | Register