Go 4 Sharepoint

Search:

Welcome: Guest!

MOSS Forum

Home » Forum » MOSS

Ask a question

RSS Feeds

stsadm prupgradecheck InvalidDatabaseSchema

Date: Sep 17, 2011 Category: MOSS Views: 90

I just installed WSS & MOSS sp2 on a 2007 Enterprise Edition dev box. I ran
the preupgrade check and it failde on the InvalidDatabaseSchema check. I looked
in the log and saw the eroor :
[DatabaseSchema] [ERROR] [3/11/2011 4:15:59 PM]:
[WSS_Content_XXXXXXSSP].[MAP_Role] MISSING Table

I looked in WSS_Content_XXXXXXSSP and saw that someone had mistakenly addded a
table to theis databse. (it's a copy of a table from another non-sharepoint db
on that sever). So I just dropped the table.

I reran the preupgrade check, and got the same message. So I fuigured it was
caching a scjhema somewhere so i reset iis, and then even reboot the server, bit
still is gives me the error.

Doesn anyone know how I can get rid of this meessage? or should I just ignore it
and move on?

Tagged:stsadm prupgradecheck invaliddatabaseschema

1 Answer Found

Answer #1 Answered On: Sep 17, 2011

Are you saying that you deleted the table but not the database itself?
You are not supposed to modify any of the SharePoint databases. So you
might need to export and import all the sites and then create a new web
application and SharePoint database to correct this issue. And then
delete the old web application and content database(s).

Didn't find what you were looking for? Find more on stsadm prupgradecheck InvalidDatabaseSchema Or get search suggestion and latest updates.

Your Answer

Answer should be atleast 30 Characters.
Please put code inside [Code] your code [/Code].

Please login to post comment

Previous: Document Library Field Querying by End User at 'run time' - Sharepoint 2010

Next: Joined Dataview Performance

Go4Sharepoint, is a Microsoft Featured Community. Microsoft, Windows, Sharepoint, Sharepoint logo, Windows logo, etc are trademarks of the Microsoft Corporation. All product names, logos, copyrights, and trademarks mentioned are acknowledged as the registered intellectual property of their respective owners. This site is not in any way affiliated with, nor has it been authorized, sponsored, or otherwise approved by, Microsoft Corporation.