Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 907377 - Last Review: October 18, 2005 - Revision: 1.3
A SharePoint Portal Server 2003 database upgrade fails, and you do not receive an error message
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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=256986/
)
Description of the Microsoft Windows registry
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.
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.
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.
- Right-click SharePoint Portal Administration, and then click Restart.
- Quit the Services snap-in.
When you restart the SharePoint Portal Administration service, the SharePoint Portal Administration service will try to upgrade the database again.
This behavior is by design.
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: value
Number of portal sites attempted: value
Number of portal sites successfully updated: value
Not run: value
Note In the event,
value is replaced by the actual value.
You can find more detailed information in the portal diagnostic logs.
APPLIES TO
- Microsoft Office SharePoint Portal Server 2003
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate