Hi Edgar-the-Parser, maybe you have broken installation of MS Log Parser 2.2? Try to reinstall MS Log Parser 2.2 and see if it helps. Log Parser Lizard is using Log Parser COM API as a parsing engine, so if anyone get error messages like this "...bla-bla-bla
COM class ... bla-bla ... CLSID {8CFEBA94-3FC2-45CA-B9A5-9EDACF704F66} ... bla-bla-bla..." on any kind of operation system (XP, Vista, Server 2008, etc...) or after an update or something, just try to reinstall MS Log Parser 2.2 and see if LPL works fine.
If it still don’t work, maybe you should try something else (reinstall .Net 2.0, Log Parser itself, etc... :). Bye.
Hi, great tool and initiative. I could not get it to work though.
When I click on a button I get this error:
"Retrieving the COM class factory for component with CLSID {............ID.........} failed due to the following error: 80040154
Could you please help ?
Thanx in advance.
Angelos
I am getting the same error.. here is the log entry.
2008-10-27 11:38:38,572 47257 [3360] ERROR LLABS - Exception: System.Runtime.InteropServices.COMException
Message: Retrieving the COM class factory for component with CLSID {8CFEBA94-3FC2-45CA-B9A5-9EDACF704F66} failed due to the following error: 80040154.
Source: Log Parser Lizard
at LogParserLizard.LogParser..ctor()
at LogParserLizard.frmLogReportBase..ctor()
at LogParserLizard.frmLogReportCommand..ctor()
at LogParserLizard.frmMain.OpenQueryForm(Int32 QueryId)
at LogParserLizard.frmMain.UltraExplorerBar1_ItemClick(Object sender, ItemEventArgs e)
anyone know what the issue may be?
thanks
EDIT: Nevermind guys, i figured out what was wrong
1. IAS-Chat_Transcript_from_IIS.sql is the file that contains my query.
2.logfiles is my key constant or the parameter that gets replaced in the query written in the .sql file.
3.+rooms='80cfa2f1-d863-44d2-a6b4-9ab32ae9b2ac' is again another parameter that i pass to the query in IAS-Chat_Transcript_from_IIS.sql .So based in this parameter the query retrieves data related to room guid having the above mentioned values from [cs-uri-query]
column of the IIS log.
I required to know how i can pass this +rooms='80cfa2f1-d863-44d2-a6b4-9ab32ae9b2ac' in the Log parser Lizard GUI tool?
Hi sunutha. This qwee thing I don’t understand but for previous question, you can see if LPL “Options” will work for you. Create your query in LPL and create ‘option’ in the options dialog box (ex. ROOMS with value '80cfa2f1-d863-44d2-a6b4-9ab32ae9b2ac'),
so you can modify your query something like this, “select * from ... where rooms = #ROOMS#”, or something. You can change the value for your option when you’ll need a new value. You can’t pass a file with sql query to a log parser lizard. Bye.
lizardlabs
40 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Oct 16, 2008 09:01 AM|LINK
Hi Edgar-the-Parser, maybe you have broken installation of MS Log Parser 2.2? Try to reinstall MS Log Parser 2.2 and see if it helps. Log Parser Lizard is using Log Parser COM API as a parsing engine, so if anyone get error messages like this "...bla-bla-bla COM class ... bla-bla ... CLSID {8CFEBA94-3FC2-45CA-B9A5-9EDACF704F66} ... bla-bla-bla..." on any kind of operation system (XP, Vista, Server 2008, etc...) or after an update or something, just try to reinstall MS Log Parser 2.2 and see if LPL works fine. If it still don’t work, maybe you should try something else (reinstall .Net 2.0, Log Parser itself, etc... :). Bye.
Edgar the Pa...
13 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Oct 16, 2008 03:55 PM|LINK
Yes, that was it. I reinstalled the Log Parser 2.2 after which Lizard resumed working again. Thank you very much!
tom2000
3 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Oct 27, 2008 03:45 PM|LINK
I am getting the same error.. here is the log entry.
2008-10-27 11:38:38,572 47257 [3360] ERROR LLABS - Exception: System.Runtime.InteropServices.COMException
Message: Retrieving the COM class factory for component with CLSID {8CFEBA94-3FC2-45CA-B9A5-9EDACF704F66} failed due to the following error: 80040154.
Source: Log Parser Lizard
at LogParserLizard.LogParser..ctor()
at LogParserLizard.frmLogReportBase..ctor()
at LogParserLizard.frmLogReportCommand..ctor()
at LogParserLizard.frmMain.OpenQueryForm(Int32 QueryId)
at LogParserLizard.frmMain.UltraExplorerBar1_ItemClick(Object sender, ItemEventArgs e)
anyone know what the issue may be?
thanks
EDIT: Nevermind guys, i figured out what was wrong
sunithavasud...
3 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Nov 06, 2008 08:05 AM|LINK
I am using the GUI Log Parser tool from Lizardlabs.I would like to know how can i pass parameters to my query (IIS logs)?
in the command line log parser i give the file name as :
c:\program Files\Log Parser 2.2>LogParser -o:DATAGRID file:IAS-Chat_Transcript_from_IIS.sql?logfiles=G:\CustomerDocs\Symmantec\Latest_logs(Mar2008)\EX01_0302200
8to03032008\ex*+rooms='80cfa2f1-d863-44d2-a6b4-9ab32ae9b2ac'
Point to note from the above path:
1. IAS-Chat_Transcript_from_IIS.sql is the file that contains my query.
2.logfiles is my key constant or the parameter that gets replaced in the query written in the .sql file.
3.+rooms='80cfa2f1-d863-44d2-a6b4-9ab32ae9b2ac' is again another parameter that i pass to the query in IAS-Chat_Transcript_from_IIS.sql .So based in this parameter the query retrieves data related to room guid having the above mentioned values from [cs-uri-query] column of the IIS log.
I required to know how i can pass this +rooms='80cfa2f1-d863-44d2-a6b4-9ab32ae9b2ac' in the Log parser Lizard GUI tool?
Thanks for your help,
Regards,
Sunitha
sunithavasud...
3 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Nov 06, 2008 08:06 AM|LINK
qwee
lizardlabs
40 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Nov 06, 2008 09:03 AM|LINK
Hi sunutha. This qwee thing I don’t understand but for previous question, you can see if LPL “Options” will work for you. Create your query in LPL and create ‘option’ in the options dialog box (ex. ROOMS with value '80cfa2f1-d863-44d2-a6b4-9ab32ae9b2ac'), so you can modify your query something like this, “select * from ... where rooms = #ROOMS#”, or something. You can change the value for your option when you’ll need a new value. You can’t pass a file with sql query to a log parser lizard. Bye.
Photo_Joe
6 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Nov 18, 2008 01:57 AM|LINK
I could use some help with a query.
I can list all the log records that have cs-method = post and order they by cs-uri-stem then by cs-status with this query.
SELECT date, time, c-ip, cs-uri-stem, cs-method, sc-status FROM c:\logs\08-08\0808.log
WHERE (cs-method = 'POST') ORDER BY cs-uri-stem, sc-status
But now I want to get just a count of all the records that have cs-method = post and that have a cs-status = 200 and order by cs-uri-stem
Thanks
Joe
Edgar the Pa...
13 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Nov 18, 2008 02:03 AM|LINK
Simply add (sc-status = 200) to the WHERE clause:
WHERE (cs-method = 'POST') AND (sc-status = 200)
You can then exclude sc-status from ORDER BY.
Photo_Joe
6 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Nov 18, 2008 01:23 PM|LINK
But that does not give me a count. It would just give list of all the records that matched.
PhotoJoe
Rovastar
3324 Posts
MVP
Moderator
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Nov 18, 2008 01:32 PM|LINK
I can't remember for sure but the normal SQL command 'count' can be used.
http://msdn.microsoft.com/en-us/library/ms175997.aspx