Error messages in multiple languages when setting user profile properties using PnP-PowerShell

%3CLINGO-SUB%20id%3D%22lingo-sub-57653%22%20slang%3D%22en-US%22%3EError%20messages%20in%20multiple%20languages%20when%20setting%20user%20profile%20properties%20using%20PnP-PowerShell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-57653%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20currently%20setting%20up%26nbsp%3Bcustom%20user%20profile%20replication%20from%20SharePoint%202013%20to%26nbsp%3BSharePoint%20Online%26nbsp%3Bfor%20a%20customer.%20I%20have%20implemented%20this%26nbsp%3Busing%20PnP-PowerShell%20and%20the%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FSharePoint%2FPnP-PowerShell%2Fblob%2Fmaster%2FDocumentation%2FSetPnPUserProfileProperty.md%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2FSharePoint%2FPnP-PowerShell%2Fblob%2Fmaster%2FDocumentation%2FSetPnPUserProfileProperty.md%3C%2FA%3E.%20The%20script%20iterates%20over%2014%2C000%20on-prem%20profiles%20(from%20a%20search%20result)%20and%20sets%204%20custom%20user%20profile%20properties%20in%20SarePoint%20Online.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20looking%20at%20the%20error%20log%20my%20script%20produced%2C%20I%20see%20that%20several%20of%20the%20user%20profiles%20doesn't%20exist%20in%20SharePoint%20Online%2C%20and%20this%20is%20expected.%20What%20I%20didn't%20expect%20is%20to%20get%20the%26nbsp%3Berror%20messages%20in%20other%20languages%20than%20english.%20Here%20are%20some%20examples%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EUser%20Profile%20Error%201000%3A%20User%20Not%20Found%3A%20Could%20not%20load%20profile%20data%20from%20the%20database.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EUser%20Profile%20Error%201000%3A%20Det%20gick%20inte%20att%20hitta%20anv%C3%A4ndaren%3A%20Det%20gick%20inte%20att%20l%C3%A4sa%20in%20profildata%20fr%C3%A5n%20databasen.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EUser%20Profile%20Error%201000%3A%20Der%20Benutzer%20wurde%20nicht%20gefunden%3A%20Die%20Profildaten%20aus%20der%20Datenbank%20konnten%20nicht%20geladen%20werden.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EUser%20Profile%20Error%201000%3A%20Gebruiker%20niet%20gevonden%3A%20kan%20de%20profielgegevens%20niet%20ophalen%20uit%20de%20database.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EUser%20Profile%20Error%201000%3A%20Utilisateur%20introuvable%26nbsp%3B%3A%20impossible%20de%20charger%20les%20donn%C3%A9es%20du%20profil%20de%20la%20base%20de%20donn%C3%A9es.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EUser%20Profile%20Error%201000%3A%20Brugeren%20blev%20ikke%20fundet%3A%20Profildataene%20kunne%20ikke%20indl%C3%A6ses%20fra%20databasen.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EUser%20Profile%20Error%201000%3A%20Utente%20non%20trovato.%20Impossibile%20caricare%20i%20dati%20del%20profilo%20dal%20database.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EUser%20Profile%20Error%201000%3A%20%D0%9F%D0%BE%D0%BB%D1%8C%D0%B7%D0%BE%D0%B2%D0%B0%D1%82%D0%B5%D0%BB%D1%8C%20%D0%BD%D0%B5%20%D0%BD%D0%B0%D0%B9%D0%B4%D0%B5%D0%BD.%20%D0%9D%D0%B5%20%D1%83%D0%B4%D0%B0%D0%BB%D0%BE%D1%81%D1%8C%20%D0%B7%D0%B0%D0%B3%D1%80%D1%83%D0%B7%D0%B8%D1%82%D1%8C%20%D1%81%D0%BE%D0%B4%D0%B5%D1%80%D0%B6%D0%B8%D0%BC%D0%BE%D0%B5%20%D0%BF%D1%80%D0%BE%D1%84%D0%B8%D0%BB%D1%8F%20%D0%B8%D0%B7%20%D0%B1%D0%B0%D0%B7%D1%8B%20%D0%B4%D0%B0%D0%BD%D0%BD%D1%8B%D1%85.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIs%20there%20anything%20I%20can%20do%20to%20get%20the%20errors%20in%20english%20only%2C%20is%20this%20expected%20behaviour%20or%20a%20%22bug%22%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-57653%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EHybrid%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-853990%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20messages%20in%20multiple%20languages%20when%20setting%20user%20profile%20properties%20using%20PnP-PowerShell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-853990%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F10727%22%20target%3D%22_blank%22%3E%40Petter%20Skodvin-Hvammen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDid%20this%20ever%20get%20solved%3F%20I%20get%20the%20same%20error.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-57777%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20messages%20in%20multiple%20languages%20when%20setting%20user%20profile%20properties%20using%20PnP-PowerShell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-57777%22%20slang%3D%22en-US%22%3E%3CP%3EI%20meant%20to%20say%20I'm%20running%20out%20of%20ideas%20%3B)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20your%20script%20where%20you%20update%20the%20many%201000s%20profiles.%20Can%20you%20find%20out%20which%20user%20profile%20you've%20been%20updating%3F%20Could%20it%20be%20that%20you%20removed%20the%20user%20profile%20but%20somehow%20there%20is%20still%20something%20left%20of%20the%20user%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20also%20seen%20every%20now%20and%20then%20Office%20365%20using%20foreign%20language%20bits%20in%20the%20admin%20center.%20A%20bit%20like%20someone%20is%20testing%20multiple%20languages%20out%20on%20tenants.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-57769%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20messages%20in%20multiple%20languages%20when%20setting%20user%20profile%20properties%20using%20PnP-PowerShell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-57769%22%20slang%3D%22en-US%22%3E%3CP%3EWell%2C%26nbsp%3Bthat's%20a%20classic%20%22it%20works%20in%20my%20environment%22%20statement%26nbsp%3B%3DD%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaybe%20this%20only%20occurs%20in%20tenants%20with%20users%20from%20multiple%20regions%26nbsp%3Band%20multiple%20languages.%20I%20don't%20know%2C%20but%20it's%20making%20the%20life%20of%20our%20administrators%20hard%2C%20as%20they%20would%20need%20to%20manage%20the%20languages%20of%20the%20world.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPS!%20We%20also%20have%20one%20instance%20of%20a%20sharing%20notification%20email%20in%20Italian.%26nbsp%3BHaven't%20figured%20out%20what%20happened%20there%20either.%20The%20user%20who%20shared%20was%20Dutch%2C%20and%20the%20same%20was%20the%20user%20he%20shared%20to.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-57718%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20messages%20in%20multiple%20languages%20when%20setting%20user%20profile%20properties%20using%20PnP-PowerShell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-57718%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F10727%22%20target%3D%22_blank%22%3E%40Petter%20Skodvin-Hvammen%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20just%20tried%20the%20same%20on%20a%20few%20of%20my%20tenants%20and%20I'm%20not%20finding%20the%20same%20issue.%20All%20my%20errors%20seems%20to%20be%20in%20english.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-57715%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20messages%20in%20multiple%20languages%20when%20setting%20user%20profile%20properties%20using%20PnP-PowerShell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-57715%22%20slang%3D%22en-US%22%3E%3CP%3ERandom%20languages.%26nbsp%3BMy%20script%20invokes%20the%20cmdlet%20approximately%2060%2C000%20times%2C%20and%20I%20get%202%2C500%20errors.%20The%20languages%20are%26nbsp%3Bunrelated%20to%20the%20user%20profiles%20that%20are%20not%20found.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-57693%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20messages%20in%20multiple%20languages%20when%20setting%20user%20profile%20properties%20using%20PnP-PowerShell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-57693%22%20slang%3D%22en-US%22%3E%3CP%3EDo%20you%20get%20all%20error%20messages%20by%20running%20a%20single%20Set-PnPUserProfileProperty%20Cmdlet%3F%20Or%20do%20you%20get%20messages%20returned%20in%20random%20languages%20while%20you%20runt%20the%20Cmdlet%20many%20times%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-854081%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20messages%20in%20multiple%20languages%20when%20setting%20user%20profile%20properties%20using%20PnP-PowerShell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-854081%22%20slang%3D%22en-US%22%3Ei%20have%20no%20idea.%20It's%20more%20than%20two%20years%20since%20I%20last%20worked%20on%20this%2C%20but%20it%20wasn't%20resolved%20back%20then.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

I'm currently setting up custom user profile replication from SharePoint 2013 to SharePoint Online for a customer. I have implemented this using PnP-PowerShell and the https://github.com/SharePoint/PnP-PowerShell/blob/master/Documentation/SetPnPUserProfileProperty.md. The script iterates over 14,000 on-prem profiles (from a search result) and sets 4 custom user profile properties in SarePoint Online.

 

When looking at the error log my script produced, I see that several of the user profiles doesn't exist in SharePoint Online, and this is expected. What I didn't expect is to get the error messages in other languages than english. Here are some examples:

 

User Profile Error 1000: User Not Found: Could not load profile data from the database.
User Profile Error 1000: Det gick inte att hitta användaren: Det gick inte att läsa in profildata från databasen.
User Profile Error 1000: Der Benutzer wurde nicht gefunden: Die Profildaten aus der Datenbank konnten nicht geladen werden.
User Profile Error 1000: Gebruiker niet gevonden: kan de profielgegevens niet ophalen uit de database.
User Profile Error 1000: Utilisateur introuvable : impossible de charger les données du profil de la base de données.
User Profile Error 1000: Brugeren blev ikke fundet: Profildataene kunne ikke indlæses fra databasen.
User Profile Error 1000: Utente non trovato. Impossibile caricare i dati del profilo dal database.

User Profile Error 1000: Пользователь не найден. Не удалось загрузить содержимое профиля из базы данных.

 

Is there anything I can do to get the errors in english only, is this expected behaviour or a "bug"?

7 Replies
Highlighted

Do you get all error messages by running a single Set-PnPUserProfileProperty Cmdlet? Or do you get messages returned in random languages while you runt the Cmdlet many times?

Highlighted

Random languages. My script invokes the cmdlet approximately 60,000 times, and I get 2,500 errors. The languages are unrelated to the user profiles that are not found.

Highlighted

Hi @Petter Skodvin-Hvammen,

 

I just tried the same on a few of my tenants and I'm not finding the same issue. All my errors seems to be in english. 

Highlighted

Well, that's a classic "it works in my environment" statement =D

 

Maybe this only occurs in tenants with users from multiple regions and multiple languages. I don't know, but it's making the life of our administrators hard, as they would need to manage the languages of the world.

 

PS! We also have one instance of a sharing notification email in Italian. Haven't figured out what happened there either. The user who shared was Dutch, and the same was the user he shared to.

Highlighted

I meant to say I'm running out of ideas ;)

 

In your script where you update the many 1000s profiles. Can you find out which user profile you've been updating? Could it be that you removed the user profile but somehow there is still something left of the user? 

 

I've also seen every now and then Office 365 using foreign language bits in the admin center. A bit like someone is testing multiple languages out on tenants.

Highlighted
Highlighted
i have no idea. It's more than two years since I last worked on this, but it wasn't resolved back then.