Amol Ghuge's SharePoint Blog

23 April, 2013

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

22 April, 2013

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.

21 April, 2013

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: