Solved

Limits to open SharePoint 2010 libraries in Windows Explorer

Posted on 2015-02-05
8
528 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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

A question that is asked often, is how to generate sequential numbers in InfoPath Forms. The best way to achieve this is to use a SQL database, along with a stored procedure and a web service to connect Forms Services to the DB. The first thing t…
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…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

708 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

12 Experts available now in Live!

Get 1:1 Help Now