500 - Internal server error

[iq11]

Hello everyone,

 We are getting an error As shown below on our Dev server

Error Occurred While Processing Request. Please try again.
Error Executing Database Query. [Macromedia][Oracle JDBC Driver]A username and password are required if the connection option 'authenticationMethod' is specified with a value of 'userIDPassword'.
The error occurred on line 28.

Whereas on our Prod server we are getting an error message as shown below

500 - Internal server error.

There is a problem with the resource you are looking for, and it cannot be displayed.

We would like the error message to be the same as that displayed on Dev server on our Prod server also. I have looked at the authentication.cfm file but could not see anything which can help me.

We think this is due to an incorrect setting in the Cold Fusion Administrator , Can someone help us with this issue ?

[iq11]

Hi there,

   Please update me if there is any solution to this issue.

[Charlie Arehart]

You want production to report the same level of detail about the errors as in dev? This may be a case of "be careful what you wish for".

Yes, this IS something controlled by a setting in the admin, in that the debug output settings page has an option for "robust exception handling", which should be OFF in a production config (don't show as much detail) and is often turned ON in a development config (to show MORE detail).

But really, one need NOT rely on THAT display of error details, in dev or prod. Instead one could implement error handling in their code, to have the error details tracked in a log, db, email, etc while the user sees a generic message saying  that the error has been handled and appropriate people notified. The cf docs (and many blog posts and presentations) detail how to setup error handling. Someone familiar with the concept could have something in place in minutes.

Let us know if you need more help, and whether this has helped.