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

Article translations Article translations
Article ID: 981910 - View products that this article applies to.
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()

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:
DROP STATISTICS (Transact-SQL)

STATUS

This behavior is by design.

Properties

Article ID: 981910 - Last Review: October 6, 2011 - Revision: 4.0
APPLIES TO
  • Microsoft SharePoint Server 2010
Keywords: 
kbexpertiseinter kbtshoot kbsurveynew kbprb KB981910

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com