BizTalk Server may stop responding, and Event ID 6912 may be logged in the Application log when you run a BizTalk orchestration in BizTalk Server 2004 (891734)

SYMPTOMS

When you run a BizTalk orchestration in Microsoft BizTalk Server 2004, you may experience one of the following symptoms:

BizTalk Server 2004 stops responding.
The following error event is logged in the Application log:
Event Type: Error
Event Source: BizTalk Server 2004
Event Category: BizTalk Server 2004
Event ID: 6912
Date: Date
Time: Time
User: N/A
Computer: ComputerName
Description: The following stored procedure call failed: " { call [dbo].[bts_UpdateMsgbox_BizTalkServerApplication]( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}". SQL Server returned error string: "Connection failure".

CAUSE

This problem may occur if the following conditions are all true:

The BizTalk orchestration is bound to a receive port.
That receive port is bound to the BizTalk Server File adapter.
The BatchSize value for the BizTalk File adapter is set to a value other than 1.

If the BatchSize value for the BizTalk File adapter is set to a value other than 1, a blocking problem may occur on the computer that is running Microsoft SQL Server 2000 where the BizTalk Server 2004 database is stored.

RESOLUTION

To resolve this problem, set the BatchSize value for the BizTalk file adapter to 1.

Note The BatchSize value represents the maximum number of messages that are received on each thread before BizTalk Server 2004 processes the message interchange.

To set this value, follow these steps:

Start Microsoft Visual Studio .NET 2003. To do this, click Start, point to All Programs, point to Microsoft Visual Studio .NET 2003, and then click Microsoft Visual Studio .NET 2003.
Open an existing BizTalk Server 2004 project.
In the BizTalk Server 2004 project, click BizTalk Explorer on the View menu.
Expand BizTalkMgmtDb.dbo, expand Receive Ports, expand the receive port for this project, expand Receive Locations, expand the receive location for this project, right-click the receive location, and then click Edit.
In the Receive Location Properties - Configuration - General dialog box, click the ellipsis (...) that corresponds to Address URI.
In the File Transport Properties dialog box, set the Batchsize value to 1, and then click OK two times.

Note By default, the Batchsize value for the file adapter is set to 20.

MORE INFORMATION

For additional information about the performance characteristics of some BizTalk Server 2004 configurations and components, visit the following Microsoft Web site:

http://www.gotdotnet.com/team/wsservers/bts2004/BTS2004Performance.zip