Microsoft KB Archive/300894

= FIX: Database Lock Occurs When Edifact Output Is Generated =

Article ID: 300894

Article Last Modified on 4/9/2004

-

APPLIES TO


 * Microsoft BizTalk Server 2000 Service Pack 1

-



This article was previously published under Q300894



SYMPTOMS
When you configure Microsoft BizTalk Server 2000 with four or more worker threads, a Key Exclusive lock may occur on the BizTalk SQL Server database, InterchangeBTM. This lock does not occur if the number of worker threads is set to 1. No associated error is reported in the Event Viewer.



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

299664 INFO: How to Obtain the Latest BizTalk Server 2000 Service Pack



STATUS
Microsoft has confirmed that this is a problem in BizTalk Server 2000. This problem was first corrected in Microsoft BizTalk Server 2000 Service Pack 1a.



MORE INFORMATION
To configure the number of worker threads used by BizTalk Server:
 * 1) Click the Start button, point to Programs, click Microsoft BizTalk Server 2000, and then click BizTalk Server Administration.
 * 2) Expand the Microsoft BizTalk Server 2000 snap-in and the BizTalk Server Group icon so that the BizTalk Server icon is visible.
 * 3) Right-click the BizTalk Server icon, and then click Properties.
 * 4) In the Maximum number of worker threads per processor allowed box, enter a number between 1 and 128.

Keywords: kbbug kbfix kbbiztalk2000sp1afix KB300894

-

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

© Microsoft Corporation. All rights reserved.