Tuesday, August 11, 2009

Profile Sync not working

I came across an issue with the Site Memberships link when using the Personalization feature Site Memberships. This automatically adds a link that you are a MEMBER of to your MyLinks-SharepointSites feature.

Unfortunately when you are either removed from a membership group or the site gets deleted the links do not get updated.

After researching and finding a resolution it actually resolved another issue we were having. When a user's profile information changes the information within the sites they have access to do not get updated. So for example, my title changed from Assoc. Systems Administrator to Systems Administrator and when logging into the Portal and selected the dropdown on my name on the top of the page and clicking on My Settings which brings you to the _layouts/userdisp.aspx page. The information never gets updated. The only way to update this so far was to login to a site and make some type of edit, upload, delete. This would manually cause the Profile Sync to run.

How did this happen?
We moved content database improperly!
Why does this break the sync? We store the ID for the content database in the Config database. By not moving the content database properly we don't prepare the SSP for a new GUID, and the Timer Jobs will continue to try to sync with the old GUID not allowing us to sync with the new one.

The preparetomove operation was introduced before Infrastructure Update. Once SP2 is applied this is no longer required.
How I fixed was:
a. Run the command stsadm -o sync -listolddatabases 1 You should then get a list of database GUID.
b. Run the command stsadm -o sync -deleteolddatabases 1 This will remove the record from the SSP database but will not touch the actual Content Database.
c. Then wait for the next sync and you should see tags getting updated.

To force the Profile Sync timer job to run use this command:stsadm -o sync -synctiming "m:5" (This sets it to 5 minutes) To set it back to 1 hour use this:stsadm -o sync -synctiming "h:1"

This fixed my user profile issue and the Site Memberships issue. I will wait a few days and verify it's still working.

1 comment:

Unknown said...

Thank you so much for this post. I have been trying to determine how to remove the Site Memberships listed from our old site collection. This worked perfectly.