Friday, February 17, 2012

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

Useful SharePoint Search Enhancements - Codeplex

How to configure Reporting Services for SharePoint 2010

SQL Server 2008 R2 Reporting Services Add-ins:

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

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:

Some good PowerPivot installation links

Custom master page SharePoint 2010

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

Thursday, February 16, 2012

Some useful SharePoint 2010 Migration Links

Here is good link for SharePoint 2010 Migration contents

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:

SharePoint Server 2010 browser support information

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

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:    

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

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

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

Wednesday, February 15, 2012

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:

Some handy Powershell Commands

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

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:

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.

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

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: