1

Closed

V1.2 - An error occurred while creating a chart using LogParser.

description

Hi Clint,
 
I am facing my first problem with your tool, using it happilly every day since January...
 
I am running "System Overview" analysis from BLGs coming from a W2003 machine, my laptop runs on Vista.
I am getting:
 
 
Analyzing "Pool Non Paged Bytes"...
[CHART]SELECT QUANTIZE([(PDH-CSV 4.0) (Romance Standard Time)(-60)],600) AS Interval, AVG(TO_REAL([\ROT02CFESV01B\Memory\Pool Nonpaged Bytes])) AS RO
T02CFESV01B\Value, AVG(TO_REAL([\ROT02CFESV01A.ROT02CTL.EA.XOM.COM\Memory\Pool Nonpaged Bytes])) AS ROT02CFESV01A_ROT02CTL_EA_XOM_COM\Value INTO D:\M
YDOCU~1\PALREP~1\memory_PERFMON_LOG_ANALYSIS_Date_2008-02-26_17-42-4747\MemoryPool_Nonpaged_Bytes_0.gif FROM C:\Users\E169607\AppData\Local\Temp_Filt
eredPerfmonLog.csv GROUP BY Interval ORDER BY Interval ASC
===============================ERROR========================================
[GenerateChart]
An error occurred while creating a chart using LogParser.
ChartTitle: \Memory\Pool Nonpaged Bytes
Categories: AUTO
ChartType: Line
GroupSize: 640x480
Legend: ON
MaxCategoryLables: 0
OTSFormat: MM/dd hh:mm
Query:
SELECT QUANTIZE([(PDH-CSV 4.0) (Romance Standard Time)(-60)],600) AS Interval, AVG(TO_REAL([\ROT02CFESV01B\Memory\Pool Nonpaged Bytes])) AS ROT02CFE
SV01B\Value, AVG(TO_REAL([\ROT02CFESV01A.ROT02CTL.EA.XOM.COM\Memory\Pool Nonpaged Bytes])) AS ROT02CFESV01A_ROT02CTL_EA_XOM_COM\Value INTO D:\MYDOCU~
1\PALREP~1\memory_PERFMON_LOG_ANALYSIS_Date_2008-02-26_17-42-4747\MemoryPool_Nonpaged_Bytes_0.gif FROM C:\Users\E169607\AppData\Local\Temp_FilteredPe
rfmonLog.csv GROUP BY Interval ORDER BY Interval ASC
Error Number: -2131622320
Error Description: Error parsing query: SELECT clause: Syntax Error: unknown field '\ROT02CFESV01A.ROT02CTL.EA.XOM.COM\Memory\Pool Nonpaged Bytes' [
Record field does not exist.]
Possible Cause: This will occur on occassion on Windows XP computers. These errors should not occur on Windows Vista.
 
See attached email for more...
 
Is this something you would expect?

file attachments

Closed Aug 30, 2008 at 4:15 PM by ClintH
No response from users in 6 months, so assuming this is resolved.

comments

pksmania wrote Feb 26, 2008 at 4:07 PM

oops...attaching the output now

ClintH wrote Feb 27, 2008 at 11:19 PM

Hmm... I'm not sure what is causing the unknown field error. I fixed this issue in v1.2 by explicitly getting the counter list from the converted CSV log file, so this is new. Is there anyway you can send me the log file?

Also, make sure you are using an English locale.