• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3855
  • Last Modified:

Database is in compatibility range and upgrade is recommended

Hi!

One of our sharepoint db's is not upgraded after installing the February CU for Sharepoin 2010.

When I run this command: Get-SPDatabase | ?{$_.NeedsUpgrade -eq $true} | Select Name it returns one Name; "WSS_Search".

I then proceed with Get-SPContentDatabase | ?{$_.NeedsUpgrade -eq $true} | Upgrade-SPContentDatabase which returns nothing.

We have tried running the configuration/upgrade wizard but that made no difference. Originally the list of databases requiring an upgrade was longer, but after running the upgrade wizard the only remaining database is "WSS_Search".

How can I upgrade this database?
0
cegeland
Asked:
cegeland
  • 8
  • 6
1 Solution
 
abdulwriteCommented:
Hi,

Run this command: psconfig –cmd upgrade –inplace b2b –wait –force

FYI : (http://www.chandima.net/Blog/archive/2011/01/21/sharepoint-server-updates-for-sp2010-aka-cumulative-updates%E2%80%93should-i-apply-them.aspx)

Cheers,
AH
0
 
cegelandAuthor Commented:
Thanks for your reply.

I run the command but it does not seem to work:

SharePoint Products Configuration Wizard version 14.0.4762.1000. Copyright (C) M
icrosoft Corporation 2010. All rights reserved.

The -cmd command is invalid.

Usage:
        PSCONFIG.EXE -cmd <Command> [Parameters]
        PSCONFIG.EXE -help [Command]
        PSCONFIG.EXE -?
Commands:
        setup
        standaloneconfig
        configdb
        helpcollections
        secureresources
        services
        installfeatures
        adminvs
        upgrade
        evalprovision
        applicationcontent
        quiet
0
 
abdulwriteCommented:
Hi,

Use the SharePoint Management Shell. don't use the command prompt.

Run this command in SP Mgmt Shell: psconfig.exe –cmd upgrade –inplace b2b –wait –force

Cheers,
AH
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
cegelandAuthor Commented:
Hi!
That's what I'm doing. I run the Sharepoint 2010 Management Shell as Administrator and when I run the command I get the error:
PS C:\Users\Admin> psconfig.exe -cmd upgrade -inplace b2b -wait -force
SharePoint Products Configuration Wizard version 14.0.4762.1000. Copyright (C) M
icrosoft Corporation 2010. All rights reserved.

The -cmd command is invalid.

Usage:
        PSCONFIG.EXE -cmd <Command> [Parameters]
        PSCONFIG.EXE -help [Command]
        PSCONFIG.EXE -?
Commands:
        setup
        standaloneconfig
        configdb
        helpcollections
        secureresources
        services
        installfeatures
        adminvs
        upgrade
        evalprovision
        applicationcontent
        quiet
PS C:\Users\Admin>

Open in new window

0
 
abdulwriteCommented:
Yeah. Here is the trick

instead of psconfig.exe use PSCONFIG.EXE (upper caes)

PS C:\PSCONFIG.EXE –cmd upgrade –inplace b2b –wait
0
 
abdulwriteCommented:
don't copy and paste. Just type the command
0
 
cegelandAuthor Commented:
Ok, thanks. Didn't know there was a difference in upper/lowercase :)

I now get this error after running PSCONFIG.EXE –cmd upgrade –inplace b2b –wait;
05/09/2011 08:06:18  1  ERR          Failed to upgrade SharePoint Products.
An exception of type Microsoft.SharePoint.Administration.SPUpdatedConcurrencyException was thrown.  Additional exception information: An update conflict has occurred, and you must re-try this action. The object SPUpgradeSession Name=Upgrade-20110509-080558-266 was updated by PXO\kikador, in the PSCONFIG (13412) process, on machine PXO02.  View the tracing log for more information about the conflict.
Microsoft.SharePoint.Administration.SPUpdatedConcurrencyException: An update conflict has occurred, and you must re-try this action. The object SPUpgradeSession Name=Upgrade-20110509-080558-266 was updated by Domain\Admin in the PSCONFIG (13412) process, on machine PXO02.  View the tracing log for more information about the conflict.
   at Microsoft.SharePoint.Administration.SPConfigurationDatabase.StoreObject(SPPersistedObject obj, Boolean storeClassIfNecessary, Boolean ensure)
   at Microsoft.SharePoint.Administration.SPConfigurationDatabase.Microsoft.SharePoint.Administration.ISPPersistedStoreProvider.PutObject(SPPersistedObject persistedObject, Boolean ensure)
   at Microsoft.SharePoint.Administration.SPPersistedObject.BaseUpdate()
   at Microsoft.SharePoint.Upgrade.SPUpgradeSession.Update()
   at Microsoft.SharePoint.Upgrade.SPUpgradeSession.ContinueOnLocalThread(Guid id, Boolean consoleOutput)
   at Microsoft.SharePoint.Upgrade.SPManager.ContinueSessionOnLocalThread(Guid id, Boolean consoleOutput)
   at Microsoft.SharePoint.PostSetupConfiguration.UpgradeTask.Run()
   at Microsoft.SharePoint.PostSetupConfiguration.TaskThread.ExecuteTask()

05/09/2011 08:06:18  1  ERR          One or more configuration tasks has failed or some tasks were not run

05/09/2011 08:06:18  1  ERR          Configuration of SharePoint Products failed.  Configuration must be performed in order for this product to operate properly.  To diagnose the problem, review the extended error information located at C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\LOGS\PSCDiagnostics_5_9_2011_8_5_23_524_945331550.log, fix the problem, and run this configuration wizard again.

Open in new window

0
 
cegelandAuthor Commented:
Does anybody know what could be causing this error?

Thanks :)
0
 
cegelandAuthor Commented:
I believe this error occured after installing the Sharepoint 2010 February CU.

Any suggestions greatly appreciated :)
0
 
abdulwriteCommented:
1. Reboot the farm.
2. Run the Configuration wizard in all server.

0
 
cegelandAuthor Commented:
I rebooted the farm and ran the configuration wizard. Completed successfully but the status of WSS_Search (SPSearchDatabase) remains "Database is in compatibility range and upgrade is recommended"
0
 
cegelandAuthor Commented:
Is there anything else that can be done to upgrade this database?
0
 
abdulwriteCommented:
FEB CU successfully updated except Search DB.  Check the Search DB permission.
0
 
cegelandAuthor Commented:
Which permissions are required on the SPSearchDatabase?
0
 
isradiusCommented:
What's the status of this question, I am in the same boat?
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

  • 8
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now