Showing posts from 2016

Sitecore Deadlock Analysis for Item Bucketing

Here I am sharing my detailed analysis of Sitecore Dead-lock which was occurring on our production site because of using a  Fast query for Item bucketing search.
Recently we faced the site down issue; sometimes our site went down for some time like 2-3 minutes in some intervals and then automatically up, and we also noticed that traffic was huge on the site(concurrent request was around 1000) during the downtime of the site.
After Detail analysis of the logs we found some deadlock victims as below:
Exception: System.Data.SqlClient.SqlException Message: Transaction (Process ID 65) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Source: .Net SqlClient Data Provider    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean…

Check Sitecore Items having more than 100 child Item through Sitecore Database Query

As Sitecore recommendation, the number of items under any given node, 100 or less is considered the best for performance and usability. If items are increasing periodically then we should plan accordingly. 
For example, a Blog folder where Blog item increasing on a daily basis, we should create day/month/year format folder structure or use an item bucketing to store the large number of items.
But in real life scenario, sometimes we don't follow the Sitecore best practice and dump large number of items under one single node.
I involved one of the performance tuning task in my project and want to generate the report to get all the Sitecore items that having more than 100 child items, The Quick solution came in my mind is a direct database query in the Sitecore database, however there are also other good option to generate this report like Sitecore API, Powershell script, Content search APIs Etc. 
But I didn’t dig into these approaches, as I need to provide this report quickly, and I app…

Links Removed from master Database when we delete reference item from other database in Sitecore 7

If Your Project is running on sitecore7 update 3 or below version, then you should read this blog to avoid the Link tagging deletion problem from master database:

Have you ever faced this issue?, you switched to a different database than the master database, deleted an item, and selected "Remove Links" in the breaking links dialog box, the links would be removed from the master database instead of the selected database.
Yes, I recently faced the same issue in one of my project which is running on Sitecore 7.0 rev. 130918.
I deleted some items from web database with selected "Remove Links" in the breaking links dialog box, and the links removed from master database instead of web database.
But as per the expected behavior it should delete from web database instead of master database as I selected the current database as web.
So this is the problem in this version and I lost my production data(tagging) from master database due to this behaviour, Thanks  to my DBA who quic…

Bad IL Range Exception after installing SXA in Sitecore 8.2?

Have you ever experienced the same exception after the SXA(sitecore experience accelerator) installation on Sitecore 8.2? What is the main root cause for this exception?
After installing the Sitecore SXA, Content editor showing the below error:

Server Error in '/' Application. Bad IL format. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.  Exception Details: System.BadImageFormatException: Bad IL format.
I also faced the same exception after installing the SXA in Sitecore 8.2, I followed the same step as per the sitecore guideline
Before installing SXA, ensure that you have the following: Sitecore Experience Platform 8.2 initial release or Sitecore Experience Platform 8.1 Update-3Sitecore PowerShell …

How Sitecore MVP Community Is Growing from Last 8 Years

The Sitecore MVP community is growing really very fast, and through this Graph you can easily identify the exact number of Sitecore MVP awarded in each year for example in year 2008 it was 13 MVPs in the community and in the year 2016 we have 221 MVPs in the community.
This graph clearly shows the incremental progress of the Sitecore MVP community from the Year 2008 to 2016.
2017 MVP nomination is going on, and getting more information regarding MVP Program is really good for us like who is the first Sitecore MVP? Who is the life- time Sitecore MVP? How many MVPs are there in 2008, 2009 etc?
The same question came to mind, and I thought to collect all the related information and post the consolidate blog for the same.

So I collected all the information from the sitecore site and different web sources/sites, links etc. and tried to figure out the exact numbers and list of the Sitecore MVPs.
Number of Sitecore MVPs Year Wise
YEAR Number of MVP 2008 13 2009 12 2010 20 2011-12 52 2013 42 2014 12…