After SP1 upgrade and august cumulative updates, sites can't sync with User Profile
-
2011年10月13日 21:26
I am getting these errors every hour:
failure trying to synch site 8909ed4c-3185-4200-8b1b-dbbefb8f6be4 for ContentDB 9bb23f16-c950-4ebd-86ec-11a3a32d39de WebApp 0797d015-ff08-4ba1-9b03-3657d4cccc20. Exception message was Cannot insert duplicate key row in object 'dbo.UserMemberships' with unique index 'CX_UserMemberships_RecordId_MemberGroupId_SID'. The duplicate key value is (0c37852b-34d0-418e-91c6-2ac25af4be5b, 2344, 95, 0x0105000000000005150000002f3fb83357a059b1d99e601d0baf0000).
The statement has been terminated..failure trying to synch site b347dd9e-5a2c-401e-a378-b6f6160ef2a4 for ContentDB 9bb23f16-c950-4ebd-86ec-11a3a32d39de WebApp 0797d015-ff08-4ba1-9b03-3657d4cccc20. Exception message was Cannot insert duplicate key row in object 'dbo.UserMemberships' with unique index 'CX_UserMemberships_RecordId_MemberGroupId_SID'. The duplicate key value is (0c37852b-34d0-418e-91c6-2ac25af4be5b, 848, 36, 0x0105000000000005150000002f3fb83357a059b1d99e601d11290000).
The statement has been terminated..failure trying to synch site 6b19534f-a30e-4565-a720-b161b71d9ec1 for ContentDB 9bb23f16-c950-4ebd-86ec-11a3a32d39de WebApp 0797d015-ff08-4ba1-9b03-3657d4cccc20. Exception message was Cannot insert duplicate key row in object 'dbo.UserMemberships' with unique index 'CX_UserMemberships_RecordId_MemberGroupId_SID'. The duplicate key value is (0c37852b-34d0-418e-91c6-2ac25af4be5b, 848, 24, 0x0105000000000005150000002f3fb83357a059b1d99e601d11290000).
The statement has been terminated..failure trying to synch site 8909ed4c-3185-4200-8b1b-dbbefb8f6be4 for ContentDB 9bb23f16-c950-4ebd-86ec-11a3a32d39de WebApp 0797d015-ff08-4ba1-9b03-3657d4cccc20. Exception message was Cannot insert duplicate key row in object 'dbo.UserMemberships' with unique index 'CX_UserMemberships_RecordId_MemberGroupId_SID'. The duplicate key value is (0c37852b-34d0-418e-91c6-2ac25af4be5b, 2344, 95, 0x0105000000000005150000002f3fb83357a059b1d99e601d0baf0000).
The statement has been terminated..failure trying to synch site b347dd9e-5a2c-401e-a378-b6f6160ef2a4 for ContentDB 9bb23f16-c950-4ebd-86ec-11a3a32d39de WebApp 0797d015-ff08-4ba1-9b03-3657d4cccc20. Exception message was Cannot insert duplicate key row in object 'dbo.UserMemberships' with unique index 'CX_UserMemberships_RecordId_MemberGroupId_SID'. The duplicate key value is (0c37852b-34d0-418e-91c6-2ac25af4be5b, 848, 36, 0x0105000000000005150000002f3fb83357a059b1d99e601d11290000).
The statement has been terminated..failure trying to synch site 6b19534f-a30e-4565-a720-b161b71d9ec1 for ContentDB 9bb23f16-c950-4ebd-86ec-11a3a32d39de WebApp 0797d015-ff08-4ba1-9b03-3657d4cccc20. Exception message was Cannot insert duplicate key row in object 'dbo.UserMemberships' with unique index 'CX_UserMemberships_RecordId_MemberGroupId_SID'. The duplicate key value is (0c37852b-34d0-418e-91c6-2ac25af4be5b, 848, 24, 0x0105000000000005150000002f3fb83357a059b1d99e601d11290000).
The statement has been terminated..I did a stsadm -o sync -listolddatabases 1 on my CA server and it responds:
User Profile Application 'UPS' - Partition 0c37852b-34d0-418e-91c6-2ac25af4be5b
No databases match the criteria for this Partition in the User Profile Application
This is the same number that it referenced in my error messages. I tried doing a
stsadm -o sync -deleteolddatabases 1 but it doesn't change anything. How can I get my sites to begin syncing correctly? I have already stopped and restarted User Profile and User Profile Sync and did an iisreset.
全部回复
-
2011年10月13日 21:28looks like you're having the exact same problem that i am(see thread I just posted)
-
2011年10月13日 21:33
Hi ,
try to stop User Profile Service and restart it again especially after you installed Aug CU.
Regards, Fadi Abdulwahab. http://sqlgoogler.blogspot.com/ Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you -
2011年10月13日 21:44in my case, i did do that, as instructed by MS in the notes for the CU. No luck :\
-
2011年10月13日 21:54
check this thread
Regards, Fadi Abdulwahab. http://sqlgoogler.blogspot.com/ Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you -
2011年10月13日 22:47
After installing the June CU, you need to REprovisioning the UPS Application.
The restart is not enough..
Regards
www.sharepointcommunity.it -
2011年10月14日 14:41
I cleared the configuration cache -- issue persists.
I re-provisioned the UPSA and it essentially hosed my profiles. I ended up having to restore that SA from a backup just to get it working again.
At any rate...i'm still experiencing the issue.
-
2011年10月14日 15:01I tried this and unfortunately it did not stop the error.
-
2011年10月17日 20:57
Maybe I should try it from this approach:
When I run stsadm -o sync -listolddatabases 0 on my server I get this error:
User Profile Application 'UPS' - Partition '0c37852b-34d0-418e-91c6-2ac25af4be5b, No databases match the criteria for this Partition in this User Profile Application
Running the -deleteolddatabases 0 command did not get rid of this message. How can I get the databases to use this criteria for my UPS?
-
2011年10月25日 14:27When you say REprovisioning the UPS Application, do you mean delete and recreate?
-
2012年5月23日 17:45I was having Errors 5553 ('dbo.UserMemberships') on one of my app servers every hour. I tried the stsadm commands to no avail. Almost every blog out there suggests the stsadm commands, but they aren't advised in Sharepoint 2010.
It turns out the problem was a corrupted configuration cache. Following the instructions in this link fixed it for me. http://blogs.msdn.com/b/josrod/archive/2007/12/12/clear-the-sharepoint-configuration-cache-for-timer-job-and-psconfig-errors.aspx
.png)
.png){kind=spacer}
