Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Failed: Content Databse with Modified database schemas

  Asked By: Angie    Date: Mar 29    Category: Sharepoint    Views: 2937

I ran the stsadm -o preupgradecheck against my WSS3.0 server and have the
message "Failed: Content Databse with Modified database schemas" .

I do not remember changing the database schema. I cannot find anything
online to tell me how to fix this before I run the upgrade to Foundations.

Share: 

 

6 Answers Found

 
Answer #1    Answered By: Cassandra Cooper     Answered On: Mar 29

Take a look at the following. Changing almost anything in the SQL database
will cause this error.

http://mphacker.spaces.live.com/Blog/cns!8040CC624DDC5404!756.entry?sa=55725
4054

 
Answer #2    Answered By: Elaina Suarez     Answered On: Mar 29

As a SharePoint Admin... I've had this happen before. I even opened a case with
Microsoft. We were basically told that someone modified  our database  (which
everyone claimed "it wasn't me").

Ultimately we compared a default SharePoint 2007 schema  with the one for our
modified database (RedGate). In the end ...it turned out someone had put some
indices on quite a few tables where they normally would have not existed. After
reporting our findings to MSFT and requesting permission to remove said changes,
our issue went away.

Alternatively, I believe they said we could do a SharePoint backup... and
restore into another database... which should have removed the unsupported
changes. Your issue could be different... but this would be a good start (schema
comparison). Make sure you're not using your ACTIVE databases to compare against
if that's what you decide to do.

 
Answer #3    Answered By: Kacey Russo     Answered On: Mar 29

Another option would be to create another content  database in that web
app and use the STSADM operation "mergecontentdbs" to move site
collections from the modified  content database  to the new, good one.
Then delete the modified database.

 
Answer #4    Answered By: Rebecca Lewis     Answered On: Mar 29

Ok so I started from scratch and rebuilt the server, installed SQLEXPRESS,
WSS3.0 and was able to import my content  database again and I am no longer
seeing the error message pertaining to it. However, I continue to get the error
message concerning the Microsoft##SSEE database. How do I fix  that one. This is
a brand new install so this was installed by default.

 
Answer #5    Answered By: Emily Clark     Answered On: Mar 29

What is the actual error message from the event viewer?

 
Answer #6    Answered By: Alycia Everett     Answered On: Mar 29


Log Name: Application
Source: SharePoint 2010 Products Configuration Wizard
Date: 5/7/2010 12:45:36 PM
Event ID: 104
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: TOASP.TOA.LOCAL
Description:
Failed to initiate the upgrade  sequence.
An exception of type System.InvalidOperationException was thrown. Additional
exception information: Service mssql$SQLEXPESS was not found on computer '.'.
System.InvalidOperationException: Service mssql$SQLEXPESS was not found on
computer '.'. ---> System.ComponentModel.Win32Exception: The specified service
does not exist as an installed service
--- End of inner exception stack trace ---
at System.ServiceProcess.ServiceController.GenerateNames()
at System.ServiceProcess.ServiceController.get_ServiceName()
at System.ServiceProcess.ServiceController.GenerateStatus()
at System.ServiceProcess.ServiceController.get_Status()
at Microsoft.SharePoint.Upgrade.WyukonToSqlExpress.StopService(String
serviceName)
at
Microsoft.SharePoint.Upgrade.WyukonToSqlExpress.DatabaseInstanceInfo.MoveDatabas\
es(WyukonToSqlExpress parent, SqlConnectionStringBuilder scsbOldConfigDb,
SqlConnectionStringBuilder scsbNew, Boolean configDbOnly)
at
Microsoft.SharePoint.Upgrade.WyukonToSqlExpress.MoveDatabases(SqlConnectionStrin\
gBuilder scsbOldConfigDb, SqlConnectionStringBuilder scsbNew, ArrayList&
oldDatabaseInstances)
at Microsoft.SharePoint.Upgrade.WyukonToSqlExpress.Run()
at Microsoft.SharePoint.Upgrade.SPManager.BootStrap(Guid sessionId,
SPUpgradeOperationFlags flags)
at Microsoft.SharePoint.PostSetupConfiguration.UpgradeBootstrapTask.Run()
at Microsoft.SharePoint.PostSetupConfiguration.TaskThread.ExecuteTask()
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="SharePoint 2010 Products Configuration Wizard" />
<EventID Qualifiers="0">104</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2010-05-07T17:45:36.000Z" />
<EventRecordID>6320</EventRecordID>
<Channel>Application</Channel>
<Computer>TOASP.TOA.LOCAL</Computer>
<Security />
</System>
<EventData>
<Data>Failed to initiate the upgrade sequence.
An exception of type System.InvalidOperationException was thrown. Additional
exception information: Service mssql$SQLEXPESS was not found on computer '.'.
System.InvalidOperationException: Service mssql$SQLEXPESS was not found on
computer '.'. ---> System.ComponentModel.Win32Exception: The specified
service does not exist as an installed service
--- End of inner exception stack trace ---
at System.ServiceProcess.ServiceController.GenerateNames()
at System.ServiceProcess.ServiceController.get_ServiceName()
at System.ServiceProcess.ServiceController.GenerateStatus()
at System.ServiceProcess.ServiceController.get_Status()
at Microsoft.SharePoint.Upgrade.WyukonToSqlExpress.StopService(String
serviceName)
at
Microsoft.SharePoint.Upgrade.WyukonToSqlExpress.DatabaseInstanceInfo.MoveDatabas\
es(WyukonToSqlExpress parent, SqlConnectionStringBuilder scsbOldConfigDb,
SqlConnectionStringBuilder scsbNew, Boolean configDbOnly)
at
Microsoft.SharePoint.Upgrade.WyukonToSqlExpress.MoveDatabases(SqlConnectionStrin\
gBuilder scsbOldConfigDb, SqlConnectionStringBuilder scsbNew, ArrayList&
oldDatabaseInstances)
at Microsoft.SharePoint.Upgrade.WyukonToSqlExpress.Run()
at Microsoft.SharePoint.Upgrade.SPManager.BootStrap(Guid sessionId,
SPUpgradeOperationFlags flags)
at Microsoft.SharePoint.PostSetupConfiguration.UpgradeBootstrapTask.Run()
at
Microsoft.SharePoint.PostSetupConfiguration.TaskThread.ExecuteTask()</Data>
</EventData>
</Event>

 
Didn't find what you were looking for? Find more on Failed: Content Databse with Modified database schemas Or get search suggestion and latest updates.




Tagged: