BUG: The tracking table is not updated, and you do not receive an error message to indicate that the tracking table has not been updated in BizTalk Server 2004 (888753)


The information in this article applies to:

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

SYMPTOMS

In Microsoft BizTalk Server 2004, the Host Tracking option is updated after you change the Host Tracking check box for the BizTalkDTADb tracking database. However, the BizTalk tracking table is not updated, and you do not receive an error message to indicate that the tracking table has not been updated. This problem occurs when you click to select or you click to clear the Host Tracking check box

Therefore, you may not notice that the tracking table is no longer synchronized.

CAUSE

This problem occurs if you do not have the db_securityadmin role for the BizTalkDTADb database.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.

WORKAROUND

To work around this problem, grant the db_securityadmin role to the user for the BizTalkDTADb database. To do this, follow these steps:
  1. Click Start, point to All Programs, point to Microsoft SQL Server, and then click Enterprise Manager.
  2. In SQL Server Enterprise Manager, expand Microsoft SQL Servers, expand SQL Server Group, and then expand Server_Name.

    In this step, replace Server_Name with the name of the computer that is running the instance of Microsoft SQL Server 2000 where the BizTalkDTADb database is located.
  3. Expand Security, and then click Logins.
  4. Right-click the user who you want to give the db_securityadmin server role to, and then click Properties.
  5. In the SQL Server Login Properties dialog box, click the Database Access tab. Then, click to select the Permit check box that corresponds to the BizTalkDTADb database.
  6. In the Database roles for 'BizTalkDTADb' list, click to select the db_securityadmin check box, and then click OK.
Modification Type:MajorLast Reviewed:3/4/2005
Keywords:kbpending kbtshoot kbbug KB888753 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.