Microsoft KB Archive/321950

= Fix: Receive Functions Cannot Recover from SQL Failover =

Article ID: 321950

Article Last Modified on 11/15/2007

-

APPLIES TO


 * Microsoft BizTalk Server 2002 Standard Edition

-



This article was previously published under Q321950



SYMPTOMS
If you set up a BizTalk server as a receive-only server, and the computer that is running Microsoft SQL Server for the BizTalk server fails, the receive functions of BizTalk server may stop responding even after you restart the computer that is running SQL Server.



CAUSE
The receive-only server does not have a refresh thread to monitor SQL Server failures; therefore, the BizTalk server does not restart the BizTalk Messaging Service when the SQL server restarts.



Service Pack Information
To resolve this problem, obtain the latest service pack for Microsoft BizTalk Server 2002. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

815781 How to Obtain the Latest BizTalk Server 2002 Service Pack

Hotfix Information
A supported hotfix is now available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing this specific problem. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next service pack that contains this hotfix.

To resolve this problem, submit a request to Microsoft Online Customer Services to obtain the hotfix. To submit an online request to obtain the hotfix, visit the following Microsoft Web site:

http://go.microsoft.com/?linkid=6294451

Note If additional issues occur or any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. To create a separate service request, visit the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=support

The English version of this fix should have the following file attributes or later:

  Date         Time   Version      Size      File name -  Apr-29-2002  14:22  3.0.1512.0   508,176   Ciscore.dll Apr-29-2002 14:22  3.0.1512.0   401,680   Cisengine.dll Apr-29-2002 14:22  3.0.1512.0   327,952   Mscis.exe Apr-11-2002  9:41                13,680   BTM_priorityUpgrade.sql Apr-11-2002  9:41                19,632   SQ_PriorityUpgrade.sql

To apply the fix, follow these steps:
 * 1) Stop the BizTalk Messaging Service.
 * 2) Apply the new .dll files and the new .exe file to the Biztalk Server 2002 installation directory.
 * 3) Use the SQL Query Analyzer to apply BTM_PriorityUpgrade.sql to the InterchangeBTM database.
 * 4) Use the SQL Query Analyzer to apply SQ_PriorityUpgrade.sql to the InterchangeSQ database.
 * 5) Start the BizTalk Messaging Service.

All servers that share the database must be upgraded. Any servers with the old files fail to start after the InterchangeBTM and InterchangeSQ databases have been updated.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

This problem was first corrected in Microsoft BizTalk Server 2002 Service Pack 1.

Keywords: kbhotfixserver kbqfe kbbiztalk2002sp1fix kbbug kbfix KB321950

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.