Microsoft KB Archive/907308

= You cannot restart a SharePoint Portal Server 2003 database upgrade, or the virtual servers display &quot;upgrade&quot; on the SharePoint Central Administration Web page =

Article ID: 907308

Article Last Modified on 5/25/2007

-

APPLIES TO


 * Microsoft Office SharePoint Portal Server 2003

-



Important This article contains information about how to modify the registry. Make sure that you 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. Alternatively, the virtual servers in SharePoint Central Administration display 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 the 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 &quot;Symptoms&quot; 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 as appropriate for your situation.

In single and small SharePoint Portal Server farms
 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, type 1 in the Value data box, and then click OK. Double-click, 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, 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.</li> Close Registry Editor.</li> Click Start, click Run, type services.msc, and then click OK.</li> Click SharePoint Portal Administration, and then click Restart on the toolbar.</li> Quit the Services snap-in.</li> Verify the event log to determine whether any other errors occur.</li></ol>

In medium and large SharePoint Portal Server farms
<ol> Click Start, point to Administrative Tools, and then click Services.</li> In the Services MMC snap-in, double-click SharePoint Portal Administration, click Stop, set the Startup type to Manual, and then click OK.</li> Repeat steps 1 to 2 on each front-end Web server in the farm.</li> Click Start, click Run, type regedit, and then click OK.</li> Locate and then click the following subkey:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SharePoint Portal Server\2.0\SPSDatabaseUpdate

</li> Double-click, type 1 in the Value data box, and then click OK.</li> Double-click, type 0 in the Value data box, and then click OK.</li> Locate and then click the following subkey:

HKEY_LOCAL_MACHINE\Software\Microsoft\SharePoint Portal Server\2.0

</li> Double-click, 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.</li> Close Registry Editor, and then restart the computer.</li> After the computer restarts, click Start, point to Administrative Tools, and then click Services.</li> <li>In the Services MMC snap-in, double-click SharePoint Portal Administration, click Start, set the Startup type to Automatic, and then click OK..</li> <li>Click Start, point to Administrative Tools, and then click SharePoint Central Administration.</li> <li>On the Central Administration page, click Configure virtual server settings under Virtual Server Settings.</li> <li>Determine whether the virtual servers still display upgrade next to the virtual server name.</li> <li>If upgrade is still displayed, repeat steps 1 and 2 to stop the SharePoint Portal Administration service on the computer. Then, repeat steps 4 to 15 on a different front-end Web server until at least one of the virtual servers does not display upgrade.</li> <li>If the virtual server does not display upgrade under Virtual Server Settings, you must first back up all the SharePoint sites in the farm by using SharePoint Portal Server Data Backup and Restore.

For more information about how to back up and restore SharePoint Portal Server 2003, see the &quot;Backup and Restore&quot; section of the Microsoft Office SharePoint Portal Server 2003 Administration Guide.</li> <li>After you back up SharePoint Portal Server 2003, you must perform a forced upgrade on the remaining front-end Web servers in the farm by running the following command at the command prompt:

stsadm -o upgrade -forceupgrade -url

Note By default, the stsadm command line tool is located in the \Program Files\Common Files\Microsoft Shared\web server extensions\60\BIN folder.</li> <li>You must perform these steps on each front-end Web server on which the extended virtual servers display upgrade.</li></ol>

<div class="moreinformation_section">

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:

SchemaVersion 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:

SchemaVersion 2.0.40.1

BuildVersion 11.0.8126.0

Note The SchemaVersion of the Configuration database does not change. It will be 2.0.3.0.

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Keywords: kbtshoot kbprb KB907308

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.