Walter,
Thanks for your response.
I am developing a web service which I am using locally on IE browser to test
(
http://localhost/..). Problem only occuring on my new PC and I only get the
HTTP 500 page when an exception is thrown from the web service. Otherwise I
see the correct result. On this PC (new PC), when I do clear the check box
'Show Friendly HTTP error messages', I do no longer get the HTTP 500 page -
but instead get a page with the exception & inner exception messages. This is
good, but I am still expecting to see the entire exception details including
the exception names and stack traces like I do on my old PC. Furthermore, on
my old PC, regardless of whether 'Show Friendly HTTP error messages' is
checked or unchecked, I do see ALL exception details.I want my new PC to
behave similarly where it gives me the ENTIRE exception details (including
exception names and stack traces).
Here is what I see in IE browser when running locally (
http://localhost/..).
on my NEW (problem) PC:
**** Begin screen shot ***
Exception encountered in dr_DB2Process.SetCommit --ERROR [08007] [IBM][CLI
Driver][DB2] SQL30073N "0x2113" Parameter value "0x0000" is not
supported. SQLSTATE=58017
**** End screen shot ***
Here is what I see in IE browser when running locally (
http://localhost/..).
on my OLD (good) PC:
(note - Old PC has the same code and same web.config being used as NEW PC -
code is from clear case repository)
**** Begin screen shot ***
VOSE.Common.Util.VOSEBaseApplicationException: Exception encountered in
dr_DB2Process.SetCommit ---IBM.Data.DB2.Db2Exception: ERROR [08007]
[IBM][CLI Driver][DB2] SQL30073N "0x2113" Parameter value "0x0000" is not
supported. SQLSTATE=58017
at IBM.Data.DB2.DB2Connection.HandleError(IntPtr hHandle, SQL_Handle hType,
RETCODE retcode)
at IBM.Data.DB2.DB2Command.ExecuteReaderObject(Comman dBehavior behavior,
String method)
at IBM.Data.DB2.DB2Command.ExecuteNonQuery()
at VOSE.Data.DataRequest.dr_DB2Process.SetCommit(DB2C onnection conn) in
C:\VIEWS\TReynolds_SeptOldPC\VOSE1\Data\VOSE.Data. DataRequest\DB2Request\dr_DB2Process.cs:line 6105
--- End of inner exception stack trace ---
at VOSE.Data.DataRequest.dr_DB2Process.SetCommit(DB2C onnection conn) in
C:\VIEWS\TReynolds_SeptOldPC\VOSE1\Data\VOSE.Data. DataRequest\DB2Request\dr_DB2Process.cs:line 6116
at VOSE.Data.DataRequest.dr_DB2Process.DeleteCommRows (String company, String
orderumber, String AttentionCode, String MatchingText, String ActionCode) in
C:\VIEWS\TReynolds_SeptOldPC\VOSE1\Data\VOSE.Data. DataRequest\DB2Request\dr_DB2Process.cs:line 9259
at
VOSE.Business.OrderManagement.OMBuildIVAPPNotifica tion.GetAddOrderMessage(tQueue
objQueue, tOrderManagementIndicator omindicator, Int32 intTriggerId) in
C:\VIEWS\TReynolds_SeptOldPC\VOSE1\Business\VOSE.B usiness.OrderManagement\OMBuildIVAPPNotification.c s:line 1045
at
VOSE.Business.OrderManagement.OMBuildIVAPPNotifica tion.GetAddOrderMessage(tQueue
objQueue, tOrderManagementIndicator omindicator) in
C:\VIEWS\TReynolds_SeptOldPC\VOSE1\Business\VOSE.B usiness.OrderManagement\OMBuildIVAPPNotification.c s:line 561
at VOSE.WebServices.WebServices.GetAddOrderXMLNoQueue Object(String
strCompany, Int32 intOrderNo, String strOrderType, Int32 intVersino) in
C:\VIEWS\TReynolds_SeptOldPC\VOSE1\WebServices\VOS E.WebServices\WebServices.asmx.cs:line 6258
**** End screen shot ***
Please note all the additional info being shown by IE here.
The only thing in my application log is a log written by the application
logging the exception before it throws it. In includes all the exception
details put in a particular format along with an error message number and
name. This would be similar between new & old PC other than actual file
names in the stack trace. This is one I copied from my new PC and I have no
issues with it- only issue is with IE browser.
*** From event viewer ***
<Log Message="0004 DB2 System Error or Exception ; Additional
Info: Exception Type: VOSE.Common.Util.VOSEBaseApplicationException
;Exception Message: Exception encountered in dr_DB2Process.SetCommit
;Exception Stack Trace: at
VOSE.Data.DataRequest.dr_DB2Process.SetCommit(DB2C onnection conn) in C:\My
Documents\VOSE\VIEWS\TReynolds_September06view\VOS E1\Data\VOSE.Data.DataRequest\DB2Request\dr_DB2Pro cess.cs:line 6116
at VOSE.Data.DataRequest.dr_DB2Process.DeleteCommRows (String company,
String orderNumber, String AttentionCode, String MatchingText, String
ActionCode) in C:\My
Documents\VOSE\VIEWS\TReynolds_September06view\VOS E1\Data\VOSE.Data.DataRequest\DB2Request\dr_DB2Pro cess.cs:line 9259
at
VOSE.Business.OrderManagement.OMBuildIVAPPNotifica tion.GetAddOrderMessage(tQueue
objQueue, tOrderManagementIndicator omIndicator, Int32 intTriggerId) in C:\My
Documents\VOSE\VIEWS\TReynolds_September06view\VOS E1\Business\VOSE.Business.OrderManagement\OMBuildI VAPPNotification.cs:line 1056
at
VOSE.Business.OrderManagement.OMBuildIVAPPNotifica tion.GetAddOrderMessage(tQueue
objQueue, tOrderManagementIndicator omIndicator) in C:\My
Documents\VOSE\VIEWS\TReynolds_September06view\VOS E1\Business\VOSE.Business.OrderManagement\OMBuildI VAPPNotification.cs:line 561
at VOSE.WebServices.WebServices.GetAddOrderXMLNoQueue Object(String
strCompany, Int32 intOrderNo, String strOrderType, Int32 intVersion) in C:\My
Documents\VOSE\VIEWS\TReynolds_September06view\VOS E1\WebServices\VOSE.WebServices\WebServices.asmx.c s:line
6248 ;Inner Exception Type: IBM.Data.DB2.DB2Exception ;Inner Exception
Message: ERROR [08007] [IBM][CLI Driver][DB2] SQL30073N "0x2113" Parameter
value "0x0000" is not supported. SQLSTATE=58017
;Inner Exception Stack Trace at
IBM.Data.DB2.DB2Connection.HandleError(IntPtr hHandle, SQL_HANDLE hType,
RETCODE retcode)
at IBM.Data.DB2.DB2Command.ExecuteReaderObject(Comman dBehavior behavior,
String method)
at IBM.Data.DB2.DB2Command.ExecuteNonQuery()
at VOSE.Data.DataRequest.dr_DB2Process.SetCommit(DB2C onnection conn) in
C:\My
Documents\VOSE\VIEWS\TReynolds_September06view\VOS E1\Data\VOSE.Data.DataRequest\DB2Request\dr_DB2Pro cess.cs:line
6105" Company="C" Severity="8" StackTrace=" at
VOSE.Common.Util.ut_Logging.PublishEvent(BaseEvent messageEvent,
CustomEventSource customEventSource) in c:\my
documents\vose\views\treynolds_september06view\vos e1\common\vose.common.util\logevents\ut_logging.cs : line 433
at VOSE.Common.Util.ut_Logging.PublishErrorEvent(Stri ng message,
CustomEventSource customEventSource, ErrorSeverity errorSeverity, String
company) in c:\my
documents\vose\views\treynolds_september06view\vos e1\common\vose.common.util\logevents\ut_logging.cs : line 277
at VOSE.Common.Util.ut_Logging.PublishErrorEvent(Int3 2 intMessageNo, String
messageDescription, ErrorSeverity errorSeverity, Int32 intOrderNo, String
strOrderTypeCodeQueue, Int32 intVersion, String additionalMessageText,
CustomEventSource eventSource, String company) in c:\my
documents\vose\views\treynolds_september06view\vos e1\common\vose.common.util\logevents\ut_logging.cs : line 358
at VOSE.Business.bu_Logging.PublishErrorEvent(String strCompany, Int32
intMessageNo, Int32 intOrderNo, String strOrderTypeCodeQueue, Int32
intVersion, String additionalMessageText, CustomEventSource eventSource) in
C:\My
Documents\VOSE\VIEWS\TReynolds_September06view\VOS E1\Business\VOSE.Business\bu_Logging.cs: line 117
at VOSE.Business.bu_Logging.LogException(VOSEBaseAppl icationException e,
CustomEventSource customEventSource, String strCompany) in C:\My
Documents\VOSE\VIEWS\TReynolds_September06view\VOS E1\Business\VOSE.Business\bu_Logging.cs: line 55
at VOSE.WebServices.WebServices.GetAddOrderXMLNoQueue Object(String
strCompany, Int32 intOrderNo, String strOrderType, Int32 intVersion) in C:\My
Documents\VOSE\VIEWS\TReynolds_September06view\VOS E1\WebServices\VOSE.WebServices\WebServices.asmx.c s: line 6258
at System.Reflection.RuntimeMethodInfo.InternalInvoke (Object obj,
BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo
culture, Boolean isBinderDefault, Assembly caller, Boolean verifyAccess)
at System.Reflection.RuntimeMethodInfo.InternalInvoke (Object obj,
BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo
culture, Boolean verifyAccess)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags
invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.Reflection.MethodInfo.Invoke(Object obj, Object[] parameters)
at System.Web.Services.Protocols.LogicalMethodInfo.In voke(Object target,
Object[] values)
at System.Web.Services.Protocols.WebServiceHandler.In voke()
at System.Web.Services.Protocols.WebServiceHandler.Co reProcessRequest()
at
System.Web.Services.Protocols.SyncSessionlessHandl er.ProcessRequest(HttpContext context)
at
System.Web.CallHandlerExecutionStep.System.Web.Htt pApplication+IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionS tep step, Boolean&
completedSynchronously)
at System.Web.HttpApplication.ResumeSteps(Exception error)
at
System.Web.HttpApplication.System.Web.IHttpAsyncHa ndler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
at System.Web.HttpRuntime.ProcessRequestInternal(Http WorkerRequest wr)
at System.Web.HttpRuntime.ProcessRequest(HttpWorkerRe quest wr)
at System.Web.Hosting.ISAPIRuntime.ProcessRequest(Int Ptr ecb, Int32
iWRType)" EventSourceName="VOSE Web Services Incoming"
MachineName="TREYNOLDS"></Log>
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Thanks for your assistance in resolving this...Please advise me if you need
any more info. I am guessing that some setting on my new PC is not allowing
the exception info to display but don't know why.
Thanks,
Tim
"Walter Wang [MSFT]" wrote:
Hi Tim,
After reviewing your post, I'm not sure whether you're developing a "web
service" or a "web site". If you're developing a "web service" using
ASP.NET, how are you testing it? If you're using IE to test the web
service, as far as I know, you can only test it from localhost except
you're using another web site to test the web service.
On your "new" pc, does it report HTTP 500 error on every page? or only
report when an expected exception is thrown?
The ¡°HTTP 500 internal server error¡± is the general error message. To get
more details information, please:
1. Open the menu Tools -- Internet Options in IE.
2. Click Advanced tab.
3. Clear the checkbox ¡°Show friendly HTTP error messages¡±.
4. Click OK to close the dialogbox.
5. Try to visit the page again.
6. Create a screen shot of the error message you received.
7. Send me the screen shot as well as the event logs on the server
(application and system).
Sincerely,
Walter Wang (wa****@online.microsoft.com, remove 'online.')
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.