Lesson Learned #217:Hands-On-Labs:40197-The service has encountered an error processing your request

This post has been republished via RSS; it originally appeared at: Azure Database Support Blog articles.

We used to have cases where our customer faced the following error messages like following:

  • Msg 40197, Level 20, State 4, Line 6 -The service has encountered an error processing your request. Please try again. Error code 9001.

  • Msg 0, Level 20, State 0, Line 3 - A severe error occurred on the current command.  The results, if any, should be discarded.

In this video below we going to provide us some insights about it:


  • Why this issue happens?
    • This error may be caused by a multiple reasons.
    • Normally, when you are running a transaction and the connection with the database is lost.
    • Database cause that any open transaction to be rolled back.


  • How to find?
    • Application Error messages


  • How to Fix?
    • Check performance on DB server
    • Implement the retry-logic at command execution.
    • Review other aspects of your server.



Leave a Reply

Your email address will not be published. Required fields are marked *


This site uses Akismet to reduce spam. Learn how your comment data is processed.