How to remove Microsoft BizTalk Server 2004 Rollup Package 1 (837725)



The information in this article 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

INTRODUCTION

This article describes how to remove Microsoft BizTalk Server 2004 Rollup Package 1 from your computer.

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

837168 List of fixes that are included in BizTalk Server 2004 Rollup Package 1

MORE INFORMATION

To remove Microsoft BizTalk Server 2004 Rollup Package 1 from your computer, follow these steps:
  1. Click Start, point to Settings, and then click Control Panel.
  2. In Control Panel, double-click Add or Remove Programs.
  3. Under Currently installed programs, click Microsoft BizTalk Server 2004 Hotfix [See KB article 837168 for detail], and then click Remove.
  4. In the confirmation message box, click Yes.
  5. Open a Microsoft Visual Studio .NET Command Prompt window. To do this, click Start, point to Programs, point to Microsoft Visual Studio .NET, point to Visual Studio .NET Tools, and then click Visual Studio .NET Command Prompt.
  6. At the Visual Studio .NET command prompt, type the following commands to reinstall the specified assemblies in the global assembly cache. Press ENTER after you type each command.

    gacutil /if "C:\Program Files\Microsoft BizTalk Server 2004\Tracking\Microsoft.BizTalk.Bam.EventBus.dll"

    gacutil /if "C:\Program Files\Microsoft BizTalk Server 2004\Microsoft.BizTalk.Deployment.dll"

    gacutil /if "C:\Program Files\Microsoft BizTalk Server 2004\Developer Tools\Microsoft.BizTalk.ExplorerOM.dll"

    gacutil /if "C:\Program Files\Microsoft BizTalk Server 2004\Microsoft.BizTalk.Pipeline.dll"

    gacutil /if "C:\Program Files\Microsoft BizTalk Server 2004\Microsoft.XLANGs.BizTalk.Engine.dll"

    gacutil /if "C:\Program Files\Microsoft BizTalk Server 2004\Microsoft.XLANGs.Engine.dll"

  7. If you have run the Configuration Framework Wizard (Configframework.exe) on your computer that is running BizTalk Server, follow these steps.

    Note If you have not run the Configuration Framework Wizard on your computer that is running BizTalk Server, do not follow these steps.
    1. Click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.
    2. Run each one of the following SQL queries against the corresponding database as they appear in the following table.

      Note Make sure that you select the corresponding database for the SQL query as they appear in the table before you run the SQL query.
      SQL query nameSQL query locationDatabase to run the SQL query against
      Admin_server_logic.sqlProgram Files\Microsoft BizTalk Server2004\SchemaManagement database (default name: BizTalkMgmtDb)
      Msgbox_security_logic.sqlProgram Files\Microsoft BizTalk Server2004\SchemaMessage Box database (default name: BizTalkMsgBoxDb)
      Msgbox_application_logic.sqlProgram Files\Microsoft BizTalk Server2004\SchemaMessage Box database (default name: BizTalkMsgBoxDb)

      To run these SQL queries against the specified databases, follow these steps in SQL Query Analyzer:
      1. On the File menu, click Open.
      2. For each SQL query in the table, click the corresponding database, and then click Execute Query.
      Note The following error messages may appear when you run the Msgbox_application_logic.sql SQL Query. This behavior is expected.
      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.
    3. After you have run the SQL queries in step 7b, open a new blank query window in SQL Query Analyzer. To do this, click New on the File menu.
    4. In the blank query window, type the following query:
      exec bts_ResetApplicationSprocs
    5. By default, the Message Box database is named BizTalkMsgBoxDb. Select the Message Box database, and then click Execute Query to run the bts_ResetApplicationSprocs stored procedure.

      Note The following error messages may appear when you run the bts_ResetApplicationSprocs stored procedure. This behavior is expected.
      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.
      'BTS_BizTalkServerApplication_USERS' added to role 'BTS_HOST_USERS'.
      'BTS_ADMIN_USERS' added to role 'BTS_BizTalkServerApplication_USERS'.
      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.
      'BTS_BizTalkServerIsolatedHost_USERS' added to role 'BTS_HOST_USERS'.
      'BTS_ADMIN_USERS' added to role 'BTS_BizTalkServerIsolatedHost_USERS'.

Modification Type:MinorLast Reviewed:6/23/2006
Keywords:kbbiztalk2004-2006swept kberrmsg kbinfo KB837725 kbAudDeveloper