SharePoint databases report ‘Database is in compatibility range and upgrade is recommended’ after upgrade

Following on from previous blog and day 2 of upgrade found some of the databases were reporting the following error:

Database is in compatibility range and upgrade is recommended

This was appearing on non content databases (as in SharePoint system databases).

This seemed strange as I mentioned in my previous blog that the upgrade had been successful so was a little perplexed to find this issue.

After a little research there didn't seem to be anything that looked to answer my problem.

Although this blog was referring to Windows 7 it was interesting in helping my trail of thought and also made me aware that you can only upgrade content databases and not just standard SharePoint system databases using PowerShell http://blogs.technet.com/b/blairb/archive/2010/07/16/patching-sharepoint-2010-on-windows-7.aspx.

Another article relating to this was found here where no solution had actually been found (at the time of blogging) http://social.technet.microsoft.com/Forums/en-IE/sharepoint2010setup/thread/7d3ee7cf-56f8-46fe-b2c9-b8662e88825a

So concluding that I could only upgrade content databases the above did not help in resolving the issue.

The two databases in question were:

Database – Type

WSS_Search - SPSearchDatabase

WSS_UsageApplication - SPUsageDatabase

I finally managed to resolve the problem by running a b2b upgrade command:

PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures

Credit to this blog (http://blog.techgalaxy.net/archives/2585) for pointing out the b2b command as I was having issues running this prior to finding this.

6 comments:

Mohd Al-Bakri said...

thx alot ,,, this fix also ( when you do upgrade and istall the SP1 , run the config wizard , check the version its still stuck on the RTM version) i did restart also the same.
i run this command , thats fix it now the server version is 61016.5002

Paul Grimley said...

Hi Mohd

Glad it helped. Thanks for sharing your experience.

Cheers
Paul

Anonymous said...

I get an upgrade successful message but I look and the database still reports it hasn't been updated. the WSS_search database just refuses to update.

Chris Howell said...
This comment has been removed by the author.
Chris Howell said...

Paul,

Thanks for sharing this. Helped me today as I was seeing this issue in one of the VM I use for writing reviews.

Cheers!

Chris

Anonymous said...

Thanks very much, saved my day!

Post a Comment