Error in Central Admin when trying to open the Managed Metadata service application:
The Managed Metadata Service or Connection is currently not available. The Application Pool or Managed Metadata Web Service may not have been started. Please Contact your Administrator.
Error in ULS log:
Failed to get term store for proxy ‘Managed Metadata Service’. Exception: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
I searched the internet and many posts I came across advised to fully recreate the service. Apparently, there’s no need for that. The best and easiest solution I found was on Are Flyen’s blog
I followed his steps:
These steps solved the issue for me:
- Go to “Central Administration” and select “Manage service applications”.
- Select your Managed Metadata service application, in my case with almost that name and the button “Properties”:
- Locate the “Database name” and change this one to for example “SP2013_MetaData_NEW”. Remember to take a note of the old database name for the next steps:
- Select “OK” and give it some time. SharePoint now creates a new database for you with the name selected above. When it has completed, try to open the service application (Manage) and it now should open without problems, but as expected with an empty term store.
- Go back to the list over service applications and repeat step 2. Now enter the old database name instead, in my case “SP2013_MetaData” and select “OK”.
- Wait some more an access the service application again (Manage). For me it looked like nothing had changed and I now only saw the new database, but I was missing permissions.
- Locate the “Term store administrators” and at least add your admin user here:
- Select “Save” and now with the correct permissions you should have access to the existing Term Store and the service application would be back to normal.
Credit goes to Are Flyen this time!