Friday, April 11, 2014

SharePoint Designer 2013: Business Data Connectivity Metadata Store is Currently Unavailable

When using SharePoint Designer 2013 to create External Content Types, you may find yourself getting a message similiar to the following:



The Business Data Connectivity Metadata Store is currently unavailable.


First make sure that you have the Business Data Connectivity Service Application created in Central Admin:


Though the business data connectivity service application has been created and you are getting same kind of issue.
Here is the Solution

Create a new business Data Connectivity service application and provide the permissions required, then you are good to go

Return to Sharepoint Designer 2013 and the External Content Types displayed
 Clicking on New External Content Type no longer will give you an error.

8 comments:

  1. I also was using sharepoint, but now i prefer virtual data rooms. I use Ideals virtual data room and it gives even more possibilities, than other cloud services.

    ReplyDelete
  2. Honestly, I’m tired of theoretical sessions. I am specifically looking for AWS live project training in electronic city because I want to see how to handle production-grade incidents. Do you guys run CI/CD pipelines for a live project, and do you simulate disasters (like region failures) during the course? I want real experience, not just slides.

    ReplyDelete
  3. The detail about recreating the Business Data Connectivity service application with the needed permissions, rather than only checking that it exists in Central Admin, is the useful part here. The follow-up that External Content Types reappear in Designer 2013 makes the fix easy to verify. This is a short note from the team behind Lagos Life Game Wiki.

    ReplyDelete
  4. The message reads like the Business Data Connectivity service is missing, but the post makes clear it can still appear after that service application already exists in Central Admin. That ordering is the useful bit: confirm the application is there first, and only then rebuild it with the required permissions if the error survives. A short note from the team behind Zombie Couple Video.

    ReplyDelete
  5. The post's clearest confirmation comes at the end rather than the start: after the Business Data Connectivity service application is rebuilt with the needed permissions, the External Content Types list shows up again in Designer 2013 and clicking New External Content Type no longer throws the error. That gives a concrete way to tell the fix actually took effect instead of judging only from Central Admin. A short note from the team behind this football game.

    ReplyDelete
  6. The fix here stays entirely inside Central Admin: the post never asks you to repair or reinstall Designer 2013, and once the new Business Data Connectivity service application is created with the required permissions, you only need to return to Designer for External Content Types to list again. It is also worth noting the post does not say which permission was actually missing, so it reads as a quick workaround rather than a diagnosis. A short note from the team behind this meme tool.

    ReplyDelete
  7. The message names the metadata store, but the remedy in the post never touches the store directly: it starts with whether the Business Data Connectivity service application exists in Central Admin, then replaces that application with a new one plus the required permissions if the error survives. The only confirmation offered is back in Designer 2013, where External Content Types reappear and New External Content Type stops erroring. A short note from the team behind Pirate Shop Token.

    ReplyDelete
  8. The wording "currently unavailable" reads like a temporary outage you could simply wait out, yet the remedy described here is to build a brand-new Business Data Connectivity service application with the required permissions instead of retrying the old one. The only confirmation the post offers is back in Designer 2013, where External Content Types list again and New External Content Type stops erroring. A short note from the team behind this meme tool.

    ReplyDelete