locked
error when disabling remote blob storage - powershell RRS feed

  • Question

  • I'm using this post to report a bug I found in SharePoint today. The bug manifests itself when you try to disable Remote Blob Storage (RBS).

    According to this article, the following PowerShell commands can be used to disable RBS on a content database:

    $cdb=Get-SPContentDatabase WSS_Content
    $rbss=$cdb.RemoteBlobStorageSettings
    $rbss.GetProviderNames()
    $rbss.SetActiveProviderName("")
    $rbss.Migrate()

    The commands seem to work, but there's an error that appears in the error log when this script runs. In particular, the following command causes the problem:


    Here's the error that occurs:

    Log Name:      Application
    Source:        Microsoft-SharePoint Products-SharePoint Foundation
    Date:          2020/9/29 13:44:26
    Event ID:      5586
    Task Category: Database
    Level:         Error
    Keywords:     
    User:          XXXXXXXXXXXXXXXXXXXXX
    Computer:      XXXXXXXXXXXXXXXXXXXX.com
    Description:
    Unknown SQL Exception 201 occurred. Additional error information from SQL Server is included below.

    Procedure or function 'proc_SetDatabaseInformation' expects parameter '@Value', which was not supplied.

    So the problem occurs when SharePoint calls the proc_SetDatabaseInformation stored procedure. It's likely the code that's making the stored procedure call isn't properly handling the OUTPUT parameter.

    Tuesday, September 29, 2020 5:46 AM

All replies