Resolving Business Data Connectivity error: Metadata store is currently unavailable


By:   |   Updated: 2011-04-27   |   Comments   |   Related: > 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 Updated: 2011-04-27


get scripts

next tip button



About the author





Comments For This Article





download


Recommended Reading

Developer Dashboard in SharePoint 2010

Taking Control of Checked Out Documents in SharePoint

Reading SharePoint Lists with Integration Services 2017

Understanding SharePoint Exports to Excel

Recover a deleted SharePoint site or site collection with the *New* Site Recycle Bin





get free sql tips
agree to terms


Learn more about SQL Server tools