Application event viewer getting filled with Event ID 7888 and 5553 every one hour.

The following errors are thrown in the application event log every hour:

Event Type: Error

Event Source: Office SharePoint Server

Event Category: User Profiles

Event ID: 5553

Date: 5/5/2008

Time: 10:00:56 AM

User: N/A

Computer: <MOSSServer>

Description:

failure trying to synch site 71911d6b-b49a-4fca-998e-156ae35d236e for ContentDB

4bc60196-9553-4bea-89f4-49f7402fcfb7 WebApp ee78bb17-c87c-4f31-bba2-85f09e523cce.

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.

AND

Event Type: Error

Event Source: Office SharePoint Server

Event Category: Office Server General

Event ID: 7888

---

Date: 5/5/2008

Time: 10:00:56 AM

User: N/A

Computer: <MOSSServer>

Description:

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)

Why this happens:

================

This normally occurs when a site collection or a content database is moved from one

web application to another without running the preparetomove

https://technet.microsoft.com/en-us/library/cc262122.aspx  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.

How to fix it:

================

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 <https://whatevertheguiltysiteis/>

-OldContentDb <GUID of the contentdb listed in event log error>'

3. Run 'stsadm -o sync -deleteolddatabases 0'

For more information about the deleteolddatabases command, see the following:

https://technet.microsoft.com/en-us/library/cc263196.aspx

Note –

Its not necessary to follow 2 step in case we are on Sp2 , we can directly go to the 3rd step.

Comments

• Anonymous
  January 01, 2003
  Unfortunately, I did this, and still get the repeating error.