6

I have a bunch of site collections for my single web application and when I run Full Synchronization of users using the User Profile Synchronization service the information in each site collection's User Information List is NOT updated. The information is moved correctly from Active Directory to the User Profile DB because I see values like "Manager" and "Office" get updated but when I look at the user on any of the site collections those values are empty. I've also read an answer from Clayton Cobb on this Microsoft forum question stating that the User Profile Synchronization and User Information List are not related. Is there a way to correctly synchronize between these two locations?

13

There are two jobs, User Profile to SharePoint Quick Sync and User Profile to SharePoint Full Sync, that synchronize the User Profile database information with the UIL. Sometimes this stops working (properly) and in that case you need to run:

stsadm -o sync -listolddatabases 0
stsadm -o sync -deleteolddatabases 0

The first command will list Content Databases that haven't had the UPA -> UIL sync occur in 0 or more days. The second command will delete the records corresponding to those databases (it doesn't delete databases/end user data).

  • I had tried this multiple times before as I have seen this solution on other sites and it had not worked. However I just tried it again and it was successfully updated. I guess that the Quick Profile Sync is not very reliable. Thanks for the help! – skeletank Jun 11 '12 at 14:52
  • 1
    Just out of curiosity, is there a PowerShell equivalent to the STSADM sync command?? – Matthew McDermott Jun 12 '12 at 13:01
  • Nothing provided out of the box. – Trevor Seward Jun 12 '12 at 16:39
  • Not working for me. Database records are cleaned up but even manually running the Quick Synchronization timer job didn't sync the two. – Toadmyster Aug 8 '12 at 19:16
  • 1
    Users are never deleted from the UIL. Users are always present in the UIL if they're referenced in any sort of fashion on the Site Collection (e.g. in a Person or Group column, or added to permissions on the site or an object). – Trevor Seward Jun 8 '16 at 18:05
4

Microsoft has added an article on how to Reset profile synchronization using powershell Maintain user profile synchronization settings in SharePoint Server 2013

To get the User Profile Service application object, type the following command:

$upa = Get-spserviceapplication <identity>

To view the users and groups to delete, type the following command:

Set-SPProfileServiceApplication $upa -GetNonImportedObjects $true

To delete the obsolete users and groups, type the following command:

This action cannot be undone.

Set-SPProfileServiceApplication $upa -PurgeNonImportedObjects $true
  • 1
    @BennySkogberg thanks for cleaning up my answer. I'll make sure to not just post a link in the future, but also the relevant content from the linked source. – Peter Mendez May 3 '17 at 17:58
  • Super! And the answer helped me too :) +1 – Benny Skogberg May 3 '17 at 18:24
0

For me the only solution worked was Provisioning a new user profiles Service Application.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.