i am getting this error every 5 min when my User Profile Synch job and Quick User profile synch job runs. i have searched in internet and also runs following commans stsadm -o sync -listolddatabases 1 to see the old databases, and: stsadm -o sync -deleteolddatabases 1 to delete the database all the command runs successfully but still my User Info list in site collection does not update with correct user job title or new profile picture and also i am keep getting error that i have mention in my title. detail of this error is as below. 1) error with Event id 7888 and category 1516 A runtime exception was detected. Details follow. Message: Cannot insert duplicate key row in object 'dbo.UserMemberships' with unique index 'CX_UserMemberships_RecordId_MemberGroupId_SID'. The statement has been terminated. Techinal Details: System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.UserMemberships' with unique index 'CX_UserMemberships_RecordId_MemberGroupId_SID'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Office.Server.Data.SqlSession.ExecuteNonQuery(SqlCommand command) at Microsoft.Office.Server.UserProfiles.WSSSynchSqlSession.SynchExecuteNonQuery(SqlCommand cmd, Boolean throwOnFail) at Microsoft.Office.Server.UserProfiles.WSSSynchSqlSession.SynchExecuteNonQuery(SqlCommand cmd) at Microsoft.Office.Server.UserProfiles.SiteSynchronizer.WriteChangeLogConsumed() at Microsoft.Office.Server.UserProfiles.SiteSynchronizer.Synch() at Microsoft.Office.Server.Diagnostics.FirstChanceHandler.ExceptionFilter(Boolean fRethrowException, TryBlock tryBlock, FilterBlock filter, CatchBlock catchBlock, FinallyBlock finallyBlock) 2)Error with event id 5553 and category 1340 failure trying to synch site 77e6acc8-79fc-4292-a63a-827483863f3a for ContentDB 3132484b-93ff-4a60-8966-47e914e4b209 WebApp c23e0d82-70f9-4fe0-8d5c-2385c0b489e9. 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.. Thanks

Hi, Try to execute this command stsadm.exe o sync deleteolddatabases 0 This will delete old synchronization record from config DB. Check this technet article for more info: http://blogs.technet.com/b/sushrao/archive/2011/12/02/moss-2007-event-id-5553-amp-event-id-7888.aspx Hope it could helpCheers, Hemendra-MCTS "Yesterday is just a memory,Tomorrow we may never see"