Microsoft KB Archive/891734

= 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 =

Article ID: 891734

Article Last Modified on 8/28/2007

-

APPLIES TO


 * Microsoft BizTalk Server 2004 Developer Edition
 * Microsoft BizTalk Server 2004 Enterprise Edition
 * Microsoft BizTalk Server 2004 Partner Edition
 * Microsoft BizTalk Server 2004 Standard Edition

-





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:

Time:

User: N/A

Computer:

Description: The following stored procedure call failed: &quot; { call [dbo].[bts_UpdateMsgbox_BizTalkServerApplication]( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}&quot;. SQL Server returned error string: &quot;Connection failure&quot;.





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:
 * 1) 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.
 * 2) Open an existing BizTalk Server 2004 project.
 * 3) In the BizTalk Server 2004 project, click BizTalk Explorer on the View menu.
 * 4) 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.
 * 5) In the Receive Location Properties - Configuration - General dialog box, click the ellipsis (...) that corresponds to Address URI.
 * 6) 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.

Additional query words: BizTalk BTS

Keywords: kbtshoot kbprb kbbtsorchestration kbbtsadapters KB891734

-

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

© Microsoft Corporation. All rights reserved.