PRB: BizTalk Server 2002 SP1 Cannot Update the BizTalk Databases (829325)


The information in this article applies to:

  • Microsoft BizTalk Server 2002 SP1

SYMPTOMS

When Microsoft BizTalk Server 2002 SP1 Setup has completed, you receive an error message that states that one of the post-install steps was not completed. When this problem occurs, you receive an error message that is similar to the following in the BizTalk Server application log: 
Event Type:	Error
Event Source:	BizTalk Server
Event Category:	Document Processing 
Event ID:	324

Description:
An error occurred in BizTalk Server.
 
 Details:
 ------------------------------
 [0x12e7] The database version is incompatible with the installed version of the server. Try running setup again.

 [0x150a] The configuration cache data from the database could not be loaded.

 [0x1509] The administration cache cannot be created.

 [0x0111] The Queue Scheduler for the service could not be created.

CAUSE

This problem may occur if the Orchestration components of BizTalk Server have not been installed on the server. If the Orchestration components of BizTalk Server are not installed, the service pack installation routine experiences an error when it tries to update these components. This error prevents the BizTalk databases from being updated.

RESOLUTION

To resolve this problem, you must manually run the three SQL scripts that are included with the service pack against the three BizTalk databases. To do this, open these scripts by using SQL Query Analyzer, and then run these scripts against the following databases:

Script nameDatabase to run against
BTM_SP1_Patch.sqlInterchangeBTM
DTA_SP1_Patch.sqlInterchangeDTA
SQ_SP1_Patch.sqlInterchangeSQ

MORE INFORMATION

When this problem occurs, text that is similar to the following appears in the BizTalk Server 2002 SP1 installation log: 
[08/15/03 09:52:18] Operation succeeded.
[08/15/03 09:52:18] Process exit code is 0.
[08/15/03 09:52:18] Operation succeeded.
[08/15/03 09:52:18] Executing post-install custom actions. 3 actions to execute.
[08/15/03 09:52:18] Executing custom action HotFixDatabaseCA.dll:PatchComPlusCA ...
[08/15/03 09:52:18] Loading library HotFixDatabaseCA.dll ...
[08/15/03 09:52:18] Operation succeeded.
[08/15/03 09:52:18] Getting address for custom action procedure PatchComPlusCA ...
[08/15/03 09:52:18] Operation succeeded.
[08/15/03 09:52:18] Invoking custom action procedure ...
[08/15/03 09:52:18] Custom Action: Patch XLANG COM+ applications...
[08/15/03 09:52:18] Finding COM+ application {DFDE2592-40A4-42BC-A35E-FD0BF76CA4D5}...
[08/15/03 09:52:18] COM+ application not found. (HRESULT=0)
[08/15/03 09:52:18] Finding COM+ application {834EB3F2-F1E0-4F68-BD65-22D2BADDFCC0}...
[08/15/03 09:52:18] COM+ application not found. (HRESULT=0)
[08/15/03 09:52:18] The custom action returned 1.
[08/15/03 09:52:18] One of the custom actions failed. The installation cannot continue. See log for details. 
[08/15/03 09:52:25] Stopping services after installation. 0 services to stop.
[08/15/03 09:52:25] Restarting previously stopped services...
[08/15/03 09:52:25] Starting service BTSSvc...
[08/15/03 09:52:25] Opening Service Control Manager...
[08/15/03 09:52:25] Operation succeeded.
[08/15/03 09:52:25] Opening service BTSSvc...
[08/15/03 09:52:25] Operation succeeded.
[08/15/03 09:52:25] Starting service BTSSvc...
[08/15/03 09:52:25] Operation succeeded.
[08/15/03 09:52:25] Finished restarting previously stopped services.
[08/15/03 09:52:25] Starting services after installation. 0 services to start.
[08/15/03 09:52:25] Operation succeeded.
[08/15/03 09:52:25] Registering patch...
[08/15/03 09:52:26] Operation succeeded.
Modification Type:MajorLast Reviewed:9/29/2003
Keywords:kbprb KB829325 kbAudDeveloper
©2003 Microsoft Corporation. All rights reserved.