Exception: Invalid object name 'Webs'.
Not very clear error .... but after looking in the Upgrade.log I found the following error pointing to a ContentDB
[DEBUG] [8/24/2012 7:01:02 PM]: Retrieving site definition for
language 1033...
[OWSTIMER] [SPUpgradeSession] [ERROR] [8/24/2012 7:01:02 PM]:
Upgrade [SPContentDatabase Name=WSS_Content] failed.
[OWSTIMER] [SPUpgradeSession] [ERROR] [8/24/2012 7:01:02 PM]: Exception:
Invalid object name 'Webs'.
[OWSTIMER] [SPUpgradeSession] [ERROR] [8/24/2012 7:01:02
PM]: at
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean
breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior
runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at
System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
Armed with this information I checked the content DB in question using SQL loads of tables/stored procedures were missing - see pictures below
Other
Tables contained many more as below
As this was a development box I was able to remove the web application and content DB - re-ran the upgrade wizard and all was good.
