Microsoft Knowledge Base Email Alertz

You cannot create a new area in SharePoint Portal Server 2003 after you install Windows SharePoint Services Service Pack 2

Search KbAlertz

Advanced Search

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.

Click here to create a
FREE account
Already have an account?
[Click here to Login]











Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks

Article ID: 910764 - Last Review: December 7, 2005 - Revision: 1.2

You cannot create a new area in SharePoint Portal Server 2003 after you install Windows SharePoint Services Service Pack 2

SYMPTOMS

Consider the following scenario. You install Microsoft Windows SharePoint Services Service Pack 2 (SP2). Then, you try to create a new area in Microsoft SharePoint Portal Server 2003. In this scenario, you may receive the following error message when you try to create a new area in SharePoint Portal Server 2003:
An error has occurred in the portal site. Contact the portal site administrator for assistance.

CAUSE

The problem occurs because the file time stamps on the SharePoint SQL script files are incorrect. These files are located in the following folder:
Drive:\Program Files\Common Files\Microsoft Shared\web server extensions\60\TEMPLATE\SQL
Because the time stamps are incorrect, Windows SharePoint Services SP2 does not update these files. Therefore, the stored procedures for the content databases are not updated.

RESOLUTION

To resolve this problem, follow these steps:
  1. Remove the *.SQL files from the following folder:
    Drive:\Program Files\Common Files\Microsoft Shared\web server extensions\60\TEMPLATE\SQL
  2. In Control Panel, double-click Add or Remove Programs.
  3. Click the Windows SharePoint Services installation in the list of programs, and then click Change.
  4. Click Reinstall or Repair Microsoft Windows SharePoint Services 2.0 to its original state, and then click Next.
After the repair is completed, you must force an upgrade so that the stored procedures on the content databases are updated. To complete this step, use the Stsadm.exe command-line tool to force an upgrade of the content databases:
  1. Click Start, click Run, type CMD in the Open box, and then click OK.
  2. At the command prompt, type the following lines, and then press ENTER after each line:
    cd /d %commonprogramfiles%\Microsoft Shared\Web Server Extensions\60\Bin
    stsadm -o upgrade -forceupgrade
    exit

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

APPLIES TO
  • Microsoft Office SharePoint Portal Server 2003
  • Microsoft Windows SharePoint Services 2.0
Keywords: 
kbexpertiseinter kbtshoot KB910764
       

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