Update Terms - Specified argument was out of the range of valid values (lcid)

[SPSwpd]

Hi! Great Tool, helped me to export the TermStore Informations in the past, but I wanted to update Labels (Synonyms) now the first time and it ends always with an error.

I have created an Excel Export File with Simple Format at first, then I only fill one Word in each Item in Column "TermLabels" save again as XLSX. Make sure that the TermStore Configuration is set to english (1033) - I do not have to change it, because we are only using 1033.

Choose the TermSet in MMD Connection and start Update Terms with the updated Excel File.

It ends always with this error message for each item in selected TermStore:

*** ERROR updating syncing Term Labels: Microsoft.SharePoint.Client.ServerException: Specified argument was out of the range of valid values. Parameter name: lcid bei Microsoft.SharePoint.Client.ClientRequest.ProcessResponseStream(Stream responseStream) bei Microsoft.SharePoint.Client.ClientRequest.ProcessResponse() bei SPTaxonomyToolsOnline.Form1.UpdateTerms()

I have tested import too and it ends with error too.

*** ERROR creating new term: Microsoft.SharePoint.Client.ServerException: Specified argument was out of the range of valid values. Parameter name: lcid bei Microsoft.SharePoint.Client.ClientRequest.ProcessResponseStream(Stream responseStream) bei Microsoft.SharePoint.Client.ClientRequest.ProcessResponse() bei SPTaxonomyToolsOnline.Form1.ImportTermsSimple()

Nice to know:

• Our SharePoint Server (2013 on-premises) is Windows Server 2012 R2 installed in lcid 1033 without Office.
• Run SPTaxonomyTools Online on SPS.
• Start Export Excel.
• Copy File to Windows System lcid 1031 with active 1033 office language package.
• Change Excel File and save.
• Copy Excel File from Windows Client to SPS.
• Start Update and end in error.

I did not found out how to solve this. May you can help me with this Issue

Best Regards SPSwpd

[rigpd001]

I am also having the same issue

[acbenson]

did anyone solve this by any chance? keen to know as this would save me a lot of angst

[DovydasADL]

I have this issue too. I guess this is because of your system locale settings (language code LCID) and you Term Store default language code. If you are using English as default and only one language in Term Store, then try setting your Local PC system locale also to English.