RE: Health activity tracking tool timing out
- From: IvanJo <ivan.jocic@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 28 Sep 2008 07:50:47 +0200
In article <78A89D93-F4C1-4194-891C-9CE0D4911E89@xxxxxxxxxxxxx>,
biztalk2006@xxxxxxxxxxxxxxxxxxxxxxxxx says...>
Thanks for the replies. Yes, tracking is enabled for the host instance. All
the jobs that come up with biztalk installation are up and running.Do you
know of anyother way of solving this?
"IvanJo" wrote:
Hi,
I would be checking following:
1. Do you have any TrackingHost enabled. At least one BizTalk HostInstance
should be enabled to act as a Tracking Host. This helps in flagging messages
from MessageBox as being consumed and ready for eviction.
2. SQL scheduled jobs by BizTalk installation are up and running. There
are several jobs that should be running every minute. Those are essential for
deletion and moving messages from MessageBox towards DTADB.
To me it seems that your MessageBox is hevily impacted.
--
There are additional two ways of deleting all of those instances:
1. Using VBScript located here: http://technet.microsoft.com/en-
us/library/bb203857.aspx
2. Follows the second way:
Attention this will delete all of existing message instances (active and
non):
0. install script msgbox_cleanup_logic.sql found in BizTalk installation
Schemas directory
1. stop Enterprise SSO (which will stop all BizTalk Host Instances on
that
computer)
2. stop IIS
3. do this for all of your BizTalk group servers
4. on SQL Box MessageBox database run:
bts_CleanupMsgbox
bts_PurgeSubscriptions
5. Start IIS, and BizTalk hosts
With the first one you can filter out all running instances so you have
more control on what's being deleted although this can take for hours to
complete. The second one puts the messagebox in "just installed" state.
I would reccomend that you check un on your business process since you
claim that all SQL scripts are running fine and you have a TrackingHost
enabled but you have very big MessageBox. Can you tell me the size of
data/transaction part of it and eventually space free?
--
Ivan Jocic
blog: http://biztalkia.com/blogs/IvanJo
.
- References:
- Health activity tracking tool timing out
- From: biztalk2006
- RE: Health activity tracking tool timing out
- From: IvanJo
- RE: Health activity tracking tool timing out
- From: biztalk2006
- Health activity tracking tool timing out
- Prev by Date: RE: Health activity tracking tool timing out
- Next by Date: Re: Health activity tracking tool timing out
- Previous by thread: RE: Health activity tracking tool timing out
- Next by thread: Re: Health activity tracking tool timing out
- Index(es):
Relevant Pages
|
Loading
