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

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.