Tasks keep failing with the error "ExecuteReader requires an open and available Connection. The connection's current state is closed"

If tasks fail and you're getting error 'ExecuteReader requires an open and available Connection. The connection's current state is closed'. Please raise a new case online and reference the title of this article.