I am attempting to upgrade my SharePoint 2007 web application to SharePoint 2010. During the upgrade, I got an error and the upgrade failed. I searched through the error log and found that it was referencing a corrupt site. Site Url: http://workdev.catapultsystems.com/bk002428/006579 [powershell] [SPSiteWssSequence] [ERROR] [11/3/2011 5:38:55 PM]: Action 4.0.10.0 of Microsoft.SharePoint.Upgrade.SPSiteWssSequence failed. [powershell] [SPSiteWssSequence] [ERROR] [11/3/2011 5:38:55 PM]: Exception: <nativehr>0x80070002</nativehr><nativestack></nativestack>There is no Web named "/bk002428/006579". When I attempt to load the site in the browser, it doesn't load. So I need to get rid of it. Database repair failed to find it. Upgrade test failed to find it. STSADM -o DeleteWeb failed. So I did this command: STSADM -o DeleteWeb -force This command worked! Or at least it claimed to: Operation completed successfully. Now the browser acts like the site doesn't exist. And I can't retrieve the site via Powershell. BUT... it shows up in ENUM Sites. And when I resume the upgrade, it still errors out at the same place. And if I repeat the upgrade command, it once again says "Operation successful", whereas if I try to perform that command on a site that doesn't exist, it will tell me. So I have tried the command multiple times, and it says it works each time, but the site won't go away. And my upgrade won't complete as a result. Here is the full command. STSADM -o deleteweb -force -webid "b7e6e0e1-ff24-4b54-a065-33e784afeac2" -databasename SP2010_WORKDEV_Content -databaseserver CATINBIDB01 And here is the enumweb entry I call right after I delete the site: <Web Id="b7e6e0e1-ff24-4b54-a065-33e784afeac2" Url="/bk002428/006579" LanguageId="1033" TemplateName="Unknown" TemplateId="200701" /> Any ideas? :-(Robyn

Hi, It seems to be an orphan site. Follow this to delete http://social.technet.microsoft.com/wiki/contents/articles/how-to-identify-and-clean-up-orphan-sites-in-sharepoint.aspx I hope this will help you out.Thanks, Rahul Rashu

Hi, It seems to be an orphan site. Follow this to delete http://social.technet.microsoft.com/wiki/contents/articles/how-to-identify-and-clean-up-orphan-sites-in-sharepoint.aspx I hope this will help you out.Thanks, Rahul Rashu

Hi, It seems to be an orphan site. Follow this to delete http://social.technet.microsoft.com/wiki/contents/articles/how-to-identify-and-clean-up-orphan-sites-in-sharepoint.aspx I hope this will help you out.Thanks, Rahul Rashu

Hi Yes follow the http://social.technet.microsoft.com/wiki/contents/articles/how-to-identify-and-clean-up-orphan-sites-in-sharepoint.aspx as suggested by Rahul, if it does not work then also try databaserepair [refer: http://technet.microsoft.com/en-us/library/cc263282(office.12).aspx] Regards RameshRegards Ram

Unfortunately, I have run the DB script, and the Orphan List table is empty. I have also run the Database Repair. The site shows up as an orphan. Then I add the -deletecorruption in order to remove the orphans. It says it completes successfully. But when I run the Database Repair again, the orphans still show up. And I get the following EVNTVWR error: Unknown SQL Exception 515 occurred. Additional error information from SQL Server is included below. Cannot insert the value NULL into column 'DocId', table 'SP2010_WORKDEV_Content.dbo.SiteQuota'; column does not allow nulls. INSERT fails. The statement has been terminated. It did not work in the SP2010 environment, but it did work in the SP2007 environment. So I will take another backup of the SP2007 database, now that it's clean. Thank you for all your help! Robyn

Unfortunately, I have run the DB script, and the Orphan List table is empty. I have also run the Database Repair. The site shows up as an orphan. Then I add the -deletecorruption in order to remove the orphans. It says it completes successfully. But when I run the Database Repair again, the orphans still show up. And I get the following EVNTVWR error: Unknown SQL Exception 515 occurred. Additional error information from SQL Server is included below. Cannot insert the value NULL into column 'DocId', table 'SP2010_WORKDEV_Content.dbo.SiteQuota'; column does not allow nulls. INSERT fails. The statement has been terminated. It did not work in the SP2010 environment, but it did work in the SP2007 environment. So I will take another backup of the SP2007 database, now that it's clean. Thank you for all your help! Robyn

Hi Yes follow the http://social.technet.microsoft.com/wiki/contents/articles/how-to-identify-and-clean-up-orphan-sites-in-sharepoint.aspx as suggested by Rahul, if it does not work then also try databaserepair [refer: http://technet.microsoft.com/en-us/library/cc263282(office.12).aspx] Regards RameshRegards Ram

Hi Yes follow the http://social.technet.microsoft.com/wiki/contents/articles/how-to-identify-and-clean-up-orphan-sites-in-sharepoint.aspx as suggested by Rahul, if it does not work then also try databaserepair [refer: http://technet.microsoft.com/en-us/library/cc263282(office.12).aspx] Regards RameshRegards Ram