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


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


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

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

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.

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:

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:-

Excel Services Application not available - Event 5234

Excel Services Application save failed - Event 3348

Excel Services Application configuration database access failed - Event 5244

Excel Services Application memory allocation failed - Event 5256

Max memory configured for Excel Services Application exceeded - Event 5255

Office support





23 September, 2013

Health Analyzer problems - SharePoint 2010 + SharePoint 2013

Recently our farm has reflected some strange problems and long list of exceptions in Health analyzer. It was not so critical because Microsoft has made it so easy by publishing these following articles:

The settings for Word Automation Services are not within the recommended limits

A State Service Application has no database defined

Accounts used by application pools or service identities are in the local machine Administrators group

All State Service databases are paused for a State Service Application

Some content databases are growing too large

Content databases contain orphaned Apps

Millions Thanks to Microsoft & the product team for publishing these articles.