Posts

Showing posts from December, 2016

Sitecore Deadlock Analysis for Item Bucketing

Image
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

Image
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

Image
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?

Image
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
https://dev.sitecore.net/Downloads/Sitecore_Experience_Accelerator/10/Sitecore_Experience_Accelerator_10_Initial_Release.aspx
Requirements
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 …