Skip Ribbon Commands
Skip to main content

Markus' Blog

Jun 16
PSConfig error: The upgraded database schema doesn't match the TargetSchema

When applying a Cumulative Update to your SharePoint 2016 Farm, you might run into troubles when executing PSConfig/PSConfigUI after installing the Binaries. The error that is logged in the Windows Event Log looks as follows:

The Execute method of job definition Microsoft.SharePoint.Administration.SPUpgradeJobDefinition (ID ..) threw an exception. More information is included below.

The upgraded database schema doesn't match the TargetSchema. (Correlation=..)

You can avoid this issue if you either

  • dismount all the Content Databases before executing PSConfig/PSConfigUI (which is a good idea in larger environments anyway) and upgrade them later in a second step or
  • upgrade all the Content Databases before executing PSConfig/PSConfigUI with something like Get-SPContentDatabase | Upgrade-SPContentDatabase. You could speed up this process by using multiple PowerShell Sessions or even multiple SharePoint Servers.

With detached or already upgraded Content Databases PSConfig/PSConfigUI should run successfully.

Hallo Markus,

schon wieder vielen Dank! :)
Hatte letzte Woche das Phänomen und dein Blog hat wieder mal geholfen! :)

Andreas Z.
11/2/2016 11:26 AM
11/16/2016 8:56 PM
Awesome thanks!
11/25/2016 1:38 AM
danke, bei mir hat es dann auch geklappt, allerdings nur über - upgrade , wegen apps content datenbank
1/3/2017 4:50 PM
perfect, danke
Tristian O'B
4/18/2017 4:07 PM
Thank you!!
9/14/2017 1:00 PM


There are no comments for this post.


About me...

About this blog

My thoughts and findings about SharePoint 2016/2013/2010 and SQL Server


Markus Hintner