Navigate Up
Sign In

SharePoint 2013 March Update: BCS DB Upgrade

Item is currently unrated. Press SHIFT+ENTER to rate this item.1 star selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+ESCAPE to leave rating submit mode.2 stars selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.3 stars selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.4 stars selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.5 stars selected. Press SHIFT+ENTER to submit. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.

You may also be interested in: ViewPoint for SharePoint

 

Editor's note: Contributor Chris Grist is a SharePoint Architect at Beach Energy. Follow him @gristdog

If you have installed the mandatory March Public (uber) Update for SharePoint 2013 you may have noticed a new health analyzer warning appear.

Something along the lines of:

“Databases running in compatibility range, upgrade recommended.”

Now this will usually popup if you install a patch and forget to run psconfig and continue to use the farm and the fix is simple, however in this case it was very specific just to the BCS database.

You can upgrade content databases individually, but this database is a bit different and therefore needs a provision operation:

(Get-SPDatabase | ?{$_.type -eq “Microsoft.SharePoint.BusinessData.SharedService.BdcServiceDatabase”}).Provision()

Once this has completed you can reanalyze the health alert and it should disappear.

Categories: SPF 2013; Performance and Optimization

Comments

Humi

Thanks

Thank you so much for posting this, I was trying to figure it out why this error came up all of a sudden, good thing it was in dev.

Posted 17-Jul-2013 by Humi
Andy

Nice one liner

Hello Chris,
 
what a coincidence! Markus Hintner (http://blog.entos.at/Lists/Posts/Post.aspx?ID=14) used exactly the same one liner on his solution to this problem posted on 03/14/2013, some 13 days before your post. ;)
 
But None the less, the more often this solution is on the Net, the easier to find it is.
 
Regards.
Andy
 
PS: Ya could have mentioned him, though. ;)

Posted 06-Aug-2013 by Andy
casper

details

Every concept that has been shared by the team about the working and applications on SharePoint was useful. Being a beginner with the topic, I liked spending time on this blog post. I will be looking forward to more details http://www.suavedental.net

Posted 10-Mar-2014 by casper

Notify me of comments to this article

E-mail:
   

Add Comment

Title:

 
Comment:
Email:

   


Name:

 
Url: