Databases in compatibility mode (Business Data Catalog DB)

The prescribed cure for the BDC database not upgraded after the application of a CU is to run the Powershell cmdlet below. However, I have found that this does not always permit the operation to run and errors as shown in red.

PS C:\Users\spsetup> (Get-SPDatabase | ?{$_.type -eq “Microsoft.SharePoint.Busin

Exception calling “Provision” with “0” argument(s): “Cannot open database
“SP2013_BusinessDataCatalog” requested by the login. The login failed.
Login failed for user ‘DOMAIN\spSetup’.”
At line:1 char:1
+ (Get-SPDatabase | ?{$_.type -eq
“Microsoft.SharePoint.BusinessData.SharedService …
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [], MethodInvocationException
+ FullyQualifiedErrorId : SqlException

The trick to getting past this error is to STOP the BDC service first, run the cmdlet, then START the BDC service back up. Obviously this stop/start can also be done in PS on either side of the snippet above.


About generation12

I am a SharePoint/.NET consultant in the twin cities.
This entry was posted in Uncategorized and tagged . Bookmark the permalink.

Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s