|
Home > Archive > IIS Server > June 2005 > asp.net errors in iis log
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
asp.net errors in iis log
|
|
|
| I would like to write a program that finds all asp.net errors in iis logs?
what characteristics should i look for? (a line in the log that has the
error?)
what about sql errors?
Thanks in advance,
Aaron
| |
|
|
|
|
| Kristofer Gafvert [MVP] 2005-06-25, 5:50 pm |
| SQL Server does not write anything into the IIS log.
SQL Server logs either to the Application Log (Event Log), or its own log
located in Program Files\Microsoft SQL Server\Mssql\Log folder (by
default). The name of the file is ErrorLog.
--
Regards,
Kristofer Gafvert (IIS MVP)
www.gafvert.info - My Articles and help
www.ilopia.com
Aaron wrote:
> what's the difference between IIS log and Events log?
>
> Can I use this method to find ASP errors too?
>
> Note: I want to be able to categorize asp, asp.net and sql errors. Not
just all errors.
>
> Aaron
>
>
> "Juan T. Llibre" <nomailreplies@nowhere.com> wrote in message
news:OVdXsVYeFHA.2180@TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
http://www.microsoft.com/technet/sc...er/default.mspx[vbcol=seagreen]
you > want.[vbcol=seagreen]
> for.
news:OXJ4lLVeFHA.2244@TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
logs? >>what characteristics should i look for? (a line in the log that
has the >>error?)[vbcol=seagreen]
| |
| Juan T. Llibre 2005-06-25, 5:50 pm |
| re:
> what's the difference between IIS log and Events log?
IIS has its own set of logs, in the directory %windir%\system32\LogFiles.
There, you'll find logs for HttpErr, Shutdown, SMTP services
( if you're running an SMTP service ) and W3C Services ( web logs ).
The Event Logs are stored at %windir%\System32\Config
As Kristofer already posted, SQL Server logs either to the
Application Log (Event Log), or its own log located in
Program Files\Microsoft SQL Server\Mssql\Log folder
(by default). The name of the file is ErrorLog.
Log Parser can read any of those files, and parse and create reports from them.
Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Espaņol
Ven, y hablemos de ASP.NET...
======================
"Aaron" <kuya789@yahoo.com> wrote in message news:uhGuduZeFHA.3932@TK2MSFTNGP12.phx.gbl...
> what's the difference between IIS log and Events log?
>
> Can I use this method to find ASP errors too?
>
> Note: I want to be able to categorize asp, asp.net and sql errors. Not just all errors.
>
> Aaron
>
>
> "Juan T. Llibre" <nomailreplies@nowhere.com> wrote in message
> news:OVdXsVYeFHA.2180@TK2MSFTNGP12.phx.gbl...
>
>
| |
| Bernard Cheah [MVP] 2005-06-26, 2:48 am |
| I'm not sure about asp.net as it has its own error handling routine and only
log status code and minor info in IIS.
Unlike ASP engine, which it logs more info in the IIS log file. I wrote this
chapter in the Log Parser 2.2 book.
Chap2 - Monitoring IIS
http://www.iis-resources.com/downloads/LPChap2.zip
from:
----
Under normal circumstances, these type of errors are often caused by coding
error in the server-side query, for example, |12|800a0009|
Subquery_out_of_range:_'arrayA(...)'. This error indicates that the arrayA
defined in in a server-side query is out of range. The format normally
starts with a pipe character followed by a line number, another pipe
separator, the error code, and finally one last pipe separator with an ASP
error message.
----
and here's the query for parsing ASP 500 related error.
---Ch02AspErrors.sql---
SELECT
Uri, Errorcode, ErrorMsg, LineNo, Total
USING STRCAT(cs-uri-stem, REPLACE_IF_NOT_NULL(cs-uri-query, STRCAT('?',
cs-uri-query))) AS QryStr,
TO_LOWERCASE(EXTRACT_TOKEN(QryStr, 0, '|')) AS Uri,
EXTRACT_TOKEN(cs-uri-query, 2, '|') AS ErrorCode,
EXTRACT_TOKEN(cs-uri-query, -1, '|') AS ErrorMsg,
EXTRACT_TOKEN(cs-uri-query, 1, '|') AS LineNo,
COUNT(*) AS Total
FROM %source%
WHERE
(cs-uri-stem LIKE '%.asp')
AND
(sc-status = 500)
GROUP BY Uri, ErrorCode, ErrorMsg, LineNo
ORDER BY Total DESC
---Ch02AspErrors.sql---
--
Regards,
Bernard Cheah
http://www.microsoft.com/iis/
http://www.iiswebcastseries.com/
http://www.msmvps.com/bernard/
"Juan T. Llibre" <nomailreplies@nowhere.com> wrote in message
news:OVdXsVYeFHA.2180@TK2MSFTNGP12.phx.gbl...
> Check out Log Parser 2.2
> http://www.microsoft.com/technet/sc...er/default.mspx
>
> A little tweaking of the sample scripts provided should get you what you
> want.
>
> A sample for a console application is at:
> http://samples.gotdotnet.com/quicks...oc/LogInfo.aspx
>
> Samples for ASP.NET applications are at :
> http://www.aspheute.com/english/20000811.asp
> and
> http://www.rassoc.com/gregr/weblog/...e.aspx?post=570
>
> It shouldn't be too difficult to tweak them to get what you're looking
> for.
>
>
>
> Juan T. Llibre
> ASP.NET MVP
> http://asp.net.do/foros/
> Foros de ASP.NET en Espaņol
> Ven, y hablemos de ASP.NET...
> ======================
>
> "Aaron" <kuya789@yahoo.com> wrote in message
> news:OXJ4lLVeFHA.2244@TK2MSFTNGP15.phx.gbl...
>
>
| |
| Juan T. Llibre 2005-06-26, 7:48 am |
| Thanks for sharing this material, Bernard!
Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Espaņol
Ven, y hablemos de ASP.NET...
======================
"Bernard Cheah [MVP]" <qbernard@hotmail.com.discuss> wrote in message
news:eZLGbsheFHA.3808@TK2MSFTNGP14.phx.gbl...
> I'm not sure about asp.net as it has its own error handling routine and only log status
> code and minor info in IIS.
> Unlike ASP engine, which it logs more info in the IIS log file. I wrote this chapter in
> the Log Parser 2.2 book.
> Chap2 - Monitoring IIS
> http://www.iis-resources.com/downloads/LPChap2.zip
>
> from:
> ----
> Under normal circumstances, these type of errors are often caused by coding error in the
> server-side query, for example, |12|800a0009| Subquery_out_of_range:_'arrayA(...)'. This
> error indicates that the arrayA defined in in a server-side query is out of range. The
> format normally starts with a pipe character followed by a line number, another pipe
> separator, the error code, and finally one last pipe separator with an ASP error
> message.
>
> ----
>
> and here's the query for parsing ASP 500 related error.
> ---Ch02AspErrors.sql---
>
> SELECT
>
> Uri, Errorcode, ErrorMsg, LineNo, Total
>
> USING STRCAT(cs-uri-stem, REPLACE_IF_NOT_NULL(cs-uri-query, STRCAT('?',
> cs-uri-query))) AS QryStr,
>
> TO_LOWERCASE(EXTRACT_TOKEN(QryStr, 0, '|')) AS Uri,
>
> EXTRACT_TOKEN(cs-uri-query, 2, '|') AS ErrorCode,
>
> EXTRACT_TOKEN(cs-uri-query, -1, '|') AS ErrorMsg,
>
> EXTRACT_TOKEN(cs-uri-query, 1, '|') AS LineNo,
>
> COUNT(*) AS Total
>
> FROM %source%
>
> WHERE
>
> (cs-uri-stem LIKE '%.asp')
>
> AND
>
> (sc-status = 500)
>
> GROUP BY Uri, ErrorCode, ErrorMsg, LineNo
>
> ORDER BY Total DESC
>
> ---Ch02AspErrors.sql---
>
>
>
>
> --
> Regards,
> Bernard Cheah
> http://www.microsoft.com/iis/
> http://www.iiswebcastseries.com/
> http://www.msmvps.com/bernard/
> "Juan T. Llibre" <nomailreplies@nowhere.com> wrote in message
> news:OVdXsVYeFHA.2180@TK2MSFTNGP12.phx.gbl...
>
>
|
|
|
|
|