FIX: Database Lock Occurs When Edifact Output Is Generated

This article was previously published under Q300894
This article has been archived. It is offered "as is" and will no longer be updated.
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.
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 theMicrosoft Knowledge Base:
299664 INFO: How to Obtain the Latest BizTalk Server 2000 Service Pack
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.
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.


Article ID: 300894 - Last Review: 01/17/2015 16:27:55 - Revision: 4.1

Microsoft BizTalk Server 2000 Service Pack 1

  • kbnosurvey kbarchive kbbiztalk2000sp1afix kbbug kbfix KB300894