We were working in a project where we had to working in a multicultural language, in this case we were using Spanish and English. The problem was that we had several metadata terms in the store, but only it were in one language (in Spanish), so we add more terms to have the English translation, but when we try to switch the language it always showed the terms in Spanish and not in English, so I had to discover what is happening.
First of all, I tried to run manually the job “Taxonomy Update Scheduler ” but it did nothing, so I tried to access to the Taxanomy Hidden list to see what was happening.
To those people who do not know how to access to the Taxonomy Hidden list, navigate to: [site url]/Lists/TaxonomyHiddenList/AllItems.aspx
The list by default has read access to all NTAuthenticated users. Make sure to verify this when your users have issues with using the metadata taxonomy service.
Also, the list contains only the taxonomy terms that were actually used anywhere in your site collections. That means when you are using a taxonomy term for the first time in any list, that term gets added as a new list item in the taxonomy hidden list.
This list contains the following fields to store the data about the taxonomy terms:
As you can see, it appears two time the same term in different languages (1033 and 3082), so the problem was there. There is a method to update the terms in the Taxanomy hidden list?
The answer is yes, and you guess it right the method is: PowerShell! So we need to execute the following code:
$siteurl=”yourappweburl”
Get-SPWebApplication $siteUrl | Get-SPSite -limit ALL | foreach {
[Microsoft.SharePoint.Taxonomy.TaxonomySession]::SyncHiddenList($_)
}
Once this code has been executed, we need to refresh the browser and access again to the same term, and voilà we have the terms updated.
If you want more info please refer the following links:
https://blogs.msdn.microsoft.com/kaushalendra/2012/10/16/how-to-sync-taxonomy-hidden-list-using-powershell/
https://prashobjp.wordpress.com/2013/09/30/updating-sharepoint-managed-metadata-term-hidden-value/
http://sharepoint-relieved.blogspot.com.es/2014/09/taxonomy-update-scheduler-not-working.html
Till the nex time!
Albandrod's Memory 