locked
dealing with site sync failed errors RRS feed

  • Question

  • Platform 32 bit MOSS 2007 service pack 3 and april 2012 cumulative update, 32 bit sql server on a second machine, Axceler ControlPoint product

    We purchased ControlPoint to provide additional admin reporting and functionality. As a first use, we tried ControlPoint's interface to moving a site collection from one content database to another.

    After moving a few as a test, we began seeing the error log entries like this:

    Event Type: Error
    Event Source: Office SharePoint Server
    Event Category: User Profiles
    Event ID: 5553
    Date:  1/2/2013
    Time:  9:01:10 AM
    User:  N/A
    Computer: myserver
    Description:
    failure trying to synch site 264496a9-f88f-4359-ae64-c02d936108c1 for ContentDB d4322356-b6db-438f-9f95-153d78b5d991 WebApp a5f6e661-8c06-4b4f-96c4-c280017425a3.  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..

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    In our case, there is only one sharepoint web app that we are using. There are a couple of other applications on the machine (ControlPoint and Central Admin). And there are some app pools that are running because they were running when I inherited the machine. One of those app pools is associated with "Office Server Web Services". There is no other web sites running, so I don't know what those app pools are for.

    After web searching, I ran the combination of commands:

    C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN>stsadm -o preparetomove -site http://myserver -oldcontentdb d4322356-b6db-438f-9f95-153d78b5d991

    Operation completed successfully.


    C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN>stsadm -o sync -deleteolddatabases 0

    Deleted sync information for DB d4322356-b6db-438f-9f95-153d78b5d991
    Deleted sync information for DB 978212eb-a997-485f-80f4-2c96086dadcd
    Deleted sync information for DB 669e6df5-5671-4245-a6cd-4adc1131b071
    Deleted sync information for DB e8793c1a-8c0b-45f3-9902-7e40836ea797
    Deleted sync information for DB 237e8905-cc02-41ba-80b6-e9ec00711a74
    Deleted sync information for DB d642d375-acd3-41dc-8dae-ed3eead31f83

    Is this all that needs to be done?  Do I need to do a preparetomove -undo or does the sync take care of that?

    I am waiting now for the top of the next hour to see if this has cleared up the error messages. If it has not, is there something else that should be tried next?

    Thank you very much

    Wednesday, January 2, 2013 2:52 PM

All replies

  • Well, at the top of the hour, I again got the 5553 as well as a 7888 event log entry for 3 items. All three items are on content database d4322356-b6db-438f-9f95-153d78b5d991 , which appears in the above list.

    I have executed a -o sync -listolddatabases 0 before and after the hour mark. Before the hour mark I got a message saying that no databases match the criteria for this Shared Service Provider. Afterwards, I get 3 IDs listed for the shared service provider default web site.

    I re-execute the preparetomove and the deleteolddatabases , get output saying that it deleted sync info for 3 different db, rerun the listolddatabases 0 and get no databases match the criteria.

    However, I am expecting to see the same thing come up again at the top of the hour.

    What can I do to resolve this situation? I am presuming that the messages are arising during the user profile sync timer job.

    There are errors in the 12 hive log. They are

      
       
    01/02/2013 10:01:05.31  OWSTIMER.EXE (0x08FC)                    0x146C Office Server                  Office Server General          900n Critical 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.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)     at System.Data.SqlClient.TdsParser.Run(RunBe... 
    01/02/2013 10:01:05.31* OWSTIMER.EXE (0x08FC)                    0x146C Office Server                  Office Server General          900n Critical ...havior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)     at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunB 
    01/02/2013 10:01:05.31  OWSTIMER.EXE (0x08FC)                    0x146C SharePoint Portal Server       User Profiles                  837v Exception (Watson Reporting Cancelled) 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.SqlInternalConnection.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... 
    01/02/2013 10:01:05.31* OWSTIMER.EXE (0x08FC)                    0x146C SharePoint Portal Server       User Profiles                  837v Exception ..., 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.UserPro... 
    01/02/2013 10:01:05.31* OWSTIMER.EXE (0x08FC)                    0x146C SharePoint Portal Server       User Profiles                  837v Exception ...files.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) 
    01/02/2013 10:01:05.31  OWSTIMER.EXE (0x08FC)                    0x146C SharePoint Portal Server       User Profiles                  791t Critical failure trying to synch site 6843287d-380a-492b-b65f-4c248fcd7af5 for ContentDB d4322356-b6db-438f-9f95-153d78b5d991 WebApp a5f6e661-8c06-4b4f-96c4-c280017425a3.  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.. 
    01/02/2013 10:01:14.91  OWSTIMER.EXE (0x08FC)                    0x146C Office Server                  Office Server General          900n Critical 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.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)     at System.Data.SqlClient.TdsParser.Run(RunBe... 
    01/02/2013 10:01:14.91* OWSTIMER.EXE (0x08FC)                    0x146C Office Server                  Office Server General          900n Critical ...havior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)     at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunB 
    01/02/2013 10:01:14.91  OWSTIMER.EXE (0x08FC)                    0x146C SharePoint Portal Server       User Profiles                  837v Exception (Watson Reporting Cancelled) 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.SqlInternalConnection.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... 
    01/02/2013 10:01:14.91* OWSTIMER.EXE (0x08FC)                    0x146C SharePoint Portal Server       User Profiles                  837v Exception ..., 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.UserPro... 
    01/02/2013 10:01:14.91* OWSTIMER.EXE (0x08FC)                    0x146C SharePoint Portal Server       User Profiles                  837v Exception ...files.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) 
    01/02/2013 10:01:14.91  OWSTIMER.EXE (0x08FC)                    0x146C SharePoint Portal Server       User Profiles                  791t Critical failure trying to synch site 1ae9c232-07b0-4423-9961-a7a558143854 for ContentDB d4322356-b6db-438f-9f95-153d78b5d991 WebApp a5f6e661-8c06-4b4f-96c4-c280017425a3.  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..

    A runtime exception regarding duplicate key row for dbo.usermemberships appears a minute later, along with a failure trying to sync site 264496a9-f88f-4359-ae64-c02d936108c1  error.

    Since mailboxes are filling with these errors, I would like to resolve the problem if possible. Does anyone have recommendations?  Thank you

    Wednesday, January 2, 2013 3:16 PM
  • Question about the preparetomove - is the URL the top farm level, or the URL of the site collection?
    Wednesday, January 2, 2013 6:58 PM