Amol Ghuge's SharePoint Blog

09 October, 2013

October 2013 Cumulative Update Packages for SharePoint Foundation 2010 and SharePoint Server 2010

October 2013 Cumulative Update Packages for SharePoint Foundation 2010 and SharePoint Server 2010 have been released. Use the following links to download the update packages:

October 2013 CU for SharePoint Foundation 2010 - KB 2825824 http://support.microsoft.com/kb/2825824
October2013 CU for SharePoint Server 2010 - KB 2825786 http://support.microsoft.com/kb/2825786
October2013 CU for Project Server 2010 - KB 2825793 http://support.microsoft.com/kb/2825793

Note This is build 14.0.7110.5000 of the cumulative update package.

Important:

To install this hotfix, you must have either SharePoint Server 2010 Service Pack 1 (SP1) or Service Pack 2 (SP2) installed. For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:

2510766 http://support.microsoft.com/kb/2510766 - List of all SharePoint 2010 and Office Server 2010 SP1 packages

2687522 http://support.microsoft.com/kb/2687522 - List of all SharePoint 2010 and Office Server 2010 SP2 packages.

05 October, 2013

SharePoint Tools

Free SharePoint 2010 Sites Templates: http://sp2010teamplates.codeplex.com

Free WebParts for SharePoint 2013 and SharePoint 2010: http://webpartgallery.codeplex.com

SharePoint 2010 FBA Pack: http://sharepoint2010fba.codeplex.com

SharePoint 2010 Send Emails With Attachments - Workflow Activity: http://sharepointstuff.codeplex.com

SharePoint 2010/2013 Tabbed Web Part Zone: http://sharepointtabs.codeplex.com

AutoSPInstaller: http://autospinstaller.codeplex.com

SharePoint Client Browser for SharePoint 2010 and 2013: http://spcb.codeplex.com

SharePoint 2010 - Community Projects: http://lifeinsharepoint.codeplex.com

SharePoint 2010 Bulk Document Importer: http://spbulkdocumentimport.codeplex.com

SharePoint 2010 CSV Bulk Taxonomy TermSet Importer/Exporter: http://termsetimporter.codeplex.com

SharePoint 2010 Batch Edit: http://sp2010batchedit.codeplex.com

SharePoint 2010 automatic sign-in with mixed authentication: http://spautomaticsignin.codeplex.com

SharePoint 2010 HTML5 MasterPage Templates: http://sharepoint2010html5.codeplex.com

Nivo Slider Web Part SharePoint 2010: http://nivowebpart.codeplex.com

Export Version History Of SharePoint 2010 List Items to Microsoft Excel: http://exportversionhistory.codeplex.com

AuditLog For Sharepoint 2010: http://auditlogsp.codeplex.com

SharePoint 2010 Filtered Lookup Field: http://sp2010filteredlookup.codeplex.com

SharePoint CAML Query Helper for 2007, 2010, and 2013: http://spcamlqueryhelper.codeplex.com

LDAP/AD Claims Provider For SharePoint 2010: http://ldapcp2010.codeplex.com

SharePoint 2010 Fluent Ribbon API: http://spribbon.codeplex.com

SharePoint 2010 Print List Ribbon Button: http://spprintlistbutton.codeplex.com

SharePoint AJAX Toolkit for SharePoint 2010 and 2013: http://sharepointajax.codeplex.com

Responsive SharePoint: http://responsivesharepoint.codeplex.com

SharePoint 2010 Google Maps V3 WebPart: http://spgooglemappart.codeplex.com

SharePoint 2010 Word Automation: http://sp2010wordautomation.codeplex.com

Sharepoint 2010 "Hyperlink with Picture" Column Type: http://spimagehyperlink.codeplex.com

SharePoint 2010 Timesheet: http://sp2010ts.codeplex.com

SP List Kit for SharePoint 2010: http://splistkit.codeplex.com

Show or Hide SharePoint 2010 ribbon based on SharePoint Groups: http://spribbonvisibility.codeplex.com

01 October, 2013

Recently published content for SharePoint 2013

Published the week of September 23, 2013

New

Blog: How to display values from custom managed properties in the hover panel in SharePoint Server 2013

Blog: How to add a custom action to the hover panel in SharePoint Server 2013

Updated article

Software boundaries and limits for SharePoint 2013 updated the "SharePoint Apps limits" section with new guidance for Access app limits.

Published the week of September 16, 2013

New

Blogs:

Published the week of September 9, 2013

New

Blogs: Understanding how search results are displayed in SharePoint Server 2013 and Understanding how item display templates and hit highlighting work in SharePoint Server 2013

Published the week of September 2, 2013

New article

Result types and display templates that are used to display search results in SharePoint Server 2013 Learn about the default result types and display templates that are used to display search results.

Blog post: New Storage and SQL Server capacity planning article for SharePoint Server 2013

Blog post: Updates to search ranking models in SharePoint Server 2013

Reference: technet.microsoft.com

Applies to: SharePoint 2013.

24 September, 2013

Workbooks fail to load + Event 5231 + Event 5239 + Event 5240 + Error communicating with Excel Services Application + Unable to process the request = SharePoint 2010

Checking event logs as well as health analyzer reports on a daily basis or you can call it as SP check outs on a routine basis is a good practice to make your farm free from errors and take timely action on the reported errors.

I am maintaining this habit from a long time and with respect to this, I found some string of problems with respect to excel services. Let me explain here step by step so that all points will be covered and your issue will be resolved as soon as possible.

Farm topology:

5 front ends + 2 application servers + 2 SQL in cluster mode (SQL SERVER 2008 R2)

SP VERSION: SharePoint Server 2010 with SP2

What I noticed in event logs?

Event ID: 2159: Event 5240 (Excel Services Application) of severity 'Error' occurred 11 more time(s) and was suppressed in the event log

Event Id: 2159: Event 5586 (SharePoint Foundation) of severity 'Error'

Occurred 22 more time(s) and was suppressed in the event log

ULS LOGS:

09/24/2013 22:40:15.02 w3wp.exe (0x2A2C) 0x28CC Excel Services Application Web Front End 5240 Critical

There was an error in communicating with Excel Calculation Services http://:SP2010/0a8875975aed471cb086cd8411bfde97/ExcelService*.asmx exception: An error has occurred. [Session: User:]

If I tried opening any excel file which has been set as browser enabled then getting the following error message:

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

Followed MS best practices article but of no use:

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

What i tried:

1) Server reboot resulted in no change in the results

2) Restarting excel services results in no change in the results

3) IISRESET – no change.

Imp note:

1) Make sure the account that we are using to host excel service application does not locked.

2) Make sure the corresponding service account and an application pool account has sufficient permissions in SQL as well as for excel service application.

Resolution:

In my case, recycling the specific application pool which has been used for excel service application resolves the issue.

I you are not sure as how to identify the specific application pool as it will be a long guid of numbers. Don’t worry, it very simple- Three cheers to Eric Harlan for this article: http://www.ericharlan.com/Moss_SharePoint_2007_Blog/which-sharepoint-2010-web-application-pool-controls-which-service-account-a177.html

Multiple resolutions for this issue:-

1) Stopped the application pool, wait for error to appear in ULS and start the app pool again.

2) Disable the ASP.NET Impersonation again.

1. How to check this-

2. Open IIS manager (Run-inetmgr)

3. Websites section

4. SharePoint web services root

5. Authentication section- double click on it

6. Make sure the asp.net impersonation should not be enabled.

3) Verify that Identity property of this application pool is setting to the SharePoint farm account like this (It should be domain\account.)

How to check this- Open IIS then go to “SharePoint Web Services Root” application pool

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Happy SharePoint to all of you!

Product applies to:

1) SharePoint Server 2010

2) SharePoint Foundation 2010

3) SharePoint Server 2013

References:-

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

Excel Services Application not available - Event 5234

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

Excel Services Application save failed - Event 3348

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

Excel Services Application configuration database access failed - Event 5244