Good Evening All,Some help appreciated on the following Event ID 7888 and 5553.For the 7888 the message in the event logs as follows: 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)For the 5553 I get the folloowing: failure trying to synch site 62eb28c6-abd7-427e-b8fd-8c5a8fcea83f for ContentDB 97e79a0f-f1be-44e1-9d45-fb96e499c6dc WebApp a3faed65-b741-4536-878d-f408f12e4fef. 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.. In the Actuall SharePoint log in C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\LOGSThe following are showing: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\LOGS 11/28/2008 15:00:03.76 OWSTIMER.EXE (0x0B8C) 0x1B14 484 880mVerbose SqlCommand: 'dbo.profile_LogImportStart' CommandType: StoredProcedure CommandTimeout: 0 11/28/2008 15:00:03.76 OWSTIMER.EXE (0x0B8C) 0x1B14Office Server Office Server Shared Services 6pitVerbose {Distribution List Import Job} job executed successfully on try {1} 11/28/2008 15:00:03.81 OWSTIMER.EXE (0x0B8C) 0x0BB8SharePoint Portal Server User Profiles 62t4Verbose SyncLog21795000000159 WebApp MOSS (80 Site)(a3faed65-b741-4536-878d-f408f12e4fef), ContentDB WebContent1(97e79a0f-f1be-44e1-9d45-fb96e499c6dc), Site https://somewebsite Finished Web Update 11/28/2008 15:00:03.81 OWSTIMER.EXE (0x0B8C) 0x0BB8Windows SharePoint Services General 0Verbose Releasing SPRequest with allocation Id {6FDCB901-9AAC-464E-8DCD-69F2E51BCD4E} 11/28/2008 15:00:03.81 OWSTIMER.EXE (0x0B8C) 0x0BB8SharePoint Portal Server User Profiles 62szVerbose SyncLog21795000000160 WebApp MOSS (80 Site)(a3faed65-b741-4536-878d-f408f12e4fef), ContentDB WebContent1(97e79a0f-f1be-44e1-9d45-fb96e499c6dc), Site https://somewebsite: Sending Web Update for web b9dc412d-c460-4280-b7fb-f85e0992c2a0 11/28/2008 15:00:04.00 OWSTIMER.EXE (0x0B8C) 0x0BB8Office Server Office Server General 900nCriticalA 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... The second numbering 1 seems to be attempting again to syncronise and again and errors.Can anyone provide any help on this one please, I have read various article to disconnect the database, and run the prepare to move command etc, etc. I cannot help bu think this will not help.I have 1x2 content database for my farmcontaining3 servers in the farmm, 2 running as WFE and 1 as the indexer/search.I ran the following script to check which content database having sync problems at it was identified as WebContent1SELECT Id, ClassId, ParentId, Name as Nam, Status as Stat, Version, Properties FROM Objects WHERE (Id = '97e79a0f-f1be-44e1-9d45-fb96e499c6dc') It appears that whatever the sync is trying to do it's syncs with contentdb1 and then attempts to do the same on the second database and failes.Any help would be appreciated please.Many thanksRandine It appears that whatever the sync is trying to do it's syncs with contentdb1 and then attempts to do the same on the second database and failes.Any help would be appreciated please.Many thanksRandine It appears that whatever the sync is trying to do it's syncs with contentdb1 and then attempts to do the same on the second database and failes.Any help would be appreciated please.Many thanksRandine It appears that whatever the sync is trying to do it's syncs with contentdb1 and then attempts to do the same on the second database and failes.Any help would be appreciated please.Many thanksRandine It appears that whatever the sync is trying to do it's syncs with contentdb1 and then attempts to do the same on the second database and failes.Any help would be appreciated please.Many thanksRandine It appears that whatever the sync is trying to do it's syncs with contentdb1 and then attempts to do the same on the second database and failes.Any help would be appreciated please.Many thanksRandine SQL 2005 with Sharepoint

Hi, This normally occurs when a site collection or a content database is moved from one web application to another without running the Preparetomove command first. Without running the Preparetomove command, the SSP thinks the site is new and tries to insert data into the UserMemberships table that already exists there. This causes SQL to throw a duplicate key error and causes the profile synchronization job to fail. You should run the commands to solve your issue as follows: 1. Open a command prompt and navigate to C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\BIN 2. Run 'stsadm- o preparetomove -Site <http://whatevertheguiltysiteis/> -OldContentDb <GUID of the contentdb listed in event log error>' 3. Run 'stsadm -o sync -deleteolddatabases 0' For more information about the commands, see the following: Preparetomove: Stsadm operation (Office SharePoint Server) (http://technet.microsoft.com/en-us/library/cc262122.aspx) Sync: Stsadm operation (Office SharePoint Server) (http://technet.microsoft.com/en-us/library/cc263196.aspx) Let me know if you need further assistance. -lambertPosting is provided "AS IS" with no warranties, and confers no rights.

Hi Lambert,I am also getting this same error and as previously stated occured because i backed up one of my site and restored it to a new server."failure trying to synch site bee89e36-38a9-4b69-a727-1fd649d5387e for ContentDB 2cc7dc36-76b3-4ee8-afc6-01ab82c5b241 WebApp da93435f-a454-4e37-bf22-b18ac6968e06. 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.."I am not quit clear on how to find the contentDB listed in the event log ( i do not see any content db name in the event log? ) to run thestatement 'stsadm- o preparetomove -Site <http://whatevertheguiltysiteis/> -OldContentDb <GUID of the contentdb listed in event log error>'.Thanks for your help.

Hi Chochobeelai,You have to run the following Select Query on the Config Databases dbo.Objects table and look for the GUID that matches the listed GUID in your event log.Select Databaseas Sharepoint_Config and Table dbo.ObjectsSELECT Id, ClassId, ParentId, Name, Status, Version, PropertiesFROM ObjectsWHERE (Id = 'GUID') - repalce GUID with your database one. Hope it Helps, revert back should you require any further assistance.

Hi Lambert, Thanks for the nice post, I was able to resove Event 5553 from my web front ends. Followign are the queries that can be executed against the database to get more informations on the error messages. -- QUERY#1 Run this against your config database, this will give you the content database name SELECT * FROM [SharePoint_Config].[dbo].[Objects] WHERE ID='<Content DB Id from error msg>' --QUERY#2 -- Run followign queries against the database name returned by the QUERY#1 SELECT [FullUrl] ,[Id] ,[RootWebId] FROM [WSS_Content_##_03].[dbo].[Sites] WHERE ID='<Site ID from event log message>' --QUERY#3 This query will give you information about the site collection. SELECT [Id] ,[SiteId] ,[FullUrl] ,[MasterUrl] ,[CustomMasterUrl] FROM [WSS_Content_##_03].[dbo].[Webs] WHERE ID='<RootWebId from QUERY#2>' -- Look in the FulURL column for the site collection url e.g.sites/MYSITECOLL