 |
|
8000XXXX Errors Alerts ASP.NET 2.0
Classic ASP 1.0 COM / ActiveX Components Forms General Topics Date/Time Routines Email Scripts & Info Files/Directories & FSO Databases General Concepts Search Engine Optimization (SEO)Search
ASP FAQ Tutorials :: Classic ASP 1.0 :: General Topics :: How do I log / track ASP errors on my web site?
How do I log / track ASP errors on my web site?
In IIS 5.0 and above, there is a new object called the ASPError object, which allows you to have more control over how your errors appear to users, and how you can track these errors and prevent them from occuring in the future. This article will quickly guide you through creating a tiny application that will track 500 errors and allow you to review them at the end of the day. The article assumes you are using SQL Server as your database backend, but could be modified easily to work with Access or any other database platform.
Before we start, let's force a pretty simple 500 error (save it as <wwwroot>\force500error.asp) with the following code:
This should result in the following error:
Now, let's create a simple example of a 500 error handler page. First, create the following ASP page:
Save this file in <wwwroot>\500_try.asp (the default file in IIS for handling custom 500 errors is called 500-100.asp - we should leave this file alone, in case we need to restore the default behavior at some point). Now, go into Internet Services Manager, right-click the Default Web Site (or any web site or application where you want to isolate this test), choose properties, on the Custom Errors tab, scroll down to 500;100 and hit Edit, verify that Message Type has "URL" selected, and make sure the URL points to /500_try.asp (or wherever you placed it).
Once you've done this, you should get a prettier error when you hit force500error.asp:
That's just for starters. You can customize the 500 handler page later by adding your web site graphics, navigation, and even other content. Keep in mind that, like the custom 404 error page described in Article #2162, path is important when defining the images and other references in your 500 handler page. If this page is expected to handle errors in ASP pages in the root of your site / application as well as sub-folders, all possible locations need to be aware of the exact path to any referenced files.
All right, so let's create a table that will store the information we might want to track. In addition to the extra information provided by the ASPError object that is not available with the traditional ON ERROR RESUME NEXT architecture, it might also be useful to store referrer, user agent, ip and post data as well. So our table will look like this (and since we are going to query by date after the fact, we put a clustered index on the datetime column):
And the following stored procedure will facilitate inserting data into this table when an error occurs:
So now that we have a table to store our data, and a stored procedure to interface with it, let's create the following ASP page to replace 500_try.asp from above:
This ASP page will store all the relevant data. You can test it by hitting force500error.asp again, and then using Query Analyzer to run a quick SELECT * query:
You should see the results of any 500 errors that have occured since you set up the table and new 500 ASP page.
Now here is a stored procedure that will return all of the 500 errors that occurred during the current day (you can modify this to go back to the beginning of the week, or the beginning of the month if you like):
And here is a crude ASP page to review the results:
I'll leave the extended details page as an exercise for the reader.
Note that Server.GetLastError and the ASPError object are *only* available in the custom 500 error handler. In your normal ASP pages, they will not work as illustrated above. For more information, see the ASPError Object and Server.GetLastError topics in MSDN's Online Library.
Before we start, let's force a pretty simple 500 error (save it as <wwwroot>\force500error.asp) with the following code:
| <% functionThatDoesNotExist() %> |
This should result in the following error:
| Microsoft VBScript runtime error '800a000d' Type mismatch: 'functionThatDoesNotExist' /force500error.asp, line 2 |
Now, let's create a simple example of a 500 error handler page. First, create the following ASP page:
| <% Set ASPErr = Server.GetLastError Response.Write ASPErr.Description %> |
Save this file in <wwwroot>\500_try.asp (the default file in IIS for handling custom 500 errors is called 500-100.asp - we should leave this file alone, in case we need to restore the default behavior at some point). Now, go into Internet Services Manager, right-click the Default Web Site (or any web site or application where you want to isolate this test), choose properties, on the Custom Errors tab, scroll down to 500;100 and hit Edit, verify that Message Type has "URL" selected, and make sure the URL points to /500_try.asp (or wherever you placed it).
Once you've done this, you should get a prettier error when you hit force500error.asp:
| Type mismatch: 'functionThatDoesNotExist' |
That's just for starters. You can customize the 500 handler page later by adding your web site graphics, navigation, and even other content. Keep in mind that, like the custom 404 error page described in Article #2162, path is important when defining the images and other references in your 500 handler page. If this page is expected to handle errors in ASP pages in the root of your site / application as well as sub-folders, all possible locations need to be aware of the exact path to any referenced files.
All right, so let's create a table that will store the information we might want to track. In addition to the extra information provided by the ASPError object that is not available with the traditional ON ERROR RESUME NEXT architecture, it might also be useful to store referrer, user agent, ip and post data as well. So our table will look like this (and since we are going to query by date after the fact, we put a clustered index on the datetime column):
| CREATE TABLE HTTP500Errors ( id INT IDENTITY(1,1) PRIMARY KEY NONCLUSTERED, dt DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, url VARCHAR(1024) NOT NULL DEFAULT '', aspDesc VARCHAR(512) NOT NULL DEFAULT '', aspNumber VARCHAR(16) NOT NULL DEFAULT '', aspLine INT NOT NULL DEFAULT 0, aspColumn INT NOT NULL DEFAULT 0, errDesc VARCHAR(512) NOT NULL DEFAULT '', errNumber VARCHAR(16) NOT NULL DEFAULT '', ref VARCHAR(1024) NOT NULL DEFAULT '', ip VARCHAR(15) NOT NULL DEFAULT '', ua VARCHAR(1024) NOT NULL DEFAULT '', method VARCHAR(4) NOT NULL DEFAULT 'GET', data TEXT NOT NULL DEFAULT '' ); GO CREATE CLUSTERED INDEX ci_HTTP500Errors_dt ON HTTP500Errors(dt); GO -- replace ??? with the user you connect to from ASP GRANT DELETE, INSERT, SELECT, UPDATE ON HTTP500Errors TO [???] GO |
And the following stored procedure will facilitate inserting data into this table when an error occurs:
| CREATE PROCEDURE dbo.logHTTP500Errors @url VARCHAR(1024)='', @aspDesc VARCHAR(512)='', @aspNumber VARCHAR(16)='', @aspLine INT=0, @aspColumn INT=0, @errDesc VARCHAR(512)='', @errNumber VARCHAR(16)='', @ref VARCHAR(1024)='', @ip VARCHAR(15)='', @ua VARCHAR(1024)='', @method VARCHAR(4)='GET', @data TEXT='' AS BEGIN SET NOCOUNT ON; INSERT HTTP500Errors ( url, aspDesc, aspNumber, aspLine, aspColumn, errDesc, errNumber, ref, ip, ua, method, data ) SELECT @url, @aspDesc, @aspNumber, @aspLine, @aspColumn, @errDesc, @errNumber, @ref, @ip, @ua, @method, @data; END GO -- replace ??? with the user you connect to from ASP GRANT EXEC ON logHTTP500Errors TO [???] GO |
So now that we have a table to store our data, and a stored procedure to interface with it, let's create the following ASP page to replace 500_try.asp from above:
| <% Response.Status = "500 Internal Server Error" Set ASPErr = Server.GetLastError() ' build the URL string strURLPrefix = "http://" if Request.ServerVariables("HTTPS") <> "off" then strURLPrefix = "https://" strPageName = Request.ServerVariables("SCRIPT_NAME") strServerName = Request.ServerVariables("SERVER_NAME") strURL = strURLPrefix & strServerName & strPageName ' get the extended error information strASPDesc = ASPErr.ASPDescription strASPNumber = ASPErr.ASPCode intASPLine = clng(ASPErr.Line) intASPColumn = clng(ASPErr.Column) strDesc = ASPErr.Description strNumber = "0x" & Hex(ASPErr.Number) ' and some extra info, such as user agent strRef = Request.ServerVariables("HTTP_REFERER") strIP = Request.ServerVariables("REMOTE_ADDR") strUA = Request.ServerVariables("HTTP_USER_AGENT") strMethod = Request.ServerVariables("REQUEST_METHOD") strData = Request.QueryString() if strMethod = "POST" then strData = Request.Form() ' let's build our SQL string: sql = "EXEC dbo.logHTTP500Errors " & _ " @url='" & fixSQL(strURL, 1024) & "'," & _ " @aspDesc='" & fixSQL(strASPDesc, 512) & "'," & _ " @aspNumber='" & fixSQL(strASPNumber, 16) & "'," & _ " @aspLine=" & intASPLine & "," & _ " @aspColumn=" & intASPColumn & "," & _ " @errDesc='" & fixSQL(strDesc, 512) & "'," & _ " @errNumber='" & fixSQL(strNumber, 16) & "'," & _ " @ref='" & fixSQL(strRef, 1024) & "'," & _ " @ip='" & fixSQL(strIP, 16) & "'," & _ " @ua='" & fixSQL(strUA, 1024) & "'," & _ " @method='" & fixSQL(strMethod, 4) & "'," & _ " @data='" & fixSQL(strData, len(strData)) & "'" set conn = CreateObject("ADODB.Connection") ' don't forget to update your connection string! conn.open "<connection string>" conn.execute(sql) conn.close set conn = nothing ' a little function to trim the data in case some of it ' exceeds bounds, and replace those pesky apostrophes function fixSQL(str, intLength) fixSQL = left(replace(str,"'","''"), intLength) end function ' tell the user something (you can enter your ' site's graphics and navigation etc. here) Response.Write "There was an error on this page. The server " & _ " administrator has been notified and will investigate." %> |
This ASP page will store all the relevant data. You can test it by hitting force500error.asp again, and then using Query Analyzer to run a quick SELECT * query:
| SELECT * FROM HTTP500Errors |
You should see the results of any 500 errors that have occured since you set up the table and new 500 ASP page.
Now here is a stored procedure that will return all of the 500 errors that occurred during the current day (you can modify this to go back to the beginning of the week, or the beginning of the month if you like):
| CREATE PROCEDURE dbo.retrieveHTTP500ErrorsToday AS BEGIN SET NOCOUNT ON; DECLARE @dt DATETIME; SET @dt = CONVERT(DATETIME, CONVERT(CHAR(10), GETDATE(), 101)); SELECT id, dt, url, aspDesc, aspNumber, aspLine, aspColumn, errDesc, errNumber, ref, ip, ua, method, data FROM HTTP500Errors WHERE dt >= @dt ORDER BY dt; END GO -- replace ??? with the user you connect to from ASP GRANT EXEC ON dbo.retrieveHTTP500ErrorsToday TO [???] GO |
And here is a crude ASP page to review the results:
| <% set conn = CreateObject("ADODB.Connection") conn.open "<connection string>" set rs = conn.execute("EXEC dbo.retrieveHTTP500ErrorsToday") if not rs.eof then do while not rs.eof response.write "<hr size=1>" response.write rs("errNumber") & ": " & rs("errDesc") & "<br>" response.write rs("url") & "<br>" response.write rs("dt") response.write " (link to details record here...)" rs.movenext loop response.write "<hr size=1>" else response.write "No 500 errors today." end if conn.close set conn = nothing %> |
I'll leave the extended details page as an exercise for the reader.
Note that Server.GetLastError and the ASPError object are *only* available in the custom 500 error handler. In your normal ASP pages, they will not work as illustrated above. For more information, see the ASPError Object and Server.GetLastError topics in MSDN's Online Library.
Related Articles
Can I bypass the ten connection limitation in Workstation / Professional? Can I compact / repair an Access database from ASP code? Can I create an array's size dynamically? Can I detect the presence of ActiveX controls, like Flash, from ASP? Can I dictate the load order of files on the client from ASP? Can I have optional parameters to my subs / functions? Can I host multiple sites in 2000 Workstation or XP Professional (e.g. PWS)? Can I mimic trim / ltrim / rtrim in JScript? Can I perform simple encryption / decryption in ASP? Can I run IIS 5.0 / ASP 3.0 on Windows NT 4.0 or Windows 9x? Can I run IIS on Windows Millennium or Windows XP Home? Can I use IP address to uniquely identify visitors? Does order matter when using different languages in ASP? How can I give them a better 404 message? How can I stop Photoshop from opening ASP files? How can I track when my site is added to a user's favorites? How do I access all active sessions on the server? How do I access my server's registry from an ASP page? How do I change a list into a set of table rows and columns? How do I change document names / extensions in IIS / PWS? How do I change the default server scripting language in InterDev? How do I cloak / hide URL and QueryString information? How do I comment blocks of ASP code? How do I control access to an area? How do I control printing from ASP? How do I convert a name to proper case? How do I convert exchange rates in ASP? How do I convert from Hex to Int and back? How do I convert numbers into words? How do I convert old IDC / HTX pages to ASP? How do I count the number of current users / sessions? How do I count the number of times x occurs in string y? How do I create a database from ASP? How do I create my own blog? How do I deal with disappearing application variables? How do I decode an encoded URL? How do I detect ENABLED cookies / javascript? How do I detect the browser's encryption level / cipher strength? How do I determine which version of IIS / ASP I'm running? How do I disable the back/forward buttons? How do I display the Euro symbol (€) in my ASP pages? How do I embed a TAB character into source code? How do I embed apostrophes (') and quotes (") in an HTML string? How do I embed ASP delimiters (<% or %>) in a string? How do I estimate the total size of my web page? How do I execute a DOS command / batch file / exe from ASP? How do I execute a ping command from ASP, and retrieve the results? How do I find out the amount of space left on my server? How do I fix the ::$DATA bug? How do I FTP files from ASP? How do I generate a treeview from ASP? How do I generate unique GUIDs from ASP? How do I get all the UBound() values in a multi-dimensional array? How do I get IntelliSense to see ASP 3.0 methods? How do I get my visitors' login name / username? How do I get screen resolution from ASP? How do I get the computer name / IP address of the server? How do I get the server's timezone information? How do I get the user's IP address or browser information? How do I highlight words in a string? How do I host multiple web sites on one IIS box? How do I increase timeout values? How do I iterate through session variables? How do I know which version of VBScript my server is running? How do I make hyperlinks out of plain text URLs and e-mail addresses? How do I make JavaScript send values to ASP? How do I make my ASP page pause or 'sleep'? How do I make my ASP page refresh? How do I make my ASP pages more efficient? How do I make search engines index pages with QueryStrings? How do I make sure an entered string contains only valid characters? How do I make sure my ASP question gets answered? How do I make sure my servers have the same time? How do I make sure people go to page x before page y? How do I make sure the client is still connected before processing? How do I make Visual InterDev's debugging features work? How do I manage a session across multiple windows? How do I pad digits with leading zeros? How do I parse / analyze IIS Logs? How do I parse the domain name out of a URL? How do I parse the file name out of a path or URL? How do I perform a Whois / DNS lookup from ASP? How do I persist session state without cookies / session variables? How do I prevent 'Invalid use of Null' errors? How do I prevent my ASP pages from caching? How do I prevent people from printing my ASP page? How do I print the first n characters of a large block of text? How do I prompt a "Save As" dialog for an accepted mime type? How do I protect my ASP code? How do I protect my client-side JavaScript code? How do I protect my images and other visual content? How do I put my ASP application onto a CD-Rom? How do I read the contents of a remote web page? How do I read the event log from ASP? How do I redirect an http:// request to https://? How do I refresh global.asa without restarting the application? How do I round a number *properly* with VBScript? How do I run ASP on other web servers besides IIS? How do I schedule ASP files? How do I send a MsgBox or InputBox from ASP? How do I set session variables from client-side script? How do I show a "Please Wait..." message? How do I solve 'Event ID 5' errors? How do I solve 'The Requested Resource is in Use' errors? How do I solve 'The server failed to load the application' errors? How do I solve 'The specified procedure could not be found' errors? How do I solve ASP 0115 errors? How do I specify ByRef / ByVal in VBScript? How do I stress test my ASP application? How do I time my ASP code? How do I turn a KB Article #, like Q191987, into a usable URL? How do I use ASP to [...] How do I use extensions other than .ASP for ASP files? How do I warn people when their session is about to expire? How do I zip / unzip files from ASP? I called Session.Abandon, why are my session variables still there? I have plenty of RAM, why do I get an 'Out of memory' error? Is there an easier way to patch my server(s)? Should I use ADOVBS.inc for declaring constants? Should I use sessionID to uniquely identify users? Should I use the .inc extension for my include files? Should I use VBScript or JScript for ASP? What do I do when IIS 5.0 will not start? What do I need to know about Response.Redirect? What is Event ID 36, and how can I get IIS running again? What is this 'Cannot detect OS type' error with NT 4.0 Option Pack? What is this error 'An unhandled data type was encountered'? What is wrong with IsNumeric()? What is wrong with Request.ServerVariables("HTTP_REFERER")? What is wrong with Session_OnEnd()? What kind of object is Response.Crackers? What's the deal with IIS 5.0 and ASP 3.0? When I run a page in my browser, why does the ASP code not execute? Where can I find out about .NET? Where can I find out about running Perl in IIS? Where can I host ASP pages for free (or at least cheap)? Where do I get IIS / ASP? Where else can I learn about ASP? Which editor should I use for developing ASP applications? Which is better, rs(0) or rs("column_name")? Why am I getting 'subscript out of range' errors? Why am I having problems installing Visual Studio.NET RTM? Why am I having problems with Server.Execute and/or Server.Transfer? Why are people telling me to fix my clock / timezone? Why can't I browse localhost without an Internet connection? Why can't I grab custom headers from Request.ServerVariables()? Why can't I pass querystring information AND links to #bookmarks? Why can't I turn buffering off using Response.Buffer? Why can't I use #EXEC or #ECHO in an ASP page? Why do I get 'BOF or EOF' errors? Why do I get 'HTTP 500-12 Application Restarting' errors? Why do I get 'HTTP/1.0 Invalid Application Name' errors? Why do I get 'Invalid Default Script Language' errors? Why do I get 'Name redefined' errors? Why do I get 'Object doesn't support this property or method' errors? Why do I get 'The RPC Server is Unavailable' messages? Why do I get 'Type Mismatch' when using the Session object? Why do I get 8000FFFF / 8002802B errors? Why do I get 80010105 errors? Why do I get 80010108 errors? Why do I get 80020003 errors? Why do I get 80020005 errors? Why do I get 80020009 errors? Why do I get 8002000E errors? Why do I get 80029c84 errors? Why do I get 8004E00F errors? Why do I get 80070034 / 80070035 errors? Why do I get 80070056 errors? Why do I get 80070057 errors? Why do I get 80090016 errors? Why do I get 800A01C2 errors? Why do I get 800A01C9 errors? Why do I get 800A01CA errors? Why do I get 800A01F4 errors? Why do I get 800A01F9 errors? Why do I get 800A03EC errors? Why do I get 800A03ED / 800A03EE errors? Why do I get 800A03F6 errors? Why do I get 800A0401 errors? Why do I get 800A0408 errors? Why do I get 800A0414 errors? Why do I get 800A138F errors? Why do I get a 500 Internal Server error for all ASP errors? Why do I get an 'overflow' error using CInt? Why do I get an error about a 'Smart HTML interpreter'? Why do I get ASP 0101 errors? Why do I get ASP 0113 / Script timed out errors? Why do I get ASP 0130 / ASP 0131 errors? Why do I get ASP 0138 errors? Why do I get ASP 0158 errors? Why do I get errors in the 800A0001 -> 800A000F range? Why do I get errors in the 800A0030 -> 800A003A range? Why do I get errors in the 800A03F1 -> 800A03FF range? Why do I get errors in the 800A0400 -> 800A041F range? Why do I get errors when trying to redirect? Why do I get HTTP/1.1 400 Bad Request errors? Why do I get non-database-related 80004005 errors? Why do I get script errors on one machine but not another? Why do I get the error Object Required: ''? Why do my session / application variables disappear? Why does 3.2 + 1.5 = 4.7000000000000002? Why does 4 / 5 = 0? Why does global.asa not fire? Why does GUID not work correctly with response.write? Why does IIS hang and/or stop serving ASP pages? Why does my page render (properly) in IE and not in Netscape? Why does RecordCount return as -1? Why does REMOTE_HOST return an IP address instead of a name address? Why does session.abandon not take effect right away? Why is Netscape slow in IIS 5.0? Why won't my ASP pages work in IIS 6.0? Why won't my session variables stick? Why won't QueryString values work with Server.Execute / Server.Transfer? Why won't Windows search ASP files? DllHost.Exe