Sitecore Docs - Tech Tips by GS

 Recently, a fellow Sitecorian reached out to know my views on a problem he was experiencing related to Sitecore Publishing Service 7. He reported that his publishing service has been configured correctly and was working fine when he checked last. Nothing has changed since then, and all of a sudden the publish jobs have started failing. We jumped into the logs to find out what we can see and it had errors like the one below -  Error in the "TreeNodeSourceProducer" System.InvalidOperationException: The connection does not support MultipleActiveResultSets.    at System.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__126_0(Task`1 result)    at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()    at System.Threading.Tasks.Task.<>c.<.cctor>b__272_0(Object obj)    at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object stat...

Do you know when the SXA module is installed, the Item Bucket Settings from  /sitecore/system/Settings/Buckets/Item Buckets Settings are not considered This is because SXA has its own provider for buckets. You can find this defined in /App_Config/Modules/SXA/Foundation/Sitecore.XA.Foundation.Multisite.config: <setting name="BucketConfiguration.DynamicBucketFolderPath" value="Sitecore.XA.Foundation.Multisite.Buckets.SiteBucketPathProvider, Sitecore.XA.Foundation.Multisite" patch:source="Sitecore.XA.Foundation.Multisite.config"/> 

Welcome to another short story about debugging an issue we faced recently during our production release. We use Azure DevOps build/release pipelines to release our code to higher environments. The Problem We have an Install Sitecore Items task in release pipeline to install Sitecore items on higher environments. We started facing an issue where the task failed with below errors - 2023-12-20T21:17:46.2357659Z Root config: C:\azagent\A3\_work\_tasks\InlinePowershell_31f040e5-e040-4336-878a-59a493355534\1.1.7\sitecore.json 2023-12-20T21:17:46.2383724Z [GraphQLHttpException] Unexpected HttpResponseMessage with code: InternalServerError 2023-12-20T21:17:46.2499102Z at GraphQL.Client.Http.Internal.GraphQLHttpHandler.ReadHttpResponseMessageAsync(HttpResponseMessage httpResponseMessage) 2023-12-20T21:17:46.2500367Z at GraphQL.Client.Http.Internal.GraphQLHttpHandler.PostAsync(GraphQLRequest request, CancellationToken cancellationToken) 2023-12-20T21:17:46.2501478Z at Sitecore.DevEx.Core.Client...

  Ghanendra Singh  wins Sitecore Most Valuable Professional award Elite distinction awarded for commitment and dedication to the Sitecore community   Noida, India — February 09, 2024 ::  Ghanendra Singh, Senior Sitecore Engineer  at Crowe Horwath IT Services LLP has been named a Most Valuable Professional (MVP) in the Technology category  by Sitecore ® , a global leader in end-to-end digital experience management software. Ghanendra Singh  was one of only 147 Technology MVPs worldwide to be named a Sitecore MVP this year. Now in its 18 th year, the MVP program recognizes professionals who actively share their knowledge and expertise with online and offline Sitecore communities to help them best utilize Sitecore products to deliver premier customer experiences. Selected from more than 16,000 certified developers and over 30,000 active community participants, the 247 MVPs are truly an elite group. This year’s MVPs were selected by a panel of S...

Hello!! This year started with a bang for me as I got my first Sitecore MVP title. This year, I have mostly worked on Sitecore 10.1.1 as part of IT team of an accounting services organization. Due to my nature of work, I dont have exposure to different projects exploring variety of new Sitecore tools and technologies (like my other fellow MVPs have), but I have used this year to upgrade my learning and dig deeper into Sitecore XP on which I primarily work. Below are my contributions this year -  Sitecore Blogs Below are the links to all my blogs which I have published in year 2022 on Sitecore.  https://ghanendras.blogspot.com/2023/02/experience-of-first-time-sitecore-mvp.html https://ghanendras.blogspot.com/2023/02/make-sitecore-instance-faster-using.html https://ghanendras.blogspot.com/2023/03/solr-search-facet-values-limited-to-100.html https://ghanendras.blogspot.com/2023/06/testing-sitecore-with-selenium-nunit.html https://ghanendras.blogspot.com/2023/08/animated-gif-files...