FIX: Database Lock Occurs When Edifact Output Is Generated

Article translations Article translations
Article ID: 300894 - View products that this article applies to.
This article was previously published under Q300894
Expand all | Collapse all

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.

Properties

Article ID: 300894 - Last Review: April 9, 2004 - Revision: 4.1
APPLIES TO
  • Microsoft BizTalk Server 2000 Service Pack 1
Keywords: 
kbbiztalk2000sp1afix kbbug kbfix KB300894

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com