Issues regarding maximum URL length
If I've understood this correctly, there's a maximum URL (as opposed to QueryString) length of 255 (or 260?) chars for SharePoint. How exactly does that affect opening a nested-folder-document in say Word or Excel? And is the limit also there for the explorer view? 255 chars isn't a whole lot for a directory and filename structure, so if it also affects the explorer view; is there a way around it?Just now I tried creating a dummy structure in a some subsite document library. When my entire QueryString reached 800-1000 chars, it seems the entire SharePoint site managed to crash. Any ideas on why that happens?
November 27th, 2007 1:11pm

Hi einaros,SharePoint limits URL length because all relative URL links are stored in the clear forms on the SharePoint content DB and offen this links are used as primary keys to link one table with another. Fields which are used to store these links (for instance tp_DirName from the AllUserData table) allow to store only 256 characters. Also SharePoint has the limitation of Leaf Name length (it's for instance DocLib name, file name and etc) because tp_LeafName field from AllUserData table could store only 128 characters.I don't know why SharePoint limits these lengths but it's restricted on the database level.Therefore you could not create anything with URL that's longer than 255 characters.May be I'm wrong and I hope that anybody could explain it more accurate.
Free Windows Admin Tool Kit Click here and download it now
November 28th, 2007 12:43pm

Wouldn't these database field limits also affect the maximum number of nested directories in a document library -- even disregarding an url length limit as such?It strikes me as odd that a limit such as 256 chars is introduced "in this day and age".I'd really appreciate a deep dive into this, as well as common workarounds (if any).
November 28th, 2007 1:36pm

No, maximum number of subfolders is not affected by these limitation. You could find info about all "count&size" limitations here:http://www.microsoft.com/resources/documentation/wss/2/all/adminguide/en-us/stsb07.mspx?mfr=trueAccording to the database structure folder from the document library is like "item" but with another ContentType. So you could create any (< 2 millions) items count BUT for the optimum performance item (and I think folder) count on the one level should be < 2000.Another Microsoft doc (http://technet2.microsoft.com/Office/en-us/library/6f03049f-5bfe-4807-b609-0e2d4a9ec3b51033.mspx) says that "The maximum number of items supported in a list with recursive folders is 5 million items"What is about workaround? What do you need?
Free Windows Admin Tool Kit Click here and download it now
November 28th, 2007 1:54pm

Well the problem, as mentioned in the inital post, is that the document libraries do not accept paths exceeding 260 chars. If you create a doclib with a series of nested directories, it'll eventually throw an error at you such as The specified file or folder name is too long. The URL path for all files and folders must be 260 characters or less (and no more than 128 characters for any single file or folder name in the URL). Please type a shorter file or folder name. This also affects opening documents in e.g. word, as well as browsing with Explorer View.
November 28th, 2007 2:52pm

hmm, I think that you need to cut your doclib subfolder names. I don't see another workaround.
Free Windows Admin Tool Kit Click here and download it now
November 28th, 2007 3:28pm

That's the part that seems odd to me. 260 chars is just ridiculously low for a document library with a hierarchy.
November 28th, 2007 3:52pm

Agree. But it's fact
Free Windows Admin Tool Kit Click here and download it now
November 28th, 2007 4:00pm

I think I'll have to keep bumping this thread until someone from the SP team can make a comment on the matter.
November 28th, 2007 4:03pm

I think that wouldbe good Idea to do but I don't think that Microsoft Product Team does care about such things they would say that willbe fixed in next release of SharePoint.Or if somebody is kind enough will say that willbe fixed in Next Service Pack.
Free Windows Admin Tool Kit Click here and download it now
March 9th, 2008 1:45am

When your folder url is formatted to read in this form : http://server.com/site/subsite/subsubsite/TeamDocuments/foldername instead of in this form : http://server.com/site/subsite/subsubsite/Team%20Documents/Forms/AllItems.aspx?RootFolder=%2fsite%2fsubsite%2fsubsubsite%2fTeam%20Documents%2ffoldername then check the string length and observe the following limitations: http://support.microsoft.com/kb/923906 explains the problem. In IE6 the limit for a folder path is 100 characters, in IE7 the limit is 260. This is the limit for the non url-encoded string, in the shorter 'prettier' format.Otherwise this can confound you if you are counting url characters and trying to figure the breaking length. :-) Also, although the length is claimed to be 260 characters, when trying to use the document library 'send to' functionality, or creatinga new SharePoint link, the url input text boxes do not accept more than 255 characters, so one would do wisely to keep them shorter than 256 characters.
March 26th, 2008 11:21pm

Hi there,Microsoft has published a hotfix for fixing lenght of the URL limitationhttp://support.microsoft.com/kb/956056/Thank you,MuzaffarMickey
Free Windows Admin Tool Kit Click here and download it now
October 3rd, 2008 7:40pm

Hi MuzaffarA,I don't see anything about URL limitation on that Hotfix description.I'm having tha same issue. I have a MOSS farm where our team has deployed an automated solution that uploads documents and creates document libraries that could me nested in several levels. We're having the HUGE problem that those documents cannot be searched nor found via search site.I've seen a couple workarounds for this on the web related to create an alternate virtual directory on IIS that could redirect to the full-very-long URL (http://fmuntean.wordpress.com/2008/05/12/tiny-url-in-sharepoint/) but as far as I understand this article implies creating a virtual directory for each and every document uploaded and that is just imposible.Any idea? I think the redirection thing is a good concept but I'm thinking how to apply that to hundred of documents automatically uploaded on a daily basis.Regards,Marcel JeanneauMicrosoft Peru
June 5th, 2009 2:25am

HiIs the url Limitation issue has been fixed in MOSS 2007.Any Idea?Regards-Raj
Free Windows Admin Tool Kit Click here and download it now
November 3rd, 2009 4:38pm

As of now No.Neeraj Rai
November 11th, 2009 12:47pm

Give me a break. Why microsoft product team is not working on this basic issue.If some one is migrating there file structure this is one the biggest stumbling block.
Free Windows Admin Tool Kit Click here and download it now
March 10th, 2010 7:03pm

IMHO there is nothing wrong here that needs fixing! The reality is this is a web application/site; its not file store and I think should never be treated as such. Your users need to learn to use filters and create Views to differentiate items in the List, not folders. I really wish that Microsoft had never introduced the folder metaphor (after all its not a real folder, its just a View) or the Explore View with drag and drop into SPS 2003 or kept it in later versions - ho hum! :-( So to repeat; this is not file store and should not be used like it is, as it limits its usefulness as a collaboration tool. So I wouldn't hold your breath waiting for Microsoft to 'fix' it. Regards, Garrath.
July 14th, 2010 7:29pm

You are correct GarrathE. The problem is that users are creating folders inside of SharePoint.. a hold back from the days when they stored their files in a File System and organized with folders. The solution is to train users properly.
Free Windows Admin Tool Kit Click here and download it now
January 14th, 2011 5:49am

You are correct GarrathE. The problem is that users are creating folders inside of SharePoint.. a hold back from the days when they stored their files in a File System and organized with folders. The solution is to train users properly.
January 14th, 2011 5:49am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics