Error "Cannot complete this action. Please try again."

"Error: The site http://server/personal/sitename cannot be opened. The site might be corrupted. To fix this problem, delete the site and recreate it.
12/19/2008 03:43:30 Microsoft.SharePoint.SPException: Cannot complete this action.
Please try again. ---> System.Runtime.InteropServices.COMException (0x80004005): Cannot complete this action.
Please try again.
at Microsoft.SharePoint.Library.SPRequestInternalClass.OpenWeb..........."

When accessing a personal site, you may face error above. For a scenario, when you don't have to care about "mysite" if they cause problem. You can do the following:
Open SQL Server 2005 Management studio
Open SITE database of SharePoint Portal Server 2003
Open Sites table by right clicking on it and "Open Table".
Look for the site you want to get rid of.
Copy the "Id" column value of it.
Open new query and select the SITE db to execute it on.
Execute following queries:

1. select * from userinfo where tp_login='' and tp_siteid='565d7b07-ed53-4352-834d-9f7572b96ccb'

Make sure above query brings only your site. If it brings more than 1 sites, go back in Sites table and look for more information to provide in query to bring only your site. Since, in my case above query will brought only one result, execute query below to set it as deleted.

update userinfo set tp_deleted='1' where tp_login='domain\sharepointadmin' and tp_siteid='565d7b07-ed53-4352-834d-9f7572b96ccb'

Now even running prescan tool and upgrading to sharepoint 2007 should work without problems.

Comments

Popular posts from this blog

Unable to delete Shared Services Provider in SharePoint (MOSS)

The server was unable to process the request due to an internal error. For more information about the error, either turn on IncludeExceptionDetailInFaults (either from ServiceBehaviorAttribute or from the configuration behavior) on the server in order to send the exception information back to the client, or turn on tracing as per the Microsoft .NET Framework 3.0 SDK documentation and inspect the server trace logs.

Cannot add a SimpleContent column to a table containing element columns or nested relations