URL path length restrictions in SharePoint 2010

There must always be a series of questions –

Is there any solution for URL maximum length restriction?

I am unable to create consecutive subfolders due to URL length exceeding 260 characters

Is there any proper fix to solve this issue?

Can I increase maximum allowed URL length that SharePoint can work with?

How exactly does that affect opening a nested-folder-document in say Word or Excel?

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?

Reason is pretty much simple: SharePoint limits URL length because all relative URL links are stored in the clear forms on the SharePoint content DB and often 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 storing only 256 characters.

Reference: http://technet.microsoft.com/en-us/library/ff919564(v=office.14).aspx

If you have any questions/queries regarding the mentioned information then please let me know, Thank you.

Unable to process the request. Wait a few minutes and try performing this operation again.

Issue: Most of our clients were having issue while opening the Excel files from their SharePoint sites using Excel web access webpart after an upgrade from MOSS 2007 to SharePoint 2010.

Error: Unable to process the request. Wait a few minutes and try performing this operation again

 

Troubleshooting done:

- Adding the URL in trusted file location.

- Change the settings to open the document with client application form document library. .

Resolution:

After some investigation we found this Blog from the technet , which talks about the same problem:

- Rebooting the server will remedy this, but that is not realistic.

- You can run IISReset /noforce that too should remedy the issue.

- To avoid a complete IISReset, you can manually recycle the Application Pool Running Excel Services. (Please check the blog for additional info)

http://blogs.technet.com/b/excel_services__powerpivot_for_sharepoint_support_blog/archive/2013/01/24/excel-services-2010-quot-unable-to-process-the-request-quot-maximum-private-bytes-size-exceeded-unable-to-complete-the-operation.aspx

How to overwrite or disable the List View Threshold value for particular list in SharePoint 2010 Using PowerShell

If you want to overwrite or disable the threshold limit of List View items for particular list then execute the following cmdlets in Powershell.

$WebApplication = Get-SPWeb http://<SiteCollectionName>

$List = $WebApplication.Lists["List Name"]

$List.EnableThrottling = $false

$List.Update()

There is one property of SPList called "Enable Throttling" which has to be set to false to overwrite the threshold limit set on Web Application for all the lists.

I hope this is helpful and If you have any questions then please let me know, Thank you.

Applies to SharePoint Server 2010.

Error while opening excel files after upgrade your SharePoint site to 2010

Error Message: The workbook cannot be opened because it is not stored in an excel services.

Cause: By default the setting in the library is set to "open the file in browser".

Resolution: Change the Library settings to open files in Client application.

Steps: 

-Open your document Library

-Click on "Library" under "Library tools" (See screenshot)

 

-To the extreme right on the ribbon, please click on "Library settings".

-Click on Advanced settings under General settings.

-In the settings for "Opening Documents in the Browser"

-Change the radio button and select Open in the client application.

-Click OK

You must change this setting in all the document libraries.

 

Applies to: SharePoint Foundation 2010/SharePoint Server 2010.

 

 

Attachments doesn’t open when attached with a discussion boards.

The lists can be configured to open documents in client mode but this doesn’t happen with discussion boards and other collaborative lists which do not have a special provision for attachments.

Error messages may say that the features included in the files are not supported by web browser.

Reason: Uploaded excel files may contain macros or other calculations which needs an excel client. In SP 2010 all the office documents open in client by default so ether make the settings suggested below or turn on a feature to open all documents in client by default.

Steps to do this:

• Go to Site Actions 
• Site settings 
• Site collection Features 
• Open documents in Client Applications by default

Applies to: SharePoint Server 2007/2010.