Microsoft KB Archive/907377

= A SharePoint Portal Server 2003 database upgrade fails, and you do not receive an error message =

Article ID: 907377

Article Last Modified on 10/18/2005

-

APPLIES TO


 * Microsoft Office SharePoint Portal Server 2003

-



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 you try to upgrade a database in Microsoft Office SharePoint Portal Server 2003, the upgrade fails. Additionally, you do not receive an error message.



CAUSE
The database upgrade may fail for several reasons. These reasons include the following:
 * The database is unavailable.
 * The portal site is in a bad state.
 * The host header is not correctly configured.

Note A database upgrade may fail for other reasons.



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.

To resolve this issue, 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

 Right-click UpdateRequired, click Modify, type 1 in the Value data box, and then click OK. Right-click UpdateComplete, click Modify, type 0 in the Value data box, and then click OK. Quit Registry Editor. Click Start, click Run, type services.msc, and then click OK.</li> Right-click SharePoint Portal Administration, and then click Restart.</li> Quit the Services snap-in.</li></ol>

When you restart the SharePoint Portal Administration service, the SharePoint Portal Administration service will try to upgrade the database again.

<div class="status_section">

STATUS
This behavior is by design.

<div class="moreinformation_section">

MORE INFORMATION
All SharePoint Portal Server 2003 hotfixes and service packs that are released after Microsoft Office SharePoint Portal Server 2003 Service Pack 2 (SP2) will try to upgrade the databases and portal sites. However, if the upgrade fails, you do not receive an error message. When the upgrade fails, an event that is similar to the following is logged in the Application event log: Attempted to apply update to SharePoint Portal Server 2003 portal sites.

Number of portal sites:

Number of portal sites attempted:

Number of portal sites successfully updated:

Not run:

Note In the event,  is replaced by the actual value.

You can find more detailed information in the portal diagnostic logs.

Additional query words: SPS2003

Keywords: kbtshoot kbprb KB907377

-

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

© Microsoft Corporation. All rights reserved.