Some time ago, I worked on a case, where the membership displayed on the MySite ran out of sync.
On My Site page ( …/MyMemberships.aspx…) we usually see the memberships to sites the user is a member of (see figure below):
For some reason, we still have memberships for sites on which the user is not a member anymore.
For some other sites the memberships are correct.
In the customers environment (Build 14.0000.5136.5002) the issue seems to start occurring only on sites from content databases that were detached and reattached. This symptom, were reproducible by the following repro steps:
Repro (detached/Reattached DB)
- a running instance of User profile import and sync
- already created MySite host location and active MySites
- existing memberships on any sites in farm
Now check on the MySite as shown above, that the memebership appears (can take a while to be updated).
You can force it by running the timer job “UPA User Profile to SharePoint Full Synchronization” as shown below
You can also check the membership by SQL query:
So far, everything is fine yet.
Now detach the test content DB and execute the timer job again.
If we now kick off the stsadm command stsadm -o sync -listolddatabases 0 – we’ll see that our Content DB is not in sync anymore.
Now we’re using the previous SQL query again to check for changes: User and membership is still there!
Ok, reattach now the content DB, remove the user from the sites membership group and ensure that the user is entirely removed from the site (not having any other membership, coming from another added AD-Security group, domain users or so).
Run again the “User Profile to SharePoint Full Synchronization” timer job and the SQL Query,
– User still is there! Hmmm… here we would expect, that the user’s membership has been removed and should not appear anymore in the MySite view ….!?
Well, after several attempts and tests I also could find out, that the issue also happens, if a site was deleted without prior removing the user’s membership and or the site was moved to another content DB, etc.
However, it took a long time to finally get this particular issue fixed and this supposed to be fixed with the August or October 2011 CU – please ask MS support if you have a similar issue with the membership although applying the CU’s to investigate why it did not fix in your environment/circumstance!
Note! The membership problem is not that trivial as prior assumed and can have more than one cause or dependency. So even if your problem seems to be similar or even match the described one, it might have additional causes and thus may be investigated deeper by Support agents if it still persists with latest CU (currently Oct. 11) installed.
We’re actually aware of several other cases but not all of them are fully reproducible or based on same causes! By now, we only can make more pressure for getting this fixed soon, if we have lots of service requests reporting this issue! So don’t hesitate to call MS support
*** Update 2011-12-15 ***
The fix for the membership issue is definitely pushed out in the August 11 CU although not mentioned in the according KB article!
But the fix only applies for those changes on membership that happened after applying the fix!
It does not fixing reverse a membership that was broken before installing the fix.
Against any previous made statements or other blogs posting it:
you must not run the stsadm command (stsadm –o sync deleteolddatabases 0)
If you did, and you also have applied the August 11 CU but still having your issue, please call MS Support and open a case for assistance and further investigation!!
*** End Update 2011-12-15 ***
*** Update 2012-01-23 ***
“User Profile to SharePoint Full Synchronization job stops computing Membership” KB 2703630, Updated December 19, 2012
– provides a Workaround that maybe can help to Repair a broken membership.
“Microsoft acknowledges this to be a product issue regarding cleanup of removed site collections which was fixed in August 2010 cumulative update for SharePoint 2010 (Server package KB 2352342 (http://support.microsoft.com/default.aspx?scid=kb;EN-US;2352342) ).
However this fix does not affect site collections which got into this state by detaching their databases prior to the hotfix installation. To restore membership synchronization for these affected site collections, please follow the resolution steps.” -> KB 2703630
*** End Update 2012-01-23 ***
This is provided “AS-IS” and does not guarantee the success or Full Resolution. It worked in this particular case and might considered as a “Hint” but not as a resolution for ALL cases!
Hth, cheers, Steve