If you are working on a Sitecore solution, you will end up referring Sitecore assemblies in your solution. When you deploy your solution to a higher environment or publish it to local Sitecore instance, the Sitecore assemblies referred in solution also gets deployed/published. This creates following problems - chances of accidentally overwriting out of box Sitecore assemblies and breaking your Sitecore instance increased size of your deployment artifacts So how do you exclude Sitecore-provided assemblies when you build solutions?? The sc-packages NuGet feed includes version-specific packages that you can use to easily validate or exclude Sitecore-provided assemblies when you build solutions. You can use the below command to check these assemblies - nuget list Sitecore.Assemblies -Source https://nuget.sitecore.com/resources/v3/index.json -AllVersions How does it work? You can use custom MSBuild logic to exclude Sitecore-provided assemblies from publishing. All you have to do is to ins
Sitecore Publishing Service jobs fail with errors saying - The connection does not support MultipleActiveResultSets
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 state) --- End of stack trace from previous