|
Home > Archive > BizTalk Server > June 2004 > BizTalk 2004 issue when MessageBoxDB goes down
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 2004 issue when MessageBoxDB goes down
|
|
|
| I have a complicated system with 10 servers. 4 are running
as a cluster with 3 instances of SQL 2000 Enterprise
server. One instance runs the MessageBoxDB, One runs SSODB
and ManagementDBs and the third runs the Tracking and BAM
databases.
If the MessageBoxDB SQL server goes down and up all seems
to stop. The Receive locations become disabled and a
message gets put into the event log saying they will be
restarted when the messageboxDB comes back up again.
Well, this doesn't happen and they have to be restarted
manually. This still doesn't get the Biztalk servers
working properly. Seems a bit of voodoo is needed as well
as a restart. If I refresh the send and receive locations
for all the protocols in the Admin program then sometimes
our processes work. Only an eventual restart of all 6
Biztalk servers gets the whole thing going again.
Does anyone know what could be happening and how we can
get the receive locations to come back on line?
Many thanks in advance
Clive
| |
| Michael Roze [MSFTF] 2004-06-04, 11:56 pm |
| By design, the BizTalk Service [BTSNTSvc.exe] will shutdown in the event of
SQL connection failure.
The service will then attempt to automatically re-start 60 seconds later.
However, when the database is inaccessable, the Receive Locations should
not get disabled.
The Receive Location can get disabled if the location is on a remote drive
that is inaccessable due to network failures.
The Receive Location status [saved in the database] if disabled will not be
automatically re-enabled.
The reason for this is so that, if an administrator wishes to stop
receiving messages, the location should not auto-restart.
Thanks,
MRoze
This posting is provided "AS IS" with no warranties, and confers no rights.
EBusiness Server Team
[vbcol=seagreen]
|
|
|
|
|