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