Maximum number of items to delete has been reached. Please contact the Site Collection Administrator

Question

I am facing this error when i am programatically delete record from sharepoint list. column is lookup column in another list and i have set cascade delete option enable in list. I am facing below error. Can any one give me solution to delete record programatically

Maximum number of items to delete has been reached. Please contact the Site Collection Administrator.

Answer 1

try this

Open SharePoint 2010 Management Shell and execute the following:

$site = spsite "URL"

Now we have to set the maximum number of items that can be checked in a Cascade or Restrict delete operation.

It is applicable to lists which have referential integrity enabled in them.

$site.WebApplication.CascadeDeleteMaximumItemLimit = [number of items]

By default the [number of items] = 1000

Here is a source post;

Hope it helps,

Andrew

Answer 2

Try to change the CascadeDeleteMaximumItemLimit property. This controls the duration of a short-term Web site lock that is taken to perform referential integrity delete operations.

You can try this in powershell:

$site = spsite "http://[your site collection URL]"
$site.WebApplication.CascadeDeleteMaximumItemLimit = [# of items]