Article ID: 981910 - Last Review: October 6, 2011 - Revision: 4.0

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

View products that this article applies to.

System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.

Expand all | Collapse all

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()

Back to the top

CAUSE

This issue occurs if the statistics that you create depend on a column that the SharePoint upgrade tries to work with.

Back to the top

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:

DROP STATISTICS (Transact-SQL) (http://msdn.microsoft.com/en-us/library/ms175075.aspx)

Back to the top