I find what was wrong. I was using reflection that's why the error message was not very helpful. I need to add the date in the group By and everything runs well. Thank you.

New to LogParser, I have a problem when this query in C# "SELECT TO_STRING(date,'yyyy-MM-dd') As LogDate, EXTRACT_TOKEN(FullUri, 0, '|') AS Uri, EXTRACT_TOKEN(cs-uri-query, -1, '|') AS ErrorMsg, EXTRACT_TOKEN(cs-uri-query, 1, '|') AS LineNo INTO AspErrors.xml FROM ex070418.log WHERE (sc-status = 500...

All, Running LogParser in VB.Net program using: ExecuteBatch(strQuery, inFormat, outFormat) Program runs great, except as a schedule task (when the user is not logged in). If the user schedules the task and stays logged in it runs great. Any ideas? Thanks in advance, Greg C.

Hello, I been looking into the forum's posts and logparser's documentation but I haven't found information about how to, if it is possible, run logparser as a service. With this I mean I would like logparser to be running all the time and each moment a new event arrives, it will query over that new event...

I found the answer: I had to replace all the spaces in sPath with "\u0020".

Yes I already know that lines in the help, but I do not implemented any lock between thread It could be the solution...I'll try. Thanks

Note that if you intrrupt the query processing before the last record of the recordset is reached, the checkpoint will not be created. while( !oRecordSet.atEnd() ) { // if you break here the checkpoint is not created oRecordSet.moveNext(); } // checkpoint is created only here, when the end of the recordset...

Well, that is an interesting question. I wonder if anyone tried the logParser and multithreading before :o Actually the help file says: Can I use the Log Parser scriptable COM components from a multi-threaded application? The Log Parser scriptable COM components are registered to run within a single...

I'm trying to write an ASP.Net app that uses Log Parser 2.2's COM interface to read some Windows Media Server (W3C) log files and generate a chart (GIF file) on the web server. I'm getting an error when attempting to generate the chart using the ExecuteBatch method: Error executing query: Unexpected...

Hi guys, I am new to logparser. I am using logparser 2.2. I am tryign to create a vbs file which would run daily in the night and query the Event Log (Application) and get all the errors generated by a particular application for that day only ordr by the latest. Can someone please help me with the query...