Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

Special Announcement: SQL Server Performance Tuning Tips and Tricks Webinar
 

Resolving Business Data Connectivity error: Metadata store is currently unavailable


By:   |   Read Comments   |   Related Tips: > Sharepoint

Problem

The SharePoint 2010 Business Data Connectivity Service allows connecting with external data systems (WCF service, database, .Net assemblies). This is an improved version of the Business Data Catalog in SharePoint 2007. But you can get an error...

"Business Data Connectivity metadata store is currently unavailable"

...when navigating to the External Content Types using SharePoint Designer 2010.

Solution

You can get this type of error from Windows Server 2008 or the Client OS (Windows 7) after installing SharePoint 2010 and SharePoint Designer 2010. SP Designer can throw the following exception when navigating to an External Content Type object.

sharepoint designer

Step 1

This problem can happen if your SharePoint is installed in the Windows 7 OS. You can solve this by installing the Windows6.1-KB976462-v2-x64 Hot fix. Another reason for this error would be that the (BDC) service isn’t running properly as described in Step 2.

Install Windows6.1-KB976462-v2-x64

This should resolve the BDC error.

Step 2

For Windows Server 2008, ensure all updates are installed using Microsoft Windows Update. If the the problem persists again after restarting the PC then go to Manage services on the server in SharePoint Central Administration and check the BDC and the Metadata service.

  • Central Administration -> System Settings -> Manage services on server
  • servers
  • Start the Business Data Connectivity Service and the Managed Metadata Web Service if they are stopped.
  • service status
  • Close SharePoint Designer and re-open again.

The above error should be resolved after starting SharePoint Designer.

Next Steps


Last Update:


next webcast button


next tip button



About the author





Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Learn more about SQL Server tools