SharePoint user information list is not being updated

There are running blogs out there explaining the various locations of User properties in SharePoint . mainly the UPA and the site collections hidden List called the User Information List ( HTTP: // /_ catalogs/users/detail. aspx )

when a User hits this site collection, they will automatically get a profile entry in this List . OK, great. but you have profile properties in two places now, the site collection (s) and the User profile service Pplication; how are you supposed to keep them in sync?

As it turns out,SharePointThought of that and gives us two timer jobs to do exactly that. These timer jobs areUserProfileSharePointFull Synchronization, AndUserProfileSharePointQuick Synchronization.

 

Nice, were good then. OK, so what happens when they don't sync?

I recently did a migration where we moved 2007 databases to a 2010 farm. the profiles moved over fine as did the permissions. however neither the quick or full sync, wocould work. it did at one point, but promptly stopped. no amount of manually running the timer job made a slight bit of difference.

No problem, I'm sure there's a powershell script for that. Nope. Couldn't find anything.

So how doesSharePointKeep the site collectionUserLists and the UPA profiles in sync?

When the timer job updates the site collections with the profile properties, it maintains the sync details in a table. Each database will have a sync table containing thisInformation.Stsadm.exeProvides a command (Sync) to view these tables:

Stsadm.exe-O sync-listolddatabases 0

This will display all the databases and when they have been sync 'd last.

 

 

The sync command also allows you to clear these tables:

Stsadm.exe-O sync-deleteolddatabases 0

Funny thing is it doesn' t actually Delete databases, just the sync info. The team that named this Param were having a right laugh.

Anyways, running this will basically tell the timer jobs that they have never sync 'd and force them to carry on as if it's the first time.

Make your way over to the timer Jobs page under monitoring in central admin and fire offUserProfileSharePointFull SynchronizationJob. It will take a lot longer to run this time and shocould fix the sync issue.

So once again stsadm.exe comes to the rescue.

If that still doesn 't'work, you can try Gary lapointes blog on re-writing them using powershell.

[From] http://donalconlon.wordpress.com/2012/03/02/sharepoint-user-information-list-is-not-being-updated/