BUG: You receive an error in the BizTalk Administration console when you delete a MessageBox database in BizTalk Server 2006 or BizTalk Server 2004 (843331)


The information in this article applies to:

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

  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 "Applies to" section.
Modification Type:MajorLast Reviewed:6/26/2006
Keywords:kbbiztalk2004-2006swept kbfix kbBug kbBTSMessaging KB843331 kbAudDeveloper kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.