Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
0 like 0 dislike
2.8k views
in SharePoint Server by 6 6 8

I have restored a SharePoint content database in SharePoint 2019 farm that was restored successfully, but after some hours, I browsed the site collection URL but I got this error "SharePoint object [SPContentDatabase Name=WSS_Content] is in an unsupported state, and could not be used by the current farm."

SharePoint object is in an unsupported state, and could not be used by the current farm.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Microsoft.SharePoint.Upgrade.SPUpgradeCompatibilityException: SharePoint object [SPContentDatabase Name=WSS_Content] is in an unsupported state, and could not be used by the current farm.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[SPUpgradeCompatibilityException: SharePoint object [SPContentDatabase Name=WSS_Content] is in an unsupported state, and could not be used by the current farm. ]
   Microsoft.SharePoint.Administration.SPPersistedUpgradableObject.ValidateBackwardsCompatibility() +1311
   Microsoft.SharePoint.SPSite.PreinitializeServer(SPRequest request) +76
   Microsoft.SharePoint.SPWeb.InitializeSPRequest() +291
   Microsoft.SharePoint.SPWeb.EnsureSPRequest() +272
   Microsoft.SharePoint.SPWeb.get_Request() +27
   Microsoft.SharePoint.WebControls.SPControl.EnsureSPWebRequest(SPWeb web) +225
   Microsoft.SharePoint.WebControls.SPControl.SPWebEnsureSPControl(HttpContext context) +773
   Microsoft.SharePoint.ApplicationRuntime.SPRequestModule.GetContextWeb(HttpContext context) +26
   Microsoft.SharePoint.ApplicationRuntime.SPRequestModule.PostResolveRequestCacheHandler(Object oSender, EventArgs ea) +1096
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +136
   System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +195
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +88

Why I get this error and how to fix the "SharePoint object is in an unsupported state, and could not be used by the current farm." in SharePoint 2019?


1 Answer

1 like 0 dislike
by 159 200 385
selected by
 
Best answer

Solving: SharePoint object is in an unsupported state, and could not be used by the current farm.

Looks like you are using the Database Attach method to restore a Content Database from another farm that is patched with a higher version than the current farm that is not supported in SharePoint.

Solution

To avoid this error"SharePoint object [SPContentDatabase Name=WSS_Content] is in an unsupported state, and could not be used by the current farm.", you have to ensure first the current farm build number must be as same as or higher than the source farm build number.

SharePoint Farm Version Number

To get the current farm build number, check How to find SharePoint Farm Build Version

In your case, you have to do one of the three solutions before backup and restoring a content database using the Attach database upgrade method as the following:

  1. Install the latest cumulative update on both farms to ensure that the farm build number is the same! (Supported Solution)
  2. Patching the lower farm build number with the same update in the destination build number. (Supported Solution).

    Read also Patching SharePoint Farm Considerations

  3. If it's a learning farm and you just need a quick solution to fix this error, so you can change the Versions table in the restored content database with the same version details of another database in the same farm (Unsupported Solution, I don't recommend to do it, and never use it in Production Environment)
    SharePoint object Database is in an unsupported state, and could not be used by the current farm.

    This workaround requires IISReset and restarting the SharePoint Timer Jobs Service
    For more details, please check This content database has a schema version which is not supported in this farm SharePoint


See Also

If you don’t ask, the answer is always NO!
...