Article ID: 940519 - View products that this article applies to.
This article describes the known issues in Microsoft BizTalk Server 2004 Service Pack 2 (SP2) that are not documented in the ReadmeSP2.htm file.
Issue 1: The BizTalk Server 2004 SP2 installation appears to stop responding when you clear the BizTalk Tracking databaseWhen you install BizTalk Server 2004 SP2, a dialog box displays the number of rows that will be processed when you clear the BizTalk Tracking database (BizTalkDTADb). After you click Continue, the status of the installation is not updated until the BizTalk Tracking database is completely cleared. The clearing process may take several hours if one or more of the following conditions are true:
Method 1: Reduce the size of the BizTalk Tracking database before you install BizTalk Server 2004 SP2If the BizTalk Tracking database is very large, consider running the dtasp_PruneTrackingdatabase stored procedure before you install BizTalk Server 2004 SP2. For more information about the pre-BizTalk Server 2004 SP2 version of the dtasp_PruneTrackingdatabase stored procedure, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/894253/ )FIX: The dtasp_PruneTrackingdatabase() stored procedure may take many hours to clean up the DTA database in BizTalk Server 2004
Method 2: Stop all the instances of adapter handlers that are running under isolated hostsTo reduce the time that is required to clear the tracking data from the BizTalk Tracking database, stop all the instances of adapter handlers that are running under isolated hosts in the BizTalk Server 2004 environment. For example, stop the following instances:
Issue 2: The BizTalk Server 2004 databases and the SQL Server Agent jobs are not restored when you uninstall BizTalk Server 2004 SP2When you uninstall BizTalk Server 2004 SP2, the BizTalk Server 2004 SP2 binaries are removed. Additionally, the Microsoft BizTalk Server 2004 Service Pack 1 (SP1) binaries are restored as expected. However, BizTalk Server 2004 SP2 includes significant database schema changes. When you uninstall BizTalk Server 2004 SP2, the BizTalk Server 2004 databases are not restored to the BizTalk Server 2004 SP1 state. Additionally, when you uninstall BizTalk Server 2004 SP2, the SQL Server Agent jobs are not restored to the state that existed before you installed BizTalk Server 2004 SP2.
To make sure that BizTalk Server 2004 works as expected when you uninstall BizTalk Server 2004 SP2, follow these steps:
Contact us for more help
Connect with Answer Desk for expert help.