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.