You cannot visit any site collection from an Office SharePoint Server 2007 content database after you attach the content database to a SharePoint Server 2010 environment

This article has been archived. It is offered "as is" and will no longer be updated.
SYMPTOMS
After you attach a Microsoft Office SharePoint Server 2007 content database to a Microsoft SharePoint Server 2010 environment, you cannot visit any site collection from that content database. Additionally, you may receive an error message. For example, you receive the following error message:
[powershell] [SPContentDatabaseSequence] [ERROR] [Date Time]: Action 4.0.5.0 of Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence failed.
[powershell] [SPContentDatabaseSequence] [ERROR] [Date Time]: Exception: The statistics 'StatisticName' is dependent on column 'ColumnName'. ALTER TABLE ALTER COLUMN ColumnName failed because one or more objects access this column.
[powershell] [SPContentDatabaseSequence] [ERROR] [Date Time]: 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.SharePoint.Utilities.SqlSession.ExecuteNonQuery(SqlCommand command) at Microsoft.SharePoint.Upgrade.SPDatabaseSequence.ExecuteDataDefinitionMethodCore(SqlSession sqlSession, ISqlSession isqlSession, String sqlscript, SPLog log) at Microsoft.SharePoint.Upgrade.NarrowCIStage1And2.Upgrade() at Microsoft.SharePoint.Upgrade.SPActionSequence.Upgrade()
[powershell] [NarrowCIStage1And2 (4.0.5.0)] [DEBUG] [Date Time]: Begin Rollback()
[powershell] [SPContentDatabaseSequence] [ERROR] [Date Time]: Action 4.0.5.0 of Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence failed to rollback.
[powershell] [SPContentDatabaseSequence] [ERROR] [Date Time]: Exception: This SqlTransaction has completed; it is no longer usable.
[powershell] [SPContentDatabaseSequence] [ERROR] [Date Time]: at System.Data.SqlClient.SqlTransaction.ZombieCheck() at System.Data.SqlClient.SqlTransaction.Rollback(String transactionName) at Microsoft.SharePoint.Utilities.TransactionalSqlSession.Rollback() at Microsoft.SharePoint.Upgrade.SPDatabaseAction.Rollback() at Microsoft.SharePoint.Upgrade.SPActionSequence.Upgrade()
CAUSE
This issue occurs if the statistics that you create depend on a column that the SharePoint upgrade tries to work with.
WORKAROUND
Delete the statistics that are referenced in the error message.

For more information about how to delete the statistics, visit the following Microsoft Developer Network (MSDN) Web site:
STATUS
This behavior is by design.
Properties

Article ID: 981910 - Last Review: 12/12/2015 03:59:31 - Revision: 4.0

Microsoft SharePoint Server 2010

  • kbnosurvey kbarchive kbexpertiseinter kbtshoot kbsurveynew kbprb KB981910
Feedback