You cannot restart a SharePoint Portal Server 2003 database upgrade (907308)

Important This article contains information about how to modify the registry. Make sure to back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows registry

SYMPTOMS

When an upgrade of a Microsoft Office SharePoint Portal Server 2003 database fails or is canceled by a user, you cannot restart the database upgrade.

If you view the event logs, you may receive the following Informational message in the Application log:
Event Type: Information Event Source: SharePoint Portal Administration Service
Event Category: None
Event ID: 601 Date: 10/26/2005 Time: 6:38:01 PM
User: N/A
Computer: COMPUTERNAME
Description:
Attempted to apply update to SharePoint Portal Server 2003 portal sites.
Number of portal sites: 2
Number of portal sites attempted: 1
Number of portal sites successfully updated: 1
Not run: 1
Consult the ReadMe file included with this patch, or *_spsadmin.log for more details.

For more information, see Help and Support Center at http://support.microsoft.com.
Data:
0000: 41 00 70 00 70 00 44 00 A.p.p.D.
0008: 6f 00 6d 00 61 00 69 00 o.m.a.i.
0010: 6e 00 3a 00 20 00 73 00 n.:. .s.
0018: 70 00 73 00 61 00 64 00 p.s.a.d.
0020: 6d 00 69 00 6e 00 2e 00 m.i.n...
0028: 65 00 78 00 65 00 e.x.e.

CAUSE

This problem may occur when you install Microsoft Office SharePoint Portal Server 2003 Service Pack 2 (SP2) or when you apply a SharePoint Portal Server 2003 post-SP2 hotfix. When you install SharePoint Portal Server 2003 SP2 or apply a SharePoint Portal Server 2003 post-SP2 hotfix, an upgrade of a SharePoint Portal Server 2003 database occurs as a part of the update.

RESOLUTION

Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall your operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

Review all SharePoint Portal Server 2003 logs. These logs include the *_spsadmin.log logs that are mentioned in event ID 601 in the "Symptoms" section. Correct failures as described in these logs. If correcting the issues that are found in all SharePoint Portal Server 2003 logs does not resolve the upgrade issue, use the following steps.

To resolve this problem, follow these steps:

Click Start, click Run, type regedit, and then click OK.
Locate and then click the following subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SharePoint Portal Server\2.0\SPSDatabaseUpdate
Double-click UpdateRequired, type 1 in the Value data box, and then click OK.
Double-click UpdateComplete, type 0 in the Value data box, and then click OK.
Locate and then click the following subkey:
HKEY_LOCAL_MACHINE\Software\Microsoft\SharePoint Portal Server\2.0
Double-click TargetSchemaVersion_Portal, type the appropriate value in the Value data box, and then click OK.

Note The appropriate value for SP2 is 2.0.40.1. However, post-SP2 hotfixes may contain a different schema version. Make sure that you enter the appropriate value.
Quit Registry Editor.
Click Start, click Run, type services.msc, and then click OK.
Click SharePoint Portal Administration, and then click Restart on the toolbar.
Quit the Services snap-in.
Verify the event log to determine whether any other errors occur.

MORE INFORMATION

The SharePoint Portal Server 2003 databases store the schema version in the PortalSchemaVersion tables in all the portal databases. These databases include the Configuration, _SITE, _PROF, and _SERV databases.

For the original release version of SharePoint Portal Server 2003 and for SharePoint Portal Server 2003 Service Pack 1 (SP1), the columns in the PortalSchemaVersion tables for all the portal databases should be as follows:

ShemaVersion 2.0.40.0
BuildVersion 11.0.5704.0

After SharePoint Portal Server 2003 SP2 is installed, the columns in the PortalSchemaVersion tables for all the portal databases should be as follows: