The file is currently checked out or locked for editing by another user

One time I got above error while renaming folder in SharePoint 2007 document library, error is because someone checked out the file and at that time I don’t have a way to figure out who checked out the file, so I got different alternate solution to rename folder name inside document library – SharePoint Designer :)

http://hristopavlov.wordpress.com/2008/12/02/the-file-is-currently-checked-out-or-locked-for-editing-by-another-user/

Useful SharePoint Search Enhancements - Codeplex

https://msmvps.com/blogs/ivansanders/archive/2011/07/26/sharepoint-search-enhancements-available-on-codeplex.aspx

How to configure Reporting Services for SharePoint 2010

SQL Server 2008 R2 Reporting Services Add-ins: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=622

Configuring Reporting Services 2008 R2 in SharePoint 2010 Integrated Mode – Part I 

http://dinesql.blogspot.com/2010/06/configuring-reporting-services-2008-r2.html

http://msdn.microsoft.com/en-us/library/bb326356.aspx

Uninstall SharePoint Server 2010

In some scenarios we have to Uninstall SharePoint 2010 from system, sometime we feel that like other Microsoft products, it is very easy to Uninstall SharePoint from environment, but when we used wizard approach many time system is not removing/uninstall everything for SharePoint server, there are some manual steps we need to follow to totally Uninstall SharePoint 2010 from system.

Reference Links:

http://mscerts.programming4.us/sharepoint/uninstalling%20sharepoint%202010.aspx

http://technet.microsoft.com/en-us/library/cc262874.aspx

Uninstall of Office web app: http://technet.microsoft.com/en-us/library/hh230314.aspx

Some good PowerPivot installation links

Step by step guide for installing PowerPivot for single server: http://powerpivot-info.com/post/66-step-by-step-guide-on-installing-powerpivot-for-sharepoint

http://powerpivotgeek.com/server-installation/single-server-install-rtm/

How to install PowerPivot in server farm: http://msdn.microsoft.com/en-us/library/ee210708(SQL.105).aspx

PowerPivot installation videos: http://social.technet.microsoft.com/wiki/contents/articles/install-powerpivot-for-sharepoint-on-a-domain-controller.aspx

Custom master page SharePoint 2010

http://sharepoint.microsoft.com/blog/Pages/BlogPost.aspx?PageType=4&ListId={72C1C85B-1D2D-4A4A-90DE-CA74A7808184}&pID=426

http://msdn.microsoft.com/en-us/library/ee539981%28office.14%29.aspx

Difference between SharePoint 2010 standalone – server farm

When I was referring Microsoft link for installing PowerPivot on single server, I caught up with two different SharePoint 2010 installation type

1) standalone install 2) server farm install.

So I was curious to see what are the differences between these two options, Here is good TechNet link which talks about differences between two version while installing SharePoint 2010

http://social.technet.microsoft.com/Forums/en/sharepoint2010setup/thread/d24db2bf-40ee-42b8-9bbc-bd4d9ae41e16

Some useful SharePoint 2010 Migration Links

Here is good link for SharePoint 2010 Migration contents

http://www.sharepointjoel.com/Lists/Posts/Post.aspx?ID=296

How to enumerate site collection and activate feature using PowerShell

Here is link for going through each site collection in farm and activate specific feature using PowerShell commands/scripts:

http://www.sharepointfix.com/2011/01/enumerate-site-collections-subsites-and.html

http://get-spscripts.com/2010/08/bulk-deactivate-feature-and-remove-farm.html

SharePoint Server 2010 browser support information

Here is link which talks about what are the different compatible browser supported by Microsoft for SharePoint 2010

http://technet.microsoft.com/en-us/library/cc263526.aspx

Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Microsoft SharePoint Foundation-compatible HTML editor such as Microsoft SharePoint Designer

I was getting “Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Microsoft SharePoint Foundation-compatible HTML editor such as Microsoft SharePoint Designer. If the problem persists, contact your Web server administrator” error randomly when I clicked on New item of customized SharePoint designer page. I have migrated this site/page from 2007 to 2010 version. After digging more into logs I have found out below detailed error message from correlation token id.

Detailed error messages:

Error while executing web part: System.StackOverflowException: Operation caused a stack overflow.   

 at Microsoft.Xslt.NativeMethod.CheckForSufficientStack()   

 at <xsl:template name="dvt_1.rowedit">(XmlQueryRuntime , XPathNavigator , String )   

 at <xsl:template name="dvt_1.body">(XmlQueryRuntime , XPathNavigator , Double , IList`1 )   

 at <xsl:template name="dvt_1">(XmlQueryRuntime , XPathNavigator , Double )   

 at Root(XmlQueryRuntime )   

 at System.Xml.Xsl.XmlILCommand.Execute(Object defaultDocument, XmlResolver dataSources, XsltArgumentList argumentList, XmlWriter writer, Boolean closeWriter)   

 at System.Xml.Xsl.XmlILCommand.Execute(IXPathNavigable contextDocument, XmlResolver dataSources, XsltArgumentList argumentList, XmlWriter results)   

 at System.Xml.Xsl.XslCompiledTransform.Transform(IXPathNavigable input, XsltArgumentList arguments, XmlWriter results)   

 at Microsoft.SharePoint.WebPartPages.DataFormWebPart.ExecuteTransform(XslCompiledTransform xslCompiledTransform, XsltArgumentList xmlArguments, Boolean bDeferExecuteTransform)   

 at Microsoft.SharePoint.WebPartPages.DataFormWebPart.PrepareAndPerformTransform(Boolean bDeferExecuteTransform)

As per some links what I have found out that when we created page in designer and added some heavy XSLT in a page, in this particular case if page is taking more than second to open and load all the controls then it will failed and displayed above error message in browser. It is known issue and Microsoft also release hotfix for this issue: http://support.microsoft.com/kb/2639184    

Here are some links which talks about same issue and how to resolve this issue.

http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/44cfd798-be7a-4436-8786-bd44049e7def 

http://social.technet.microsoft.com/Forums/en-US/sharepoint2010customization/thread/ad13e5e4-e211-453f-bfef-fe260591154a/

http://social.technet.microsoft.com/Forums/en-US/sharepoint2010customization/thread/81e2da92-ff9e-4a06-9f6b-766936ea73cf/

List tools menu disappear in SharePoint 2010 list ribbon option

I have encounter this issue while 2010 migration process, but after some trial I have realized that above issue is also applicable into any of the SharePoint 2010 sites.

Here is exact scenario : if we add content editor web part into list view page then “List Tools” menu is disappearing from list ribbon, if we delete extra added web part then list tools menu magically will be appear.

I have found some materials in which people are saying that it is expected behavior and it is default Microsoft design, “List tools” menu is connected with List view web part in a page and if we add any other content editor web part in a page then it goes in confused state about which web part to connect for list tools (list view or content editor web part).

Still one guy has written small script which will select list view web part on page load and display list tool menu

http://stackoverflow.com/questions/4848892/list-tools-tab-is-no-longer-available-after-adding-webpart-to-the-page

Here are links for alternative option to display list tools menu in list view web part:

http://www.endusersharepoint.com/STP/viewtopic.php?f=10&t=2027

http://www.glynblogs.com/2011/02/displaying-the-list-toolbar-in-sharepoint-2010.html

SharePoint 2010 search master page

Current 2010 out of the box search master page is not providing support for navigation breadcrumb from where user can navigate to top level site.

Here are some reference links from where we can create our 2010 custom search master page:

http://zenmage.wordpress.com/2011/01/31/sharepoint-2010-custom-search-box-on-master-page/

http://blog.drisgill.com/2010/09/converting-custom-sharepoint-2010.html

http://sp2010searchadapters.codeplex.com/

Some handy Powershell Commands

AddSPSolution: http://technet.microsoft.com/en-us/library/ff607552.aspx  

Get-ChildItem: http://technet.microsoft.com/en-us/library/dd347686.aspx  

Import-Module http://technet.microsoft.com/en-us/library/dd819454.aspx  

Get-SPSolution http://technet.microsoft.com/en-us/library/ff607754.aspx  

Install-SPSolution http://technet.microsoft.com/en-us/library/ff607534.aspx  

Get-SPManagedAccount http://technet.microsoft.com/en-us/library/ff607835.aspx  

New-SPManagedAccount http://technet.microsoft.com/en-us/library/ff607831.aspx   

Disable-SPFeature  http://technet.microsoft.com/en-us/library/ff607879.aspx

SharePoint 2010 gradual upgrade migration method

SharePoint 2010 gradual upgrade method will be useful for large organization in which if they want to migrate some of the site collections from same web application to SharePoint 2010 and if some site collection they want to keep in MOSS 2007 or if they want to migrate remaining ones after sometime.

Microsoft introduced new commands in stsadm addzoneurl into SharePoint 2010 which will redirect any specified incoming request to MOSS 2007 site instead of SharePoint 2010 site URL if URL doesn’t exists into 2010 environment. This method is called “AAA redirect”.

Here is one example for gradual upgrade migration:

Suppose if we have 50 site collections into http://sp.webapplication.com/ web application URL and on a first phase we just want to migrate/move 25 site collections from 2007 to 2010 version, may be it is because of time concern and some other factors. In this case we can logically divide content database structure and we can only migrate 25 site collection/content databases to 2010 version and for remaining 25 site collection we can execute STSADM commands for adding zone url, which specify that if user is requesting any site collection url that is not exists into SharePoint 2010 environment then redirect user to SharePoint 2007 site collection  URL automatically.

Here are some reference links which talks about how we can use SharePoint 2010 gradual upgrade migration method and how we can redirect user from 2010 to 2007 URL if URL doesn’t exists.

http://www.procentrix.com/Community/AmarM/post.aspx?ID=3

http://communities.quest.com/community/sharepointforall/experts-blogs/blog/2010/03/16/gradual-upgrade-in-sharepoint-2010-part-2

http://technet.microsoft.com/en-us/library/ee720448.aspx

Admin svc must be running in order to create deployment timer job SharePoint 2010

During solution package deployment, I have received above error and then I have figured out that “SharePoint 2010 Administrative” service was stopped in my server, once I started the service the package deployment worked good without any errors.

Reference solution links:

http://imak47.wordpress.com/2011/05/11/install-spsolution-admin-svc-must-be-running-in-order-to-create-deployment-timer-job/

http://blog.salamandersoft.co.uk/index.php/2011/03/error-admin-svc-must-be-running-in-order-to-create-deployment-timer-job/

Features\ExcelServerSite\Microsoft.Office.Excel.WebUI.dwp is referenced in the database, but is not installed on the current farm

I was getting above error while migrating contents from 2007 to 2010, as per this MSDN links we can ignore this error while migration.

http://social.technet.microsoft.com/Forums/en-US/sharepoint2010setup/thread/539c4086-0bfe-4c87-9b0a-c4d65642340f/

SharePoint 2007 site templates not appearing into SharePoint 2010

I have came across situation in which after MOSS 2007 to SharePoint 2010 migration – site templates are not appearing while creating new site in 2010, then I have figured out that .STP (site template file) concept has been removed in SharePoint 2010, so for saving any site template in 2010 we need to save file as .WSP which will automatically save solution to solution gallery page and then we need to activate that site template to be appear while creating new sites in SharePoint 2010.

Here are some reference link which talks about how to create site templates in 2010

http://www.learningsharepoint.com/2010/06/20/moving-site-template-stp-files-to-sharepoint-2010/

http://collab.rdacorp.com/2010/01/sharepoint-2010-custom-site-template.html

Insufficient SQL database permissions for user on SQL Server instance, the EXECUTE permission was denied on the object proc_GetProductVersions

I was getting ‘Insufficient SQL database permission’ issue in event viewer and 14 hive log file if I create any sub-site into 2010 environment. from user interface I didn’t see any errors.

Here is alternative option for this issue by granting permission into SQL server database.

Resolution links:

http://sharepointsoldiers.wordpress.com/2011/10/09/insufficient-database-permissions-proc_getproductversions-eventid-5214/

http://sajiviswam.wordpress.com/2011/05/24/the-execute-permission-was-denied-on-the-object-proc_getproductversions-insufficient-sql-database-permissions-for-user/