Forum Discussion
Error messages in multiple languages when setting user profile properties using PnP-PowerShell
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"?
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?
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.
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.
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.
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.
- i have no idea. It's more than two years since I last worked on this, but it wasn't resolved back then.
I am facing the same issue on our tenant. We have users from all over the world.
When I try to update a user profile property and the user cannot be found, I get this message:
{"odata.error":{"code":"-1, Microsoft.SharePoint.Client.ClientServiceException","message":{"lang":"de-DE","value":"User Profile Error 1000: Utilisateur introuvable\u00a0: impossible de charger les donn\u00e9es du profil de la base de donn\u00e9es."}}}As you can see, i am in a german environment ("lang":"de-DE"), but the beginning of the message is in english and the details in french.
If I rerun my script, i get sometimes dutch or swedish messages.
Weired!
When using Power Automate flow with HTTP request to SharePoint Profile property, I am also getting an Italian text while clearly in US context. Occurs multiple times (about 736 times running on 13K8 profiles.
{
"status": 404,
"message": "{\"odata.error\":{\"code\":\"-1, Microsoft.SharePoint.Client.ClientServiceException\",\"message\":{\"lang\":\"en-US\",\"value\":\"User Profile Error 1000: Utente non trovato. Impossibile caricare i dati del profilo dal database.\"}}}\r\nclientRequestId: 0c29ae44-3ae1-4e56-95a6-34ffa0bc5ac1\r\nserviceRequestId: f25c13a1-d085-8000-4fc4-8718212d01bc",
"source": "https://lpportal.sharepoint.com/teams/lpdiaadtosposync/_api/SP.UserProfiles.PeopleManager/SetSingleValueProfileProperty",
"errors": []
}- In one run, seeing these error messages returned in 14 different languages. Looks a bug to me or is there someone in SharePoint team that can explain what happens here??
User Profile Error 1000: Kasutajat ei leitud: profiiliandmeid ei saanud andmebaasist laadida."
User Profile Error 1000: Usuario no encontrado: no se pudieron cargar los datos de perfil desde la base de datos."
User Profile Error 1000: Kasutajat ei leitud: profiiliandmeid ei saanud andmebaasist laadida."
User Profile Error 1000: Der Benutzer wurde nicht gefunden: Die Profildaten aus der Datenbank konnten nicht geladen werden."
User Profile Error 1000: User Not Found: Could not load profile data from the database."
User Profile Error 1000: \u05de\u05e9\u05ea\u05de\u05e9 \u05dc\u05d0 \u05e0\u05de\u05e6\u05d0: \u05dc\u05d0 \u05d4\u05d9\u05ea\u05d4 \u05d0\u05e4\u05e9\u05e8\u05d5\u05ea \u05dc\u05d8\u05e2\u05d5\u05df \u05e0\u05ea\u05d5\u05e0\u05d9 \u05e4\u05e8\u05d5\u05e4\u05d9\u05dc \u05de\u05de\u05e1\u05d3 \u05d4\u05e0\u05ea\u05d5\u05e0\u05d9\u05dd."
User Profile Error 1000: Gebruiker niet gevonden: kan de profielgegevens niet ophalen uit de database."
User Profile Error 1000: Utente non trovato. Impossibile caricare i dati del profilo dal database."
User Profile Error 1000: \u041f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u043d\u0435 \u043d\u0430\u0439\u0434\u0435\u043d. \u041d\u0435 \u0443\u0434\u0430\u043b\u043e\u0441\u044c \u0437\u0430\u0433\u0440\u0443\u0437\u0438\u0442\u044c \u0441\u043e\u0434\u0435\u0440\u0436\u0438\u043c\u043e\u0435 \u043f\u0440\u043e\u0444\u0438\u043b\u044f \u0438\u0437 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445."
User Profile Error 1000: Utilisateur introuvable\u00a0: impossible de charger les donn\u00e9es du profil de la base de donn\u00e9es."
User Profile Error 1000: Vartotojas nerastas: nepavyko i\u0161 duomen\u0173 baz\u0117s \u012fkelti profilio duomen\u0173."
User Profile Error 1000: Finner ikke brukeren: Kan ikke laste inn profildata fra databasen."
User Profile Error 1000: \u039f \u03c7\u03c1\u03ae\u03c3\u03c4\u03b7\u03c2 \u03b4\u03b5\u03bd \u03b2\u03c1\u03ad\u03b8\u03b7\u03ba\u03b5: \u0394\u03b5\u03bd \u03ae\u03c4\u03b1\u03bd \u03b4\u03c5\u03bd\u03b1\u03c4\u03ae \u03b7 \u03c6\u03cc\u03c1\u03c4\u03c9\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c0\u03c1\u03bf\u03c6\u03af\u03bb \u03b1\u03c0\u03cc \u03c4\u03b7 \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd."
User Profile Error 1000: Nie mo\u017cna odnale\u017a\u0107 u\u017cytkownika: nie mo\u017cna za\u0142adowa\u0107 danych profilu z bazy danych."
