Move-SPSite: Operation is not valid due to the current state of the object

Every day we face some strange issues in SharePoint, if it’s working before then why it suddenly stops working! Big question-hmm??

Today we are going to discuss one similar scenario and I am pretty much sure you will comes up with different resolution’s because this issue might vary from environment to environment so resolutions might be different.

Problem description:

One of our content database has already reached the 100GB mark so as per Microsoft recommendations, it’s better to move the site collections to new database as it might create some problems while doing backup and restore. 

So the plan to move some site collections from existing database to new database. For this purpose, we have created a new database by means of central administration.

One thing I wanted to clear that we are doing backup-restore activity, we are moving some heavy site collections between databases only.

In SharePoint 2010, we have an inbuilt command to move the site collections between databases, please refer the following:

Move-SPSite <http://ServerName/Sites/SiteName> -DestinationDatabase <DestinationContentDb>

So we make modifications as per our databases i.e. URL of the site collection and name of the destination database.

As soon as we hit enter, the PowerShell command throws an exception as mentioned below.

Error message:

Move-SPSite: Operation is not valid due to the current state of the object

Troubleshooting done:

-Checked the status of site collection-whether it’s set to lock/read only?

-Checked the status of the database-whether it’s online/offline?

-Tried detaching the source and destination databases and reattached again but still no results

-Tried moving site collections to existing databases- this one works!

-Tried creating a site collection in newly created database- works!

-The site that we have just moved to existing DB- tried moving to the destination database (where we are facing to problem)- Failed!

-Tried creating a new database for different web application and performed the same operation- Failed!

-checked the health analyser again to verify for any new errors

-Found this error which we have neglected-Databases running in compatibility range, upgrade recommended.

<This is the main culprit>

Resolution:

We ran this command on the source database from which we were trying to move the site collections to destination database.

upgrade-contentdatabase -Name <> -Webapplication <>

Operation completed successfully.

Tried running the move-spsite command and executed successfully without any issues…

By this way we have overcome this error message but as I mentioned in the beginning resolution might vary from environment to environment so request you to please share if you have different resolution part from the above mentioned so that it would be beneficial to others as well.

If you have any queries/questions regarding the above mentioned information then please let me know, I would be more than happy to help you as well resolves your issues, Thank you.

Product Applies To:

SharePoint Server 2010

SharePoint Foundation 2010

SharePoint Server 2013

How to Create a New SharePoint Group

Use the following steps to create a new SharePoint Group:

·         Choose Site Settings from the Site Actions and Click Modify All Site Settings.

·         Click Advanced Permissions from the Users and Permissions column

Caution: Check if the site you are adding the group to is inheriting permissions from its parent site. The site is inheriting permissions from its parent if you see the following message: “This Website inherits permissions from its parent Web site. To manage permissions directly, click Edit Permissions from the Action menu.”

·         To break Inheritance from parent site and give this site unique Permissions, click Edit Permissions from the Actions menu.

Note: You can switch back and forth between these settings as needed by selecting Inherit Permissions from the Actions Menu. However, it is important to realize that whenever a site is switched to inheriting permissions from the parent site, all unique permission settings within the site are discarded.      

·         Click OK on the confirmation pop-up.

·         Click New to open the new menu, and select New Group.

·         Type a Name and Description the new group.

Important: Use the following naming conventions.

SiteName_Designers

SiteName_Contributors

·         Enter the group owner information. The group owner will have complete control over this group, including modifying settings as well as adding or removing group membership. There can only be one group owner.

·         Enter Group Settings, Membership Requests.

Caution: If you select yes for the Auto-accept requests option, any user requesting access to this group will automatically be added as a member of the group and receive the permission level associated with the group.

·         Specify the permission level for the Groups.

·         Click Create to create the new group.

How to Add Users to a Group in SharePoint

Use the steps below to add a user into a SharePoint Group:

1.   Choose Site Settings from the Site Actions and Click People and Groups present below Modify All Site Settings.

2.   Click Advanced Permissions from the User and Permissions column.

3.   Click the Groups heading on the left Quick Launch bar.

4.   From the “People and Groups: All Groups” page, click the name of the group to add users or groups to. This opens a page listing the current membership of the group.

5.   Click New to open new menu, and select Add Users.

6.   From the Add Users page, type domain name (i.e. domain name\userid) and click the check name icon or click the phone book icon and search for the name.

7.   Select which group to add the users to.

8.   Click OK.