General SharePoint 2010 Migration Issues

I think every developer working with SharePoint 2010 Migration might have seen issues related to MissingFeature and MissingWebPart in Test Content DB report file. Depending on site customization, we may ignore MissingWebPart category because it is not going to block us from migrating site to SharePoint 2010. still it is always good to resolve every issues identify into Test Content DB report.

Here is very good link which is describing how to troubleshoot and resolve issue related to MissingFeature and MissingWebPart: http://blogs.msdn.com/b/paulking/archive/2011/10/05/removing-missingfeature-database-amp-missingwebpart-webpart-class-errors-from-sharepoint-2010.aspx

Happy Migration!

SharePoint 2010 Migration Issue : Exception: Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed. ALTER DATABASE statement failed

I have received below error while mounting / attaching content database to SharePoint 2010 site during SharePoint 2010 migration process. after debugging more into issue, I have found there is database backup running at the same time when I have mounted database to SharePoint farm.

Error: [powershell] [SPUpgradeSession] [ERROR] Exception: Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed. ALTER DATABASE statement failed.

[powershell] [SPUpgradeSession] [ERROR]:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)

   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

   at Microsoft.SharePoint.Utilities.SqlSession.ExecuteNonQuery(SqlCommand command)

   at Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence.Upgrade()

   at Microsoft.SharePoint.Upgrade.SPUpgradeSession.Upgrade(Object o, Boolean bRecurse)

Resolution: We have to disabled all the database backup job when we are mounting database. after making sure there is no database backup job running on SharePoint side and SQL Server side - I am successfully able to mount the content database to SharePoint 2010 site.

Every time, I learn new issue and resolution while working with SharePoint 2010 migration.

:)

Reference link: http://msdn.microsoft.com/en-us/library/aa238194%28v=sql.80%29.aspx

How to add managed property and configure advanced search in SharePoint

Here is very good detail information about how to add managed property from central admin site and how to use same managed property into advanced search page:

http://waelmohamed.wordpress.com/2011/05/31/add-custom-search-properties-in-your-advanced-search-sharepoint-2010/

SharePoint 2010 Search Refinement Panel web part

In SharePoint 2007 - I have used "faceted search" from codeplex http://facetedsearch.codeplex.com/ to grouping search results by different category name, total number of values inside group, etc... BUT SharePoint 2010 provides OOB web part called "search refinement panel" in which we can achieve more or less same type of results and output like faceted search.

For achieving grouping functionalities in SharePoint 2010 search refinement panel web part - we can create managed property from central admin and can customize XML for search refinement web part to display search results by different categories.

Result type, site, author and modified date categories are by default in search refinement panel web part.

Here are some reference links for customizing refinement panel web part in SharePoint 2010:

http://searchingsharepoint.wordpress.com/2011/06/09/customizing-the-refinement-panel-for-sharepoint-2010-search/

http://microsoftsharepointandbeyond.blogspot.com/2011/04/sharepoint-2010-refinement-panel.html

http://vinaybhatia.blogspot.com/2010/11/add-custom-category-to-search.html

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

Error "Unexpected System.NullReferenceException" after restoring a content database

For one of the specific project reason, we have to restore content database to SharePoint 2010 environment. after we restored the database, suddenly I started receiving "Unexpected System.NullReferenceException" error while opening SharePoint site. we checked every configuration settings from central admin and database side and every was correct. still we didn't able to find the solution.

It seems error is because of caching issue between some of the web front end servers.

Here is link which is explaining about root cause and solution of the error: http://myspworld.wordpress.com/2012/02/06/unexpected-system-nullreferenceexception/

Happy Debugging !!