You may get errors like this following a DB move, for example, moving a content db from a sql box to a cluster / vice versa
Message: Cannot insert du Delicious Pin It Buffer Second Life of a Hungarian SharePoint Geek October 27, 2013 failure trying to synch site for ContentDB (0x80070005 – Event ID:5553) Filed under: Not sure what logs to check or what to look for. Check diagnostic logs for more information. Netherlands 8. https://support.microsoft.com/en-us/kb/2771190
The deleteolddatabases parameter did have me scared at first, but it worked just fine (after some research as to what it actually does) ;-). Fix: List databases which are not synced for more than two days stsadm -o sync -listolddatabases 2 Delete old database references from the config db stsadm -o sync -deleteolddatabases 2 References: SharePoint 'Stuff' All things SharePoint Friday, July 2, 2010 Event 7888 and 5553 I have been getting these errors in my event log:Event Type: ErrorEvent Source: Office SharePoint ServerEvent Category: Office stsadm -o sync -deleteolddatabases 0 –Jussi Palo Jan 12 at 20:44 | show 4 more comments Your Answer draft saved draft discarded Sign up or log in Sign up using
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. Details follow. In my case, unfortunately this doesn't work. I used this tool to identify the web applications and sites referred to by their GUID in the event log errors. 2.
Thanks. Am I missing anything? California 2. http://www.eventid.net/display-eventid-5553-source-Office%20SharePoint%20Server-eventno-9579-phase-1.htm Exception message was
Italy 9. The statement has been terminated. So this is what I did.I ran just the "Preparetomove" command alone after running the aforementioned three key STSADM commands for all the web applications that were having this issue. One solution that I know is to use the STSADM tool to list the content databases that are out of sync and then delete the links.
Canada 5. SOLUTION: 1. I just come to your blogg after facing a problem while adding some excel tables from a libray into a excel services webpart. I opened a command prompt and typed stsadm- o preparetomove –Site
Open a command prompt and navigate to C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\BIN 2. navigate here There is a unknown word starting at index 0. 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.//----------------------------------------------------------------Event Type: ErrorEvent Source: The statement has been terminated.
Powered by Blogger. New York 7. The statement has been terminated. Check This Out The errors were repeated in the logs hourly.
Does Ohm's law hold in space? Leave a Reply Cancel reply Your email address will not be published. Not sure what exactly is happening.
Archives September 2013(1) August 2013(1) March 2013(1) January 2012(1) July 2011(1) May 2011(1) November 2010(1) September 2010(1) July 2010(1) May 2010(2) April 2010(8) August 2009(1) April 2009(2) July 2008(1) April 2008(3) Lists content databases that have not been synchronized since n days. Run ‘stsadm -o sync -deleteolddatabases 0' For more information about the deleteolddatabases command, see the following: http://technet.microsoft.com/en-us/library/cc263196.aspx Note â€“ Its not necessary to follow 2 step in case we are on Check diagnostic logs for more information –Mohammed Eliyas Ahmed Jan 11 at 19:50 I could see that syncronization shows dated 3 years ago –Mohammed Eliyas Ahmed Jan 11 at
Browse other questions tagged sharepoint-enterprise sharepoint-designer sharepoint-online sharepoint-foundation sharepoint-server or ask your own question. How do you make Fermat's primality test go fast? The statement has been terminated. 5553: failure trying to synch site [SITEGUID] for ContentDB [CONTENT DB GUID] WebApp [WEB APP GUID].Â Exception message was Cannot insert duplicate key row in object this contact form 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.
Related Leave a Comment Leave a Comment » No comments yet. x 1 Private comment: Subscribers only.