locked
Upgrade ERROR: Action 16.0.23.0 of Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence failed. RRS feed

  • Question

  • Hi all, I'm Trying to migrate from Sharepoint 2013 to Sharepoint 2016.
    I get this error and I can't find any suggestion on the net:

    Exception: Action 16.0.23.0 of Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence failed.
    Exception: Could not find object '[mssqlrbs_resources].[rbs_work_all_blobs_used_view]' or you do not have permission.  Could not find object '[mssqlrbs_resources].[rbs_work_all_blobs_used_view]' or you do not have permission.

    FileStream is active on the SQL

    Thank You and Happy Summer everyone

    Cinzia

    Thursday, August 11, 2016 3:52 PM

All replies

  • Hi Cinzia,

    When did you get the error? In which step?

    Could you provide more logs?

    And here are some related links, please check:

    https://social.technet.microsoft.com/Forums/ja-JP/1e38b441-5904-497e-80eb-a6c2572da093/sharepoint-2013-upgrade-mountspcontentdatabase-fails?forum=sharepointadmin

    https://social.technet.microsoft.com/Forums/en-US/8990e999-15e3-4a51-9f4e-e8f328d9fa1b/june-2012-upgrade-failure-action-4030-of-microsoftsharepointupgradespiiswebsitewsssequence?forum=sharepointadminprevious

    Best Regards,

    CY


    TechNet Community Support
    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Friday, August 12, 2016 9:33 AM
  • I get the error with the Mount-SPContentDatabase 

    The error are all connected to the "rbs_work_all_blobs_used_view" view but I can see it in my database

    in the log file I can see only these errors

    AddABSSupportAddColumn (16.0.23.0) ajywc DEBUG Begin Initialize()
    AddABSSupportAddColumn (16.0.23.0) ajywd DEBUG End Initialize()
    AddABSSupportAddColumn (16.0.23.0) ajywe INFO Add ABS support for Docstreams table, Add Column. 
    AddABSSupportAddColumn (16.0.23.0) ajywf DEBUG Begin Upgrade()
    AddABSSupportAddColumn (16.0.23.0) aslin DEBUG UpgradeScript:   IF NOT EXISTS (SELECT 1 FROM sys.all_columns AS SAC  WHERE       SAC.object_id = OBJECT_ID(N'[dbo].[DocStreams]') AND      SAC.name = 'ABSId')  BEGIN      ALTER TABLE [dbo].[DocStreams] ADD  [ABSId] uniqueidentifier NULL,  [ABSInfo] varbinary(1000) NULL    IF EXISTS (SELECT TOP 1 1 FROM sys.objects WHERE object_id = object_id(N'[dbo].[TVF_DocStreams_RbsIdNotNull]') AND type = 'IF')      EXEC sys.sp_refreshsqlmodule '[dbo].[TVF_DocStreams_RbsIdNotNull]'      IF EXISTS (SELECT TOP 1 1 FROM sys.objects WHERE object_id = object_id(N'[dbo].[TVF_DocStreams_RbsIdNull]') AND type = 'IF')      EXEC sys.sp_refreshsqlmodule '[dbo].[TVF_DocStreams_RbsIdNull]'      IF EXISTS (SELECT TOP 1 1 FROM sys.objects WHERE object_id = object_id(N'[dbo].[TVF_DocStreams_ExpireLT]') AND type = 'IF')      EXEC sys.sp_refreshsqlmodule '[dbo].[TVF_DocStreams_ExpireLT]'      IF EXISTS (SELECT TOP 1 1 FROM sys.objects WHERE object_id = object_id(N'[dbo].[TVF_DocStreams_NoLock_ExpireLT]') AND type = 'IF')      EXEC sys.sp_refreshsqlmodule '[dbo].[TVF_DocStreams_NoLock_ExpireLT]'      IF EXISTS (SELECT TOP 1 1 FROM sys.objects WHERE object_id = object_id(N'[dbo].[TVF_DocStreams_ALL]') AND type = 'IF')      EXEC sys.sp_refreshsqlmodule '[dbo].[TVF_DocStreams_ALL]'      IF EXISTS (SELECT TOP 1 1 FROM sys.objects WHERE object_id = object_id(N'[dbo].[TVF_DocStreams_SiteId]') AND type = 'IF')      EXEC sys.sp_refreshsqlmodule '[dbo].[TVF_DocStreams_SiteId]'      IF EXISTS (SELECT TOP 1 1 FROM sys.objects WHERE object_id = object_id(N'[dbo].[TVF_DocStreams_NoLock_SiteId]') AND type = 'IF')      EXEC sys.sp_refreshsqlmodule '[dbo].[TVF_DocStreams_NoLock_SiteId]'      IF EXISTS (SELECT TOP 1 1 FROM sys.objects WHERE object_id = object_id(N'[dbo].[TVF_DocStreams_RepeatableRead_SiteId]') AND type = 'IF')      EXEC sys.sp_refreshsqlmodule '[dbo].[TVF_DocStreams_RepeatableRead_SiteId]'      IF EXISTS (SELECT TOP 1 1 FROM sys.objects WHERE object_id = object_id(N'[dbo].[TVF_DocStreams_SiteIdDocId]') AND type = 'IF')      EXEC sys.sp_refreshsqlmodule '[dbo].[TVF_DocStreams_SiteIdDocId]'      IF EXISTS (SELECT TOP 1 1 FROM sys.objects WHERE object_id = object_id(N'[dbo].[TVF_DocStreams_NoLock_SiteIdDocId]') AND type = 'IF')      EXEC sys.sp_refreshsqlmodule '[dbo].[TVF_DocStreams_NoLock_SiteIdDocId]'      IF EXISTS (SELECT TOP 1 1 FROM sys.objects WHERE object_id = object_id(N'[dbo].[TVF_DocStreams_SiteDocPartition]') AND type = 'IF')      EXEC sys.sp_refreshsqlmodule '[dbo].[TVF_DocStreams_SiteDocPartition]'      IF EXISTS (SELECT TOP 1 1 FROM sys.objects WHERE object_id = object_id(N'[dbo].[TVF_DocStreams_NoLock_SiteDocPartition]') AND type = 'IF')      EXEC sys.sp_refreshsqlmodule '[dbo].[TVF_DocStreams_NoLock_SiteDocPartition]'      IF EXISTS (SELECT TOP 1 1 FROM sys.objects WHERE object_id = object_id(N'[dbo].[TVF_DocStreams_CI]') AND type = 'IF')      EXEC sys.sp_refreshsqlmodule '[dbo].[TVF_DocStreams_CI]'      IF EXISTS (SELECT TOP 1 1 FROM sys.objects WHERE object_id = object_id(N'[dbo].[TVF_DocStreams_NoLock_CI]') AND type = 'IF')      EXEC sys.sp_refreshsqlmodule '[dbo].[TVF_DocStreams_NoLock_CI]'      DECLARE @ViewName sysname  DECLARE viewsToRefresh CURSOR LOCAL FAST_FORWARD FOR      SELECT N'[' +          OBJECT_SCHEMA_NAME(sed.referencing_id) +          N'].[' +          OBJECT_NAME(sed.referencing_id) +          N']'      FROM sys.sql_expression_dependencies AS sed      INNER JOIN sys.objects AS o      ON o.object_id = sed.referencing_id          AND o.type = 'V'      WHERE sed.referenced_id = OBJECT_ID('[dbo].[DocStreams]')    OPEN viewsToRefresh  WHILE 1 = 1  BEGIN      FETCH NEXT FROM viewsToRefresh INTO @ViewName      IF @@FETCH_STATUS <> 0           BREAK      EXEC sys.sp_refreshview @ViewName  END  CLOSE viewsToRefresh  DEALLOCATE viewsToRefresh    END  
    SPContentDatabaseSequence ajywk ERROR Action 16.0.23.0 of Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence failed.
    SPContentDatabaseSequence ajywk ERROR Exception: Could not find object '[mssqlrbs_resources].[rbs_work_all_blobs_used_view]' or you do not have permission.  Could not find object '[mssqlrbs_resources].[rbs_work_all_blobs_used_view]' or you do not have permission.
    SPContentDatabaseSequence ajywk ERROR    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)     at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)     at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)     at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)     at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()     at Microsoft.SharePoint.Utilities.SqlSession.ExecuteScript(TextReader textReader, Int32 commandTimeout)     at Microsoft.SharePoint.Upgrade.SPDatabaseAction.Upgrade(ISchemaUpgradeAction schemaAction)     at Microsoft.SharePoint.Upgrade.SPDatabaseAction.Upgrade()     at Microsoft.SharePoint.Upgrade.SPActionSequence.Upgrade()
    AddABSSupportAddColumn (16.0.23.0) ajywl DEBUG Begin Rollback()
    AddABSSupportAddColumn (16.0.23.0) ajywm DEBUG End Rollback()
    AddABSSupportAddColumn (16.0.23.0) ajywp DEBUG Begin Dispose()
    AddABSSupportAddColumn (16.0.23.0) ajywq DEBUG End Dispose()
    AddABSSupportAddColumn (16.0.23.0) ajywr DEBUG Execution Time=541,358817950326
    AddABSSupportAddColumn (16.0.23.0) ajywr DEBUG CPU Cycles=125553036
    AddABSSupportAddColumn (16.0.23.0) ajywr DEBUG SQL Query Count=4
    AddABSSupportAddColumn (16.0.23.0) ajywr DEBUG SPRequest Objects=1
    AddABSSupportAddColumn (16.0.23.0) aloo1 DEBUG Exiting Upgrade Action
    SPContentDatabaseSequence aloo2 DEBUG Exiting Upgrade Action Sequence

    I'll check the link

    Thank you
    Cinzia



    • Edited by CinziaTa Friday, August 12, 2016 10:39 AM
    Friday, August 12, 2016 9:48 AM
  • Hi Cinzia,

    Is there any update?

    Have you checked the link?

    Best Regards,

    CY


    TechNet Community Support
    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Saturday, August 20, 2016 2:27 PM
  • Hi Chris,
    sorry i was on vacation :)
    I did check the links but unfortunately I didn't find a solution.
    I'll try again today.
    Maybe I'll have to remove the blob from the the 2013 Farm
    I'll let you know
    Thanks
    Cinzia
    • Edited by CinziaTa Monday, August 29, 2016 8:36 AM
    Monday, August 29, 2016 7:51 AM
  • Hi Chris,

    unfortunately I'm still stuck with this error. 
    I have tried the steps in the articles you suggested without luck, anyway I don't want to disable the RBS.

    I have the same structure in the 2016 Farm and in the 2013 Farm, when I restore the DB SQL create the Storage folder in the correct disc.
    The only difrence is the domain SV for test and COMP for production, I did run this command:

    USE WSS_Content
    GO
    GRANT select, control on [mssqlrbs_resources].[rbs_work_all_blobs_used_view] to public;
    
    
    USE WSS_Content
    GO
    ALTER USER "COMP\USRSVC_SPFarm" WITH LOGIN = "SV\USRSVC_SPFarm";
    ALTER USER "COMP\USRSVC_SPService" WITH LOGIN = "SV\USRSVC_SPServices";

    The error is still the same
    Exception: Could not find object '[mssqlrbs_resources].[rbs_work_all_blobs_used_view]' or you do not have permission.  

    Thanks
    Cinzia


    • Edited by CinziaTa Tuesday, August 30, 2016 1:34 PM
    Tuesday, August 30, 2016 1:31 PM
  • Hi, I've tried to run the SQL procedure that gives the error directly in SQL.

    I get the error even in SQL but, if I run the Mount-SPContentDatabase command after the SQL procedure, the upgrade ends without error.

    That's weird

    Thursday, September 1, 2016 2:03 PM
  • Hello CinziaTa,

    I am facing the same error. Can you please help me to know the resolution you tried?

     Could not find object '[mssqlrbs_resources].[rbs_work_all_blobs_used_view]' or you do not have permission.

    Thanks!


    Shri07

    Wednesday, March 29, 2017 4:34 AM