FIX: Database Lock Occurs When Edifact Output Is Generated

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 the Microsoft Knowledge Base:

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.