Sign in
 
HomeOnline20132010Other VersionsRelated ProductsLibraryForumsGallery
TechCenter >
> 
> 
Strang issue with Sharepoint list - missing records

Answered Strang issue with Sharepoint list - missing records

  • Friday, May 11, 2012 4:44 PM
     
     
    Sign In to Vote
    0

    Hi,

    We currently have a strange issue with a regular list in Sharepoint. The list in question shows a record count of 409 items when we go to "All Site Content" but once we click on the list and go to the all items view - only 225 show up.

    I verified the view settings and there are no filters what so ever.

    After hours of troubleshooting... I decided to open the list in Sharepoint Designer and found this:

    A bunch of files are stored under the list folder with a pad lock icon beside them - and coincidentally, the number prefixed on the files are all the missing item ID numbers.

    I decided to right click on them – and then clicked on clear checkout and all the items re-appeared – however, when clicking to edit the files in the front end – it is extremely slow….

    Any idea what I should do?

    Thanks

    Martin

     

All Replies

  • Friday, May 11, 2012 10:43 PM
     
     
    Sign In to Vote
    0

    Did you clear checkout on all of the docs in SPD? If not, (meaning you can test this theory), go to Doc Lib settings and select "Manage checked out files". If docs are found there that are missing when using View All, attempt to "take posession". If sucessful, you should now see it in View All view. Check the doc in then compare the speed to ther other method. Once it's checked in, others should be able to view it as well.

     
  • Monday, May 14, 2012 6:26 PM
     
     
    Sign In to Vote
    0

    Did you clear checkout on all of the docs in SPD? If not, (meaning you can test this theory), go to Doc Lib settings and select "Manage checked out files". If docs are found there that are missing when using View All, attempt to "take posession". If sucessful, you should now see it in View All view. Check the doc in then compare the speed to ther other method. Once it's checked in, others should be able to view it as well.

    Hi SPSL2012,

    I forgot to mention that this is a simple list and *NOT* a document library. So it makes absolutely no sense why files were checked out in the list... Any clue?

     
  • Monday, May 21, 2012 7:17 AM
     
     Answered
    Sign In to Vote
    0

    Hi,

    As far as I know, Check in/out is only available on libraries. However, the following reason will result in lock a list item.

    •Consider that the first user clicks the link to switch to edit mode, and we lock the list item. If the user just closes his browser without proceeding any further (or his network fails, or his system crashes, or his computer dies), the item will remain locked, and everybody else will be prevented from editing it until we release it somehow (usually after some timeout, or by tinkering with it outside of the web part).

    •Your web part will enforce that lock, but no other code will do so, including SharePoint itself (through another web part or from server-side code) and the whole outside world (through the Client Object Model). So any given list item would still be susceptible to change while the user is editing it, and SPListItem.Update() would still raise an exception if that happens.

    http://stackoverflow.com/questions/5969735/preventing-multiple-users-to-edit-the-same-list-item-in-sharepoint-2010

    Thanks,

    Rock Wang

    Rock Wang TechNet Community Support

     
  • Monday, July 09, 2012 1:00 PM
     
     
    Sign In to Vote
    0

    I too am having the same issue, and the documents provided do not provide a solution as the problem is with a List with no version control, and not a Document Library.  We are linking this list to MS Access and as soon as we make a change to an item in the linked list, the records disappear and seem to show up after an extended period of time (more than 24 hours).

    It does not appear we have access to our sites via SharePoint Designer and am wondering if there are any other solutions to this issue as the problem is preventing users access to certain software that uses this list to determine active versions of the software.

    Thanks!

     
  • Monday, July 09, 2012 1:14 PM
     
     
    Sign In to Vote
    0
    How did you view your list in this format in SharePoint designer?  I am using 2010 and cannot seem to view a file folder type list to unlock the list items...