SharePoint Blogs / SharePoint University
SharePoint Blogs and SharePoint University - all in one place!
Need SharePoint Training? Attend a SharePoint Bootcamp!

Please delete cookies related to sharepointblogs.com and sharepointu.com to resolve login issues!

MOSS 2007 Service Pack 1 Installation Experience

We installed first time in a stressy condition the SP1 for a development server (a simple farm installation). In the middle of installation, it is starts behaving like a stranger and finally get craped! The result: Server error http://go.microsoft.com/fwlink?LinkID=96177 when trying to access one of the sites. I tried to sync old content database, but no luck. After requesting an and applying Windows Sharepoint Services 3.0 hotfix 936867 our Sharepoint stopped working completely. I've found the following error messages in the application log: In simple, the schema versions of content databases are not consistent between DB Server and MOSS Server as follows

“The schema version (3.0.149.0) of the database SharePoint_AdminContent_0015a5e2-8907-416d-8672-940a68c2c431 on Database Server is not consistent with the expected database schema version (3.1.3.0) on MOSS Server.  Connections to this database from this server have been blocked to avoid data loss.  Upgrade the web front end or the content database to ensure that these versions match”

Problem:

Event Type:     Error
Event Source:     Windows Sharepoint Services 3
Event Category: Topology
EventID:     5617
Date:          
03.25.2008
Time:         
20:45:34
User:          
N/A
Computer:  MOSS Server
Description: 
The schema version (3.0.149.0) of the database SharePoint_AdminContent_0015a5e2-8907-416d-8672-940a68c2c431 on Database Server is not consistent with the expected database schema version (3.1.3.0) on MOSS Server.  Connections to this database from this server have been blocked to avoid data loss.  Upgrade the web front end or the content database to ensure that these versions match

Solution:
 "stsadm -o upgrade -inplace -url http://{central_admin_url}/"

example., stsadm –o upgrade –inplace –url http://mossserver:17492/

 

That seemed to have solved the problem.

Posted 03-26-2008 8:29 AM by LovedJohnySmith

Comments

Brad Cummins wrote re: MOSS 2007 Service Pack 1 Installation Experience
on 03-26-2008 3:17 PM

Helped me lot! - Thanks man!

Reinhard Schuerer wrote re: MOSS 2007 Service Pack 1 Installation Experience
on 05-02-2008 7:54 AM

Thanks was the same problem here.

Jason wrote re: MOSS 2007 Service Pack 1 Installation Experience
on 06-13-2008 3:39 PM

Thanks! This was a big help, we were dead in the water after the Post-SP1 rollups, and this solved our problem.

Carlos wrote re: MOSS 2007 Service Pack 1 Installation Experience
on 07-30-2008 9:50 AM

sorry but where I have to make that call "called "stsadm -o upgrade -inplace -url http://{central_admin_url}/""  in cmd in mssql where?

Andrew wrote re: MOSS 2007 Service Pack 1 Installation Experience
on 10-01-2008 11:41 AM

C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN

Bob wrote re: MOSS 2007 Service Pack 1 Installation Experience
on 02-27-2009 10:31 AM

Thanks man ! Saved my life

senthilnathan wrote re: MOSS 2007 Service Pack 1 Installation Experience
on 04-15-2009 10:09 AM

Thanks too. u save my life.....

Jim wrote re: MOSS 2007 Service Pack 1 Installation Experience
on 04-16-2009 3:40 AM

Likewise - this even worked on an Sharepoint 3 instalaltion 9Microsoft VPC image) that didn;t have any recent hotfixes installed. The stsadm command you suggested fixed our problem too!

Steve York wrote re: MOSS 2007 Service Pack 1 Installation Experience
on 05-06-2009 3:42 AM

Anyone know if this will work on WSS as well as MOSS, the directories are the same, I am tempted to give it a try as I have exactly the same problem as described above.

Steve York wrote re: MOSS 2007 Service Pack 1 Installation Experience
on 05-06-2009 6:15 AM

Update to my earlier post, bit the bullet and tried it and it work a treat for me as well on WSS.

This fix was a life saver - ty

Add a Comment

(required)  
(optional)
(required)  
Remember Me?
Need SharePoint Training? Attend a SharePoint Bootcamp!
Posts (c) their respective authors. Everything else (c) 2009 SharePoint Experts, Inc.