{"id":2953,"date":"2011-04-18T12:19:03","date_gmt":"2011-04-18T20:19:03","guid":{"rendered":"https:\/\/www.zubairalexander.com\/stage\/?p=2953"},"modified":"2011-05-17T11:13:08","modified_gmt":"2011-05-17T19:13:08","slug":"how-to-fix-the-event-id-error-5553-in-sharepoint-server-2010","status":"publish","type":"post","link":"https:\/\/www.zubairalexander.com\/blog\/how-to-fix-the-event-id-error-5553-in-sharepoint-server-2010\/","title":{"rendered":"How to Fix the Event ID Error 5553 in SharePoint Server 2010"},"content":{"rendered":"<p>If you are getting an error from the source SharePoint Portal Server with Event ID 5553 on your SharePoint Serer 2010 you may need to delete the link in the Config_DB. The error may look similar to the following.<\/p>\n<p><em>failure trying to synch site dd51ad6a-e14d-4ed7-a2a7-e22992f09990 for ContentDB 00f45cc7-4f4a-44e7-8779-854375da0a81 WebApp 549868d8-17ab-4c75-9193-d2e38e7f3517.\u00a0 Exception message was Cannot insert duplicate key row in object &#8216;dbo.UserMemberships&#8217; with unique index &#8216;CX_UserMemberships_RecordId_MemberGroupId_SID&#8217;.<br \/>\nThe statement has been terminated..<\/em><\/p>\n<p><a href=\"https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2011\/04\/EventID5553.jpg\"><img decoding=\"async\" class=\"alignnone size-medium wp-image-2954\" title=\"EventID5553\" src=\"https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2011\/04\/EventID5553-300x208.jpg\" alt=\"\" width=\"300\" height=\"208\" \/><\/a><\/p>\n<p>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. Here&#8217;s how.<\/p>\n<ol>\n<li>Lists content databases that have not been synchronized since <em>n<\/em> days. The presumption is that they have been deleted or moved. For example, to list the databases that have not been synchronized for 1 day type the following command:<br \/>\n<strong>stsadm -o sync -listolddatabases 1<\/strong><\/li>\n<li>To delete old records corresponding to these out of sync databases, use the deleteolddatabases command. Don&#8217;t worry, according to Microsoft, this command doesn&#8217;t delete the databases themselves it only deletes the links in the configuration databases.<br \/>\n<strong>stsadm -o sync -deleteolddatabases 1<\/strong><\/li>\n<li>You should see an <em>Operation completed successfully<\/em> message.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>If you are getting an error from the source SharePoint Portal Server with Event ID 5553 on your SharePoint Serer 2010 you may need to delete the link in the Config_DB. The error may look similar to the following. failure trying to synch site dd51ad6a-e14d-4ed7-a2a7-e22992f09990 for ContentDB 00f45cc7-4f4a-44e7-8779-854375da0a81 WebApp 549868d8-17ab-4c75-9193-d2e38e7f3517.\u00a0 Exception message was Cannot insert [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[54,11],"tags":[],"class_list":["post-2953","post","type-post","status-publish","format-standard","hentry","category-sharepoint","category-tips-tricks"],"aioseo_notices":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/posts\/2953","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/comments?post=2953"}],"version-history":[{"count":0,"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/posts\/2953\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/media?parent=2953"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/categories?post=2953"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/tags?post=2953"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}