Geeks With Blogs
Fringe SharePoint Continued

I have been trying to put a staging environment together to upgrade from SharePoint 2007 SP1 to SharePoint 2007 SP2. Then we will run the preupgradecheck command to varify that the database wil upgrade properly. We ran into the infamous error:

Issue : Content database with modified database schemas       
User modifications to the SharePoint content database, including but not limited to table schemas, index, stored procedures, are not supported and will cause upgrade to future versions of SharePoint to fail. The databases in the following list seem to have been modified from the original schema:

There are a lot of thints that can cause this. I'm just posting what I found and what I did to fix it. hopefully the content here will help you figure out your issue.

 First, investigate the logs in the "12/Logs" directory. You will be able to pinpoint what schema changes are problematic. For me it was this was an issue with ContentTypeID tables and keys.

 Now that you know what the schem issues are about, you could clean things up manaually (which is not a good idea) or you can let SharePoint do it for you!

  Check this out for a manual example :

  Check this out for a SharePoint fix:

  I used the second, as it was not something that was added accidently, it appears that some orphaned content type or wsp might have caused this. At least that's what I suspect.

   Hopefully it points you in the right direction.





Posted on Tuesday, August 23, 2011 4:23 PM SharePoint , BUGS | Back to top

Comments on this post: Pre-Upgrade check and Database Schema issues

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © juanlarios | Powered by: