Microsoft KB Archive/875497

= FIX: Processing seems to stop when you use ordered delivery ports, and you have an increased load of messages in Microsoft BizTalk Server 2004 =

Article ID: 875497

Article Last Modified on 6/1/2006

-

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 use ordered delivery ports, you may notice that processing seems to stop when you have an increased load of messages. There are no errors that appear in the event log. This problem occurs in a Microsoft BizTalk Server 2004 solution.

If you review the SQL Profiler trace of your message box database, you notice high latency in the execution time of the stored procedures that are responsible for dequeuing messages. These stored procedures are named &quot;bts_DeQueueMessages_ .&quot; The placeholder  is the name of your BizTalk Host Application.



Service pack information
To resolve this problem, obtain the latest service pack for Microsoft BizTalk Server 2004. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

888751 How to obtain the latest BizTalk Server 2004 service pack

Hotfix information
The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in coordinated universal time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.

  Date         Time                      Size    File name --  30-Jul-2004  01:46                    381,802  Msgbox_application_logic.sql



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section. This problem was corrected in BizTalk Server 2004 Service Pack 1.



MORE INFORMATION
This hotfix modifies new message boxes that you create. Message boxes that already exist in the message box database remain unmodified.

Install this hotfix. Then, to apply this hotfix to message boxes that already exist in the message box database, follow these steps:
 * 1) Start SQL Query Analyzer. Connect to your message box database.

By default, your message box database is named BizTalkMsgBoxDb.
 * 1) Open the updated SQL script at the following location:

\Program files\Microsoft BizTalk Server 2004\Schema\Msgbox_application_logic.sql
 * 1) Run the updated SQL script.
 * 2) Repeat steps 1 through 3 for each message box database that you have in your BizTalk Server 2004 solution.

When you run the updated SQL script, you may receive any one of the following warning messages in the Output window of SQL Query Analyzer. These warnings are not problems and can be ignored.
 * Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'int_AddApplicationSprocs'. The stored procedure will still be created.
 * Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'int_RemoveApplicationSprocs'. The stored procedure will still be created.
 * Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'dbo.int_GetInstanceLock_BizTalkServerApplication'. The stored procedure will still be created.
 * Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'dbo.int_AdminResumeInstance_BizTalkServerApplication'. The stored procedure will still be created.
 * Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'dbo.int_AdminSuspendInstance_BizTalkServerApplication'. The stored procedure will still be created.
 * Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'dbo.int_AdminTerminateInstance_BizTalkServerApplication'. The stored procedure will still be created.
 * Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'dbo.int_ProcessCleanup_BizTalkServerApplication'. The stored procedure will still be created.
 * Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'dbo.int_AdminResumeInstance_BizTalkServerApplication'. The stored procedure will still be created.
 * Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'dbo.int_GetInstanceLock_BizTalkServerIsolatedHost'. The stored procedure will still be created.
 * Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'dbo.int_AdminResumeInstance_BizTalkServerIsolatedHost'. The stored procedure will still be created.
 * Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'dbo.int_AdminSuspendInstance_BizTalkServerIsolatedHost'. The stored procedure will still be created.
 * Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'dbo.int_AdminTerminateInstance_BizTalkServerIsolatedHost'. The stored procedure will still be created.
 * Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'dbo.int_ProcessCleanup_BizTalkServerIsolatedHost'. The stored procedure will still be created.
 * Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'dbo.int_AdminResumeInstance_BizTalkServerIsolatedHost'. The stored procedure will still be created.

For additional information about performance issues in BizTalk Server 2004, click the following article number to view the article in the Microsoft Knowledge Base:

834624 A list of known issues in BizTalk Server 2004

Keywords: kbtshoot kbbug kbfix kbqfe kbbtsmessaging kbbiztalk2004sp1fix kbhotfixserver KB875497

-

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

© Microsoft Corporation. All rights reserved.