Results 1 to 5 of 5

Thread: Sharepoint - Bug lists with more than 1000 items and interruption of the inheritance of permissions

  1. #1
    Join Date
    Jan 2011
    Posts
    42

    Sharepoint - Bug lists with more than 1000 items and interruption of the inheritance of permissions

    It 'a good time I'm going crazy with an error on Sharepoint Services 3. I have introduce the scenario in which I was. I had installed an event handler for changing permissions on the individual item. This event handlers (much like this for instance) was in error when I tried to break the inheritance of permissions than those specified in item-level list. The error, however, appeared only when the list in question was more than 1000 items.

  2. #2
    Join Date
    Nov 2009
    Posts
    862

    Re: Sharepoint - Bug lists with more than 1000 items and interruption of the inheritance of permissions

    In practice that is generated by the object model of SharePoint a query with a SQL syntax error. Clearly, compared with an error of this kind we can do little. But we can understand what is unleashed. After some tests and after reading this post , which reports the same error using lookup columns multiscelta with the option enabled, I have studied the configuration of my list and I came to this conclusion: among the fields that had defined , there were four fields of type user / group with the option of multiple choice enabled. The fields of type user / group at the end of the games are their fields of type lookup, then this error happens just because:

    • the list has more than 1000 items
    • the list has lookup field (or type of user / group) with the option of choosing multiple active
    • route is the inheritance of permissions on the unit by the object model (item.BreakRoleInheritance (false)


    The only way to avoid this error was, therefore, avoid using lookup field type with multiple choices. Fortunately, instead of installing Service Pack 1 for WSS 3.0 and MOSS 2007 has solved the problem in question completely!

  3. #3
    Join Date
    Apr 2010
    Posts
    75

    Re: Sharepoint - Bug lists with more than 1000 items and interruption of the inheritance of permissions

    This holiday season, I found myself faced with this strange error. In practice, only certain documents in Word and Excel entered into several different folders to SharePoint document library, once you choose to go on your face I could change this error bell:

    'Edit Document' Requires Windows SharePoint Services-compatible application and Microsoft Internet Explorer 6.0 or greater.

  4. #4
    Join Date
    Nov 2009
    Posts
    580

    Re: Sharepoint - Bug lists with more than 1000 items and interruption of the inheritance of permissions

    I realize however that the error was raised if only:

    • the folder in which to insert the attachment had a very long title
    • the filename that was long, to exceed a certain limit coupled with the name and title of the document library folder

    Yes, because if attach files with short file name, the error was not raised, as he did in the presence of file names of a certain length. As often happens, my head, threw me on the right track and we found out that this is a real limit of SharePoint, due to the WebDAV protocol.

  5. #5
    Join Date
    Feb 2008
    Posts
    624

    Re: Sharepoint - Bug lists with more than 1000 items and interruption of the inheritance of permissions

    These limits are documented:

    1. The name of a folder can not exceed 256 characters
    2. A name of a file can not exceed 128 characters
    3. The full URL can not exceed 260 characters (in my case were given by the trio: [Name of document library] + [folder name] + [Attachment Name])

Similar Threads

  1. Replies: 6
    Last Post: 15-07-2011, 10:27 PM
  2. Sharepoint Tips for adding items in List
    By Leoniee in forum Tips & Tweaks
    Replies: 2
    Last Post: 01-02-2011, 07:54 AM
  3. Replies: 3
    Last Post: 08-01-2011, 06:32 AM
  4. Sharepoint Manage Permissions
    By ALBUS in forum Operating Systems
    Replies: 2
    Last Post: 27-06-2009, 01:02 PM
  5. Reset child permissions / inheritance of folder with script
    By Thomas in forum Windows Server Help
    Replies: 8
    Last Post: 03-02-2009, 05:50 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,636,560.99018 seconds with 17 queries