Solved

Limits to open SharePoint 2010 libraries in Windows Explorer

Posted on 2015-02-05
8
598 Views
Last Modified: 2015-02-14
Hello,
Does anyone know if there are limitation on the number of items in a SharePoint 2010 document library that would prevent it from opening in Windows Explorer?
I can open a library with 33K+ documents but am having a problem with a library where there are 100K+ files.
No errors in the Events or System logs.
Should I follow this article
http://www.mysharepointadventures.com/2011/08/unable-to-browse-large-document-library-in-explorer-view/
Solution

The problem occurs because the size of all the file attributes that are returned by the WebDAV server is much larger than what is expected. By default, this size is limited to 1 MB.

To work around this problem, you need to modify the windows registry on the client computer.

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\WebClient\Parameters\
 Value:
 FileAttributesLimitInBytes
 Data Type: DWORD
 Default Value: 1,000,000
 decimal (1 MB)

Change the default value to a larger number, e.g. 100000000 for 100mb.


Thanks!
0
Comment
Question by:IT-NYC
  • 5
  • 3
8 Comments
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 500 total points
ID: 40592297
Hi,
as the explorer view uses the WebDAV feature and the webclient service on the client side, there are some default settings in Windows 7 like default timeout and maximum upload size mentioned in this MS KB entry:
http://support.microsoft.com/kb/2668751

Besides that the general considerations for large lists and libraries will take account in regards to performance.
HTH
Rainer
0
 

Author Comment

by:IT-NYC
ID: 40594762
Thanks, Rainer!
I will try and let you know.
Have you tried opening libraries with the number of files I mention?
0
 
LVL 44

Expert Comment

by:Rainer Jeschor
ID: 40594871
Hi,
nope - I always tried to keep the libraries / folders on a reasonable size (max 5000 elements on one level).
Too many bad experiences from colleagues and customers who did not follow this approach :-)
But there are also other factors to consider e.g. item level permissions - this can kill performance as well (my first experience on SP 2010 saying you can have thousands of documents and you can have item level permissions - but it seems that nobody really tested the combination of both :-D)
HTH
Rainer
0
 

Author Comment

by:IT-NYC
ID: 40594909
I hear you loud and clear, been there.
In my case, it is a combination of large number of folders and files. Will see it on Monday. I am optimistic :)
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 44

Expert Comment

by:Rainer Jeschor
ID: 40594920
Good luck - and have a nice weekend
0
 

Author Comment

by:IT-NYC
ID: 40594932
You, too.
0
 

Assisted Solution

by:IT-NYC
IT-NYC earned 0 total points
ID: 40599313
It worked!!!
Thanks a lot
I applied the registry setting: FileAttributesLimitInBytes to 100000000
and FileSizeLimitInBytes 200000000
in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\WebClient\Parameters
and
FsCtlRequestTimeoutInSec to 3600 in HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\MRxDAV\Parameters
In IE, modified Compatibility settings as it wasn't opening from the menu (you have to add this site to the Trusted Sites message).
0
 

Author Closing Comment

by:IT-NYC
ID: 40609526
Part of the solution was my own findings.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have just recently built a new SharePoint 2007 farm on a complete Windows 2008 R2 server platform and part of my standard build procedure is to implement a warm up routine, usually in the form of a script that is scheduled every morning to launch …
I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now