locked
Restoring WSS 3.0 content database to WSS 3.0 SP2 RRS feed

  • Question

  • hi,

    I m restoring WSS 3.0 content database to WSS 3.0 SP2, while adding content database getting following error, upgrade log is below. tell how to fix it. thx

    [SPManager] [DEBUG] [3/20/2015 4:23:12 AM]: Logging enabled Friday, March 20, 2015 at 4:23:12 AM.
    [SPManager] [INFO] [3/20/2015 4:23:12 AM]: Inplace Upgrade session starts. root object = SPContentDatabase Name=WSS_Content Parent=SPDatabaseServiceInstance, recursive = False
    [SPManager] [INFO] [3/20/2015 4:23:13 AM]: Preparing to upgrade PersistedUpgradableObject: SPContentDatabase Name=WSS_Content Parent=SPDatabaseServiceInstance.  This object's current status is Online.
    [SPManager] [DEBUG] [3/20/2015 4:23:13 AM]: Using cached [SPContentDatabase Name=WSS_Content Parent=SPDatabaseServiceInstance] CanUpgrade value: True.
    [SPHierarchyManager] [DEBUG] [3/20/2015 4:23:13 AM]: SPTree Value=SPContentDatabase Name=WSS_Content Parent=SPDatabaseServiceInstance IsRoot=True.
    [SPHierarchyManager] [DEBUG] [3/20/2015 4:23:13 AM]: 1/1 root trees in cache.
    [SPManager] [DEBUG] [3/20/2015 4:23:13 AM]: SPTree Value=SPContentDatabase Name=WSS_Content Parent=SPDatabaseServiceInstance IsGrown=False IsRoot=True IsLeaf=True.
    [SPManager] [DEBUG] [3/20/2015 4:23:13 AM]: Using cached [SPContentDatabase Name=WSS_Content Parent=SPDatabaseServiceInstance] NeedsUpgrade value: True.
    [SPManager] [DEBUG] [3/20/2015 4:23:13 AM]: Upgrading [SPContentDatabase Name=WSS_Content Parent=SPDatabaseServiceInstance].
    [SPContentDatabaseSequence] [DEBUG] [3/20/2015 4:23:13 AM]: Invalidating WYukon signature in SPContentDatabase Name=WSS_Content Parent=SPDatabaseServiceInstance.
    [SPContentDatabaseSequence] [DEBUG] [3/20/2015 4:23:13 AM]: ---------------- Begin Table RowCount Dump ----------------
    [SPSqlCommandFactory] [DEBUG] [3/20/2015 4:23:13 AM]: SqlCommand.CommandTimeout = 0
    [SPSqlCommandFactory] [DEBUG] [3/20/2015 4:23:13 AM]: SqlCommand.CommandTimeout = 0
    [SPSqlCommandFactory] [DEBUG] [3/20/2015 4:23:15 AM]: Average row size in the docs table too large. Adjust row count from 194835 to 491907
    [SPContentDatabaseSequence] [DEBUG] [3/20/2015 4:23:15 AM]: Table [dbo].[AllDocs] RowCount = 491907
    [SPSqlCommandFactory] [DEBUG] [3/20/2015 4:23:15 AM]: SqlCommand.CommandTimeout = 0
    [SPContentDatabaseSequence] [DEBUG] [3/20/2015 4:23:15 AM]: Table [dbo].[AllDocStreams] RowCount = 147000
    [SPSqlCommandFactory] [DEBUG] [3/20/2015 4:23:15 AM]: SqlCommand.CommandTimeout = 0
    [SPContentDatabaseSequence] [DEBUG] [3/20/2015 4:23:15 AM]: Table [dbo].[AllDocVersions] RowCount = 1235
    [SPSqlCommandFactory] [DEBUG] [3/20/2015 4:23:15 AM]: SqlCommand.CommandTimeout = 0
    [SPManager] [ERROR] [3/20/2015 4:23:50 AM]: Upgrade [SPContentDatabase Name=WSS_Content Parent=SPDatabaseServiceInstance] failed.
    [SPManager] [ERROR] [3/20/2015 4:23:50 AM]: Could not continue scan with NOLOCK due to data movement.
    [SPManager] [ERROR] [3/20/2015 4:23:50 AM]:    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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       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.SPSqlCommandFactory.GetRowCount(String strTable)
       at Microsoft.SharePoint.Upgrade.SPDatabaseWssSequence.LogTableRowCounts()
       at Microsoft.SharePoint.Upgrade.SPDatabaseWssSequence.PreUpgrade()
       at Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence.PreUpgrade()
       at Microsoft.SharePoint.Upgrade.SPManager.Upgrade(Object o, Boolean bRecurse)
    [SPManager] [DEBUG] [3/20/2015 4:23:50 AM]: Elapsed time upgrading [SPContentDatabase Name=WSS_Content Parent=SPDatabaseServiceInstance]: 00:00:37.
    [SPManager] [INFO] [3/20/2015 4:23:50 AM]: Resetting the status of PersistedUpgradableObject: SPContentDatabase Name=WSS_Content Parent=SPDatabaseServiceInstance to Online.
    [SPManager] [DEBUG] [3/20/2015 4:23:50 AM]: Using cached [SPContentDatabase Name=WSS_Content Parent=SPDatabaseServiceInstance] NeedsUpgrade value: True.
    [SPManager] [INFO] [3/20/2015 4:23:50 AM]: Inplace Upgrade session finishes. root object = SPContentDatabase Name=WSS_Content Parent=SPDatabaseServiceInstance, recursive = False. 1 errors and 0 warnings encountered.


    iffi

    Friday, March 20, 2015 12:45 PM