SQL Exception breaks IIS request pipeline

Question

I have MVC3 app that is making IIS go crazy. And me too.

If SQLException happens (ie stored procedure is missing) request pipeline breaks, user sees "Sorry, an error occurred while processing your request", nothing is logged in event viewer. Request tracing gives absolutely no useful info but you can take a look here. Interesting part is on line 6448 where error code is "The operation completed successfully".

Now here is the fun part:

• my machine win7 64bit - works as expected, YSOD is shown
• one of my hosting machines win2008 web server 32bit - works as expected, YSOD is shown
• client's hosting machine win2008 R2 server core 64 bit - pipeline breaks as described above
• (for testing purposes) client's hosting machine win2008 web server 64 bit - pipeline breaks as described above

UPDATE: this problem is not limited to SQLException. ANY Exception ie throw new Exception("Bla") will break pipeline as described above.

Answer 1

I think that is because you probably have the attribute [HandleError] somewhere in your controllers.This attribute always catches uncaught exceptions and displays the default Error.cshtm view which can be found in your shared folder.

For more info see this related answer.

Regards.