Friday, August 01, 2008

[MOSS2007] Error "Cannot complete this action. Please try again."

Over the past month I have been working on a major incident on our production SharePoint 2007 environment.

ISSUE:

When opening a sub site in a site collection by entering it url without default.aspx file, SharePoint would show an HTTP 500 error (Internal Server error). When you try to open the default.aspx file, SharePoint would display the error "Cannot complete this action. Please try again.". The symptoms were similar to:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;937038


CAUSE:
About a month ago a site administrator of a sub site noticed that the NT AUTHORITY\AUTHENTICATED USERS group was listed in the site members group. In other words, everybody who was authenticated in the domain or trusted domains had Contribute permissions. As you can imagine this was not supposed to happen, so he tried to delete the AUTHENTICATED USERS group from the members group. What the user exactly did and what happened is not really clear, but the the result was that the sub site was no longer reachable.

STEPS TAKEN:
After searching for a solution for about a day, we could not figure it out and called in the support of Microsoft. Unfortunately they also weren't very sure how to solve it, but did mentioned the possibility of installing SP1 which might solve the issue. On the other hand, the also feared that installing SP1 would fail because of the broken site. To be sure we prefered to test the installation of SP1 first. In the meantime, the users couldn't access their data and we had to fix that first.

The suggestion of Microsoft was to use stsadm -o export/import. We would restore a known good copy of the database to a restore environment, export the sub site tree, copy it to the production environment and import on top of the broken sub site. Unfortunately this did not work, we received the same error. The alternative was to restore to a new sub site. The import started fine, but after about seven hours stsadm crashed! Also a second import crashed......now what.

We had bought MetaLogix Migration Manager to migrate content from file shares, ASP/HTML websites and other SharePoint environments into our new central MOSS2007 environment. So we gave that tool a go. Fortunately that worked. After several hours, the data was available again for the users.

FIX THE PRODUCTION ENVIRONMENT:
I wanted to test the installation of SP1 on a copy of that site collection. I tried to use stsadm -o backup/restore to copy the production site collection and to a restore environment. The backup went fine, but restore failed after 8 to 10 hours :-(

I then tried to create a backup of the entire database, restore that to the restore database server and attach to an empty web application. Fortunately that worked and I had an environment to test SP1 on. The installation of SP1 completed successfully and we now know that we can install SP1 without any issues on the environment.

KEY INFO:
The entire site collection was about 48GB of size. The sub site tree was about 25GB. Moveing the data using the default stsadm tools, did not work. It looks like stsadm is having some issues with large sites.

According to Microsoft Product Support, SP1 contains stored procedures which check and fix security issues. They weren't sure if those stored procedures would fix our issue. Obviously it did :-)

4 comments:

bug said...

Hello, we are facing something very similar too. What is your recommended solution to fixing the cannot complete this ation error?

Yorick said...

We have tested the installation of Service Pack 1 on a test environment, which fixed the issue for us. We are now in the process of planning the installation on production.

Three weeks ago I ran into another situation which caused the same error: We deployed a solution which contained a bug. This solution caused all content types to disappear. Some pages that were relying on these content types displayed the Cannot complete this action error as well. After deinstalling the solutions, the content types came back and the pages worked fine again.

Avinash.Devkate said...

Simply export the site using STSADM command and the import it again,if the issue is related to subsite.
Problem will resolve.

If the case is related to sitecollection then take bakup and restore it agian using STSADM command.

--Avinash.Devkate--

VM said...

Hi i followed (http://www.microsoft.com/downloads/details.aspx?FamilyId=C1039E13-94DA-4D7D-8CAE-3B96FA5A4045&displaylang=en)(http://www.microsoft.com/downloads/details.aspx?FamilyId=C1039E13-94DA-4D7D-8CAE-3B96FA5A4045&displaylang=en)this install the templates correctly,
and i goto activate the feature under "Site Administration->Site Feature" page during activation some feature(Bug Tracking Modules,IT Modules)is not activated showing error "Cannot complete this action.Please try
again.Troubleshoot issues with Windows SharePoint Services"
and some feature is already in exist(eventplanning.wsp,endinglibrary.wsp).afterthis my sharepoint website Home page also showing this error "Cannot complete this action.Please try again.Troubleshoot issues with Windows SharePoint ervices".

Please help me,How to resolve this?

Thanks in advance,vel