Previous Next

• 07-31-2008, 4:42 PM

  tnbarkhouse Joined on 07-31-2008, 8:11 PM Posts 4

  Error report - Unhandled exception 0xC0000005: Access violation Reply Contact First, I want to say that Log Parser is an amazing tool.  I use it, to great effect, on a daily basis.  Thanks for all of the hard work! I am consistently encountering an unhandled access violation exception when trying to use Log Parser to process some IIS W3SVC log files.  Hopefully this information will help to find the source of the problem. The error message is: Unhandled exception at 0x01045448 in LogParser.exe: 0xC0000005: Access violation writing location 0x00000004. I am using Log Parser version 2.2.10.0.  The error occurs with the following command-line: LogParser -i:IISW3C -o:TSV file:"LPQ - Preprocess an IIS log file.sql"?SourceFile="ex080511.log" I have a Zip file with the "LPQ - Preprocess an IIS log file.sql" query file and a Minidump saved from Visual Studio 2005.  I can also provide a System Information file, if that would help.  Please tell me where to email these files or how to submit them for analysis. I wonder if the size of the log files might be a contributing factor.  The problem manifests on files that are between 400 and 900 megabytes in size. Thanks, Trevor

• 07-31-2008, 5:00 PM

  In reply to

  joelangley Joined on 07-20-2008, 2:37 PM Posts 82	Re: Error report - Unhandled exception 0xC0000005: Access violation Reply Contact can you post the query that you are running? I doubt the large file size is an issue as I parse files around that size and never had an issue (so far at least)

• 07-31-2008, 5:14 PM

  In reply to

  tnbarkhouse Joined on 07-31-2008, 8:11 PM Posts 4

  Re: Error report - Unhandled exception 0xC0000005: Access violation Reply Contact >   can you post the query that you are running? The "LPQ - Preprocess an IIS log file.sql" query file consists of the following: SELECT TOP 10 '%SourceFile%' AS [SourceFile],     [LogRow],     SUB(TO_TIMESTAMP([date], [time]), TIMESTAMP('5', 'h')) AS [local-date-time],     [c-ip],     [s-sitename],     [s-port],     [cs-method],     [cs-uri-stem],     [cs-uri-query],     [sc-status],     [sc-substatus],     [sc-win32-status],     [time-taken],     [cs(User-Agent)] INTO 'TrevTest20080731T1328.txt' FROM '%SourceFile%' ORDER BY [local-date-time],     [LogRow] Also, I scaled the query down as I was troubleshooting the problem (hence the TOP 10 argument and the INTO clause). >   I doubt the large file size is an issue as I parse files around that size and never had an issue (so far at least) I've been using the query to analyze the logs from two different web sites hosted on the same IIS 6.0 web server.  The unhandled exception occurs with log files from the Default Web Site, but the query works correctly with log files from the second web site.  The main difference between them is volume of data, but there are also different fields logged by each web site.

• 07-31-2008, 5:38 PM

  In reply to

  joelangley Joined on 07-20-2008, 2:37 PM Posts 82	Re: Error report - Unhandled exception 0xC0000005: Access violation Reply Contact Can you remove the INTO statement and instead send the output to a datagrid? -o:DATAGRID Just want to see if it is related to this at all.

• 07-31-2008, 7:04 PM

  In reply to

  tnbarkhouse Joined on 07-31-2008, 8:11 PM Posts 4

  Re: Error report - Unhandled exception 0xC0000005: Access violation Reply Contact I removed the INTO clause and changed to the DATAGRID output format.  The unhandled exception still occurred at the same address (0x01045448). The new command-line: LogParser -i:IISW3C -o:DATAGRID file:"LPQ - Preprocess an IIS log file.sql"?SourceFile="ex080511.log" The new query: SELECT TOP 10 '%SourceFile%' AS [SourceFile],     [LogRow],     SUB(TO_TIMESTAMP([date], [time]), TIMESTAMP('5', 'h')) AS [local-date-time],     [c-ip],     [s-sitename],     [s-port],     [cs-method],     [cs-uri-stem],     [cs-uri-query],     [sc-status],     [sc-substatus],     [sc-win32-status],     [time-taken],     [cs(User-Agent)] FROM '%SourceFile%' ORDER BY [local-date-time],     [LogRow] Thanks for the troubleshooting idea.

• 08-04-2008, 3:47 PM

  In reply to

  tnbarkhouse Joined on 07-31-2008, 8:11 PM Posts 4	Re: Error report - Unhandled exception 0xC0000005: Access violation Reply Contact Does anybody know how I can submit a Minidump to the developers of Log Parser?  It would really help them to investigate this reproducible error. I browsed around the Microsoft Connect web site but didn't see a relevant "connection." Thanks, Trevor

• 08-05-2008, 3:18 PM

  In reply to

  joelangley Joined on 07-20-2008, 2:37 PM Posts 82	Re: Error report - Unhandled exception 0xC0000005: Access violation Reply Contact The author of log parser is no longer at MSFT and we don't know (but sure hope) if this will still be supported in some way for the future (can we all scream for logparser 3.0)...so I guess you are out of luck if no one on this board knows :(