SOLVED

The Business Data Connectivity Metadata store is currently unavailable. (External SharePoint List)

%3CLINGO-SUB%20id%3D%22lingo-sub-780648%22%20slang%3D%22en-US%22%3EThe%20Business%20Data%20Connectivity%20Metadata%20store%20is%20currently%20unavailable.%20(External%20SharePoint%20List)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-780648%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20create%20an%20external%20SharePoint%20list%20to%20a%20SQL%20Table%20(Done%20this%20before).%20However%2C%20when%20trying%20to%20complete%20the%20step%20of%20External%20Content%20Type%20I%20am%20having%20no%20luck%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EConnecting%20to%20SharePoint%20Online%20through%20the%20Designer%20tool%20then%20navigating%20to%20External%20Content%20Types%20is%20not%20working%20for%20me.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20first%20get%3A%3C%2FP%3E%3CP%3EThe%20Business%20Data%20Connectivity%20Metadata%20store%20is%20currently%20unavailable.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20I%20get%20the%20following%20when%20clicking%20%22External%20Content%20Type%22%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20HTTP%20Service%20located%20at%20https%3A%2F%2F%3CORG%3E.sharepoint.com%2F_vti_bin%2FBDCAdminService.svc%20is%20unavailable.%20This%20could%20be%20because%20the%20service%20is%20too%20busy%20or%20because%20no%20endpoint%20was%20found%20listening%20at%20the%20specified%20address.%20Please%20ensure%20that%20the%20address%20is%20correct%20and%20try%20accessing%20the%20service%20again%20later.%20(The%20remote%20server%20returned%20an%20error%3A%20(503)%20Server%20Unavailable.%3C%2FORG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-780648%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Ebcs%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Designer%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-780822%22%20slang%3D%22en-US%22%3ERe%3A%20The%20Business%20Data%20Connectivity%20Metadata%20store%20is%20currently%20unavailable.%20(External%20SharePoint%20Lis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-780822%22%20slang%3D%22en-US%22%3ENo%20much%20we%20can%20do%20here%20to%20help%20you%2C%20just%20open%20a%20support%20ticket%20reporting%20the%20issue%20so%20Microsoft%20support%20folks%20can%20help%20you...one%20side%20note%3A%20BCS%20is%20one%20of%20the%20SPO%20services%20that%20has%20not%20been%20modified%20for%20a%20while%20and%20it's%20not%20clear%20what%20it's%20going%20to%20happen%20with%20it%20so%20if%20you%20can%20use%20other%20ways%20to%20integrate%20external%20data%2C%20I%20would%20recommend%20to%20go%20for%20them%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-781303%22%20slang%3D%22en-US%22%3ERe%3A%20The%20Business%20Data%20Connectivity%20Metadata%20store%20is%20currently%20unavailable.%20(External%20SharePoint%20Lis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-781303%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F60%22%20target%3D%22_blank%22%3E%40Juan%20Carlos%20Gonz%C3%A1lez%20Mart%C3%ADn%3C%2FA%3EThanks%20Juan.%20The%20problem%20was%20on%20Microsoft's%20side%20they%20actually%20have%20a%20notification%20message%20in%20the%20Info%20centre.%20Their%20support%20was%20really%20quick%20getting%20back%20to%20me%20(5min)%20after%20putting%20a%20ticket%20in%20through%20the%20portal.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20know%20any%20other%20method%20of%20pulling%20a%20table%20from%20Azure%20SQL%20to%20populate%20a%20SharePoint%20column%20without%20using%20BCS%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I'm trying to create an external SharePoint list to a SQL Table (Done this before). However, when trying to complete the step of External Content Type I am having no luck

 

Connecting to SharePoint Online through the Designer tool then navigating to External Content Types is not working for me. 

 

I first get:

The Business Data Connectivity Metadata store is currently unavailable.

 

Then I get the following when clicking "External Content Type":

 

The HTTP Service located at https://<org>.sharepoint.com/_vti_bin/BDCAdminService.svc is unavailable. This could be because the service is too busy or because no endpoint was found listening at the specified address. Please ensure that the address is correct and try accessing the service again later. (The remote server returned an error: (503) Server Unavailable.

 

2 Replies
Highlighted
Solution
No much we can do here to help you, just open a support ticket reporting the issue so Microsoft support folks can help you...one side note: BCS is one of the SPO services that has not been modified for a while and it's not clear what it's going to happen with it so if you can use other ways to integrate external data, I would recommend to go for them
Highlighted

@Juan Carlos González MartínThanks Juan. The problem was on Microsoft's side they actually have a notification message in the Info centre. Their support was really quick getting back to me (5min) after putting a ticket in through the portal.

 

Do you know any other method of pulling a table from Azure SQL to populate a SharePoint column without using BCS?