Hi all,

I noticed a lot of event ID 5553 errors on this site but I have tried almost all of it and it seems to not be solving the issue. Specifically the error I get is this:

failure trying to synch site 3d0b5889-cf98-4d4f-8212-f35d602f88e6 for ContentDB 14a09b1b-3984-4499-bf1d-c9e517911f8b WebApp a26f4ded-f07a-4e0f-8c70-e3f38dca95d7.  Exception message was Cannot insert duplicate key row in object 'dbo.UserMemberships' with unique index 'CX_UserMemberships_RecordId_MemberGroupId_SID'.
The statement has been terminated..

My Sharepoint 2010 is running on 3 separate VMs as such:

1) Sharepoint server

2) SQL server

3) AD authentication

I have tried the following steps to try to fix this:

1) stsadm -o sync -listolddatabases 0

Result:

User Profile Application 'User Profile Service Application' - Partition '0c37852
b-34d0-418e-91c6-2ac25af4be5b'
ID: 14a09b1b-3984-4499-bf1d-c9e517911f8b  Synchronized: 1/4/2013 2:44:50 PM

stsadm -o sync -deleteolddatabases 0

Result:

A failure occurred during the processing of this command. Check diagnostic logs
for more information.

2) I have tried to delete the AD server connection by going to Central admin > Manage service apps > User Profile service application > Configure synchronization connections. Went to Monitoring > review job definitions > click on "User Profile Service Application - User Profile to SharePoint Full Synchronization" and click on run now. Same error occurs.

Anything else I should try? Any help greatly appreciated.

Hi Shiroi98,

This problem may occur the proxy for user profile service application becomes corrupt or gets deleted.

Try delete and re-create the user profile service application proxy by using the following PowerShell commands:

a) Remove the user profile service application proxy:

$proxy = Get-SPServiceApplicationProxy | where {$_.typename -eq "User Profile Service Application Proxy"}

Remove-SPServiceApplicationProxy -Identity $proxy confirmfalse

b) Create the user profile service application proxy:

$upa = Get-SPServiceApplication | where {$_.name -eq "<name here>"}

New-SPProfileServiceApplicationProxy -Name<proxyName> -Uri $upa.uri.absoluteURI

Have a look at the following similar threads,

http://social.technet.microsoft.com/Forums/en-US/sharepointadminprevious/thread/88dffd1d-39b1-42f1-9825-a7794c8e6fb0/

http://social.technet.microsoft.com/forums/en-US/sharepointgeneralprevious/thread/b53cda5f-b421-4e09-ab6f-4aff29185a54

Best Regards.

Hello All,

My problem was the same as yours. I think it is just a permission problem.
I think you will find the same entries if you check the ULS logs and set the filter to User Profile of Category:

Exception occured while connecting to WCF endpoint: System.ServiceModel.Security.SecurityAccessDeniedException: Access is denied. 
at System.ServiceModel.Channels.ServiceChannel.ThrowIfFaultUnderstood(Message reply, MessageFault fault, String action, MessageVersion version, FaultConverter faultConverter)    
 at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)    
 at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)    
 at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)    
 at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)    Exception rethrown
 at [0]:     
 at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)    
 at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)    
 at Microsoft.Office.Server.UserProfiles.IProfilePropertyService.GetProfileProperties()    
 at Microsoft.Office.Server.UserProfiles.ProfilePropertyServiceClient.<>c__DisplayClass1.<GetProfileProperties>b__0(IProfilePropertyService channel)    
 at Microsoft.Office.Server.UserProfiles.MossClientBase`1.ExecuteOnChannel(String operationName, CodeBlock codeBlock

UserProfileApplicationProxy.InitializePropertyCache: Microsoft.Office.Server.UserProfiles.UserProfileException: System.ServiceModel.Security.SecurityAccessDeniedException
 at Microsoft.Office.Server.UserProfiles.MossClientBase`1.ExecuteOnChannel(String operationName, CodeBlock codeBlock)    
 at Microsoft.Office.Server.UserProfiles.ProfilePropertyServiceClient.ExecuteOnChannel(String operationName, CodeBlock codeBlock) 
 at Microsoft.Office.Server.UserProfiles.ProfilePropertyServiceClient.GetProfileProperties()    
 at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.RefreshProperties(Guid applicationID)    
 at Microsoft.Office.Server.Utilities.SPAsyncCache`2.GetValueNow(K key)     at Microsoft.Office.Server.Utilities.SPAsyncCache`2.GetValue(K key, Boolean asynchronous)    
 at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.InitializePropertyCache()

Check the service application permissions and try to run again that account which has Full Control permission.