Microsoft KB Archive/843331

= BUG: You receive an error in the BizTalk Administration console when you delete a MessageBox database in BizTalk Server 2006 R2, in BizTalk Server 2006, or in BizTalk Server 2004 =

Article ID: 843331

Article Last Modified on 10/25/2007

-

APPLIES TO


 * Microsoft BizTalk Server 2006 R2 Enterprise Edition
 * Microsoft BizTalk Server 2006 R2 Developer Edition
 * Microsoft BizTalk Server 2006 R2 Standard Edition
 * Microsoft BizTalk Server 2006 R2 Branch Edition
 * Microsoft BizTalk Server 2006 Enterprise Edition
 * Microsoft BizTalk Server 2006 Developer Edition
 * Microsoft BizTalk Server 2006 Standard Edition
 * Microsoft BizTalk Server 2004 Enterprise Edition
 * Microsoft BizTalk Server 2004 Developer Edition
 * Microsoft BizTalk Server 2004 Standard Edition
 * Microsoft BizTalk Server 2004 Partner Edition

-



SYMPTOMS
In Microsoft BizTalk Server 2006 R2, in Microsoft BizTalk Server 2006, or in Microsoft BizTalk Server 2004, when you delete a MessageBox database in the BizTalk Administration console, you may receive an error message that resembles one of the following:

Error message 1

MessageBox cannot be deleted since there could be remaining work in the MessageBox. Please ensure that there are no more incomplete instances in the MessageBox, and try again.

Error message 2

The MessageBox cannot be deleted because it may still contain incomplete instances. Ensure that there are no incomplete instance in the MessageBox, and try again.



CAUSE
This error may occur if the cache refresh interval has not expired after you disable the MessageBox database and before you delete the database. By default, the cache refresh interval is set to 60 seconds.



RESOLUTION
To delete a MessageBox database, you must first disable the database. Then, you must wait 60 seconds until the cache refresh interval expires before you delete the MessageBox database. To do this, follow these steps:

BizTalk Server 2006 R2 and BizTalk Server 2006

 * 1) Click Start, point to Programs, point to Microsoft BizTalk Server 2006, and then click BizTalk Server Administration.
 * 2) In the BizTalk Administration console, expand BizTalk Server 2006 Administration, expand the BizTalk group that you want, expand Platform Settings, and then click Message Boxes.
 * 3) In the right pane, right-click the message box database that you want to delete, and then click Properties.
 * 4) In the Properties dialog box, click to select the Disable new message publication check box, and then click OK.
 * 5) On the Group Hub page, verify that there are no dehydrated or suspended instances in the MessageBox database that you want to delete.
 * 6) Wait for a period of time that is equal to twice the interval that is configured in the CacheRefreshInterval value in the Windows Registry.
 * 7) Right-click the MessageBox database that you want to delete, click Delete, and then click OK.
 * 8) In the BizTalk Administration console, expand BizTalk Server 2006 Administration, expand the BizTalk group that you want, expand Platform Settings, and then click Host Instances.
 * 9) In the right pane, right-click each host instance that is running, and then click Restart.
 * 10) On the SQL Server server that hosts the MessageBox database, delete the database.

BizTalk Server 2004

 * 1) Click Start, point to Programs, point to Microsoft BizTalk Server 2004, and then click BizTalk Server Administration.
 * 2) In the BizTalk Administration console, expand Microsoft BizTalk Server 2004 (local), and then click MessageBoxes.
 * 3) In the right pane, right-click the MessageBox database that you want to delete, and then click Properties.
 * 4) In the Properties dialog box, click to select the Disable new message publication check box, and then click OK.
 * 5) Wait 60 seconds.
 * 6) Right-click the MessageBox database, and then click Delete.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Keywords: kbbug kbfix kbbtsmessaging kbbiztalk2004-2006swept KB843331

-

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

© Microsoft Corporation. All rights reserved.