PAL 1.3.3.1 with Windows 2008 X64 EE

Sep 10, 2008 at 1:48 AM
Edited Sep 10, 2008 at 2:05 AM
Hi,
I installed PAL 1.3.3.1 in my Windows 2008 x64 Enterprise Edition.But when I try to make it working, I got 'Log Row too long' error.this is the log:



<meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <meta name="ProgId" content="OneNote.File"> <meta name="Generator" content="Microsoft OneNote 12">

Waiting for C:\Users\ADMINI~1\AppData\Local\Temp\{7C4F3250-C5C1-42FB-A863-2321ED

C2B283}\_FilteredPerfmonLog.csv to be created...

Found C:\Users\ADMINI~1\AppData\Local\Temp\{7C4F3250-C5C1-42FB-A863-2321EDC2B283

}\_FilteredPerfmonLog.csv

Done using Relog.exe to create a temporary perfmon log with only counters being

analyzed.

SELECT [(PDH-CSV 4.0) (China Standard Time)(-480)] AS Time FROM C:\Users\ADMINI~

1\AppData\Local\Temp\{7C4F3250-C5C1-42FB-A863-2321EDC2B283}\_FilteredPerfmonLog.

csv

[AutoDetectTheIntervalOfThePerfmonLog] ERROR Number: -2147221020

[AutoDetectTheIntervalOfThePerfmonLog] ERROR Description: Error parsing query: L

og row too long

LogFile "C:\Users\ADMINI~1\AppData\Local\Temp\{7C4F3250-C5C1-42FB-A863-2321EDC2B

283}\_FilteredPerfmonLog.csv", Row number 1 [Unknown Error]

SELECT QUANTIZE([(PDH-CSV 4.0) (China Standard Time)(-480)], 60) AS Interval FRO

M C:\Users\ADMINI~1\AppData\Local\Temp\{7C4F3250-C5C1-42FB-A863-2321EDC2B283}\_F

ilteredPerfmonLog.csv GROUP BY Interval

[GenerateArrayOfTimeIntervals] ERROR Number: -2147221020

[GenerateArrayOfTimeIntervals] ERROR Description: Error parsing query: Log row t

oo long

LogFile "C:\Users\ADMINI~1\AppData\Local\Temp\{7C4F3250-C5C1-42FB-A863-2321EDC2B

283}\_FilteredPerfmonLog.csv", Row number 1 [Unknown Error]

CSVInMaxRowSize: 194462

Executing: ReLog.exe "C:\Users\ADMINI~1\AppData\Local\Temp\{7C4F3250-C5C1-42FB-A

863-2321EDC2B283}\_FilteredPerfmonLog.csv" -f CSV -y -o C:\Users\ADMINI~1\AppDat

a\Local\Temp\{7C4F3250-C5C1-42FB-A863-2321EDC2B283}\_FilteredLogForCounterlist.c

sv

<meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <meta name="ProgId" content="OneNote.File"> <meta name="Generator" content="Microsoft OneNote 12">

Input

----------------

File(s):

     C:\Users\ADMINI~1\AppData\Local\Temp\{7C4F3250-C5C1-42FB-A863-2321EDC2B283}

\_FilteredPerfmonLog.csv (CSV)

 

Begin:    2008/9/8 4:00:33

End:      2008/9/8 17:59:20

Samples:  840

 

0.00%0.00%1.19%2.38%3.57%4.76%5.95%7.14%8.33%9.52%10.71%11.90%13.10%14.29%15.48%

16.67%17.86%19.05%20.24%21.43%22.62%23.81%25.00%26.19%27.38%28.57%29.76%30.95%32

.14%33.33%34.52%35.71%36.90%38.10%39.29%40.48%41.67%42.86%44.05%45.24%46.43%47.6

2%48.81%50.00%51.19%52.38%53.57%54.76%55.95%57.14%58.33%59.52%60.71%61.90%63.10%

64.29%65.48%66.67%67.86%69.05%70.24%71.43%72.62%73.81%75.00%76.19%77.38%78.57%79

.76%80.95%82.14%83.33%84.52%85.71%86.90%88.10%89.29%90.48%91.67%92.86%94.05%95.2

4%96.43%97.62%98.81%100.00%100.00%

 

Output

----------------

File:     C:\Users\ADMINI~1\AppData\Local\Temp\{7C4F3250-C5C1-42FB-A863-2321EDC2

B283}\_FilteredLogForCounterlist.csv

 

Begin:    2008/9/8 4:00:33

End:      2008/9/8 17:59:20

Samples:  840

 

The command completed successfully.

 

Waiting for C:\Users\ADMINI~1\AppData\Local\Temp\{7C4F3250-C5C1-42FB-A863-2321ED

C2B283}\_FilteredLogForCounterlist.csv to be created...

Found C:\Users\ADMINI~1\AppData\Local\Temp\{7C4F3250-C5C1-42FB-A863-2321EDC2B283

}\_FilteredLogForCounterlist.csv

Generating XML data...

Analyzing "Processor Utilization Analysis"...

[CHART]SELECT QUANTIZE([(PDH-CSV 4.0) (China Standard Time)(-480)],60) AS Minute

, AVG(TO_REAL([\\GZ-MAIL-02\Processor(_Total)\% Processor Time])) AS _Total, AVG

(TO_REAL([\\GZ-MAIL-02\Processor(1)\% Processor Time])) AS 1, AVG(TO_REAL([\\GZ-

MAIL-02\Processor(0)\% Processor Time])) AS 0 INTO P:\PAL_RE~1\MI03BC~1.1_0\Proc

essorPercent_Processor_Time_0.gif FROM C:\Users\ADMINI~1\AppData\Local\Temp\{7C4

F3250-C5C1-42FB-A863-2321EDC2B283}\_FilteredPerfmonLog.csv GROUP BY Minute ORDER

 BY Minute ASC

===============================ERROR========================================

[GenerateChart]

An error occurred while creating a chart using LogParser.

 ChartTitle: \Processor(*)\% Processor Time

 Categories: AUTO

 ChartType: Line

 GroupSize: 640x480

 Legend: ON

 MaxCategoryLables: 0

 OTSFormat: MM/dd hh:mm

 Query:

 SELECT QUANTIZE([(PDH-CSV 4.0) (China Standard Time)(-480)],60) AS Minute, AVG(

TO_REAL([\\GZ-MAIL-02\Processor(_Total)\% Processor Time])) AS _Total, AVG(TO_RE

AL([\\GZ-MAIL-02\Processor(1)\% Processor Time])) AS 1, AVG(TO_REAL([\\GZ-MAIL-0

2\Processor(0)\% Processor Time])) AS 0 INTO P:\PAL_RE~1\MI03BC~1.1_0\ProcessorP

ercent_Processor_Time_0.gif FROM C:\Users\ADMINI~1\AppData\Local\Temp\{7C4F3250-

C5C1-42FB-A863-2321EDC2B283}\_FilteredPerfmonLog.csv GROUP BY Minute ORDER BY Mi

nute ASC

 Error Number: -2147221020

 Error Description: Error parsing query: Log row too long

LogFile "C:\Users\ADMINI~1\AppData\Local\Temp\{7C4F3250-C5C1-42FB-A863-2321EDC2B

283}\_FilteredPerfmonLog.csv", Row number 1 [Unknown Error]

============================================================================

SELECT QUANTIZE([(PDH-CSV 4.0) (China Standard Time)(-480)], 60) AS Minute, MIN(

TO_REAL([\\GZ-MAIL-02\Processor(_Total)\% Processor Time])) AS min, AVG(TO_REAL(

[\\GZ-MAIL-02\Processor(_Total)\% Processor Time])) AS avg, MAX(TO_REAL([\\GZ-MA

IL-02\Processor(_Total)\% Processor Time])) AS max FROM C:\Users\ADMINI~1\AppDat

a\Local\Temp\{7C4F3250-C5C1-42FB-A863-2321EDC2B283}\_FilteredPerfmonLog.csv GROU

P BY Minute

[QueryCounterInstanceData] ERROR Number: -2147221020

[QueryCounterInstanceData] ERROR Description: Error parsing query: Log row too l

ong

LogFile "C:\Users\ADMINI~1\AppData\Local\Temp\{7C4F3250-C5C1-42FB-A863-2321EDC2B

283}\_FilteredPerfmonLog.csv", Row number 1 [Unknown Error]

SELECT QUANTIZE([(PDH-CSV 4.0) (China Standard Time)(-480)], 60) AS Minute, MIN(

TO_REAL([\\GZ-MAIL-02\Processor(1)\% Processor Time])) AS min, AVG(TO_REAL([\\GZ

-MAIL-02\Processor(1)\% Processor Time])) AS avg, MAX(TO_REAL([\\GZ-MAIL-02\Proc

essor(1)\% Processor Time])) AS max FROM C:\Users\ADMINI~1\AppData\Local\Temp\{7

C4F3250-C5C1-42FB-A863-2321EDC2B283}\_FilteredPerfmonLog.csv GROUP BY Minute

[QueryCounterInstanceData] ERROR Number: -2147221020

[QueryCounterInstanceData] ERROR Description: Error parsing query: Log row too l

ong

LogFile "C:\Users\ADMINI~1\AppData\Local\Temp\{7C4F3250-C5C1-42FB-A863-2321EDC2B

283}\_FilteredPerfmonLog.csv", Row number 1 [Unknown Error]

SELECT QUANTIZE([(PDH-CSV 4.0) (China Standard Time)(-480)], 60) AS Minute, MIN(

TO_REAL([\\GZ-MAIL-02\Processor(0)\% Processor Time])) AS min, AVG(TO_REAL([\\GZ

-MAIL-02\Processor(0)\% Processor Time])) AS avg, MAX(TO_REAL([\\GZ-MAIL-02\Proc

essor(0)\% Processor Time])) AS max FROM C:\Users\ADMINI~1\AppData\Local\Temp\{7

C4F3250-C5C1-42FB-A863-2321EDC2B283}\_FilteredPerfmonLog.csv GROUP BY Minute

[QueryCounterInstanceData] ERROR Number: -2147221020

[QueryCounterInstanceData] ERROR Description: Error parsing query: Log row too l

ong

LogFile "C:\Users\ADMINI~1\AppData\Local\Temp\{7C4F3250-C5C1-42FB-A863-2321EDC2B

283}\_FilteredPerfmonLog.csv", Row number 1 [Unknown Error]

D:\Program Files\PAL\PAL.vbs(2774, 25) Microsoft VBScript runtime error: Object

required: 'oAlert'


But when I run PAL 1.3.3.1 with my Windows 2003 x86 Enterprise Editon SP2, I never got this error.
ah...When I using my Windows 2008 PC, I have been set the 'CSVInMaxRowSize = 00800000', but does't work.

thanks.
Coordinator
Sep 10, 2008 at 7:52 AM
Try running the CScript PAL.vbs under admin credentials. It will update the registry key to be big enough to handle the queries automatically as long as it has the rights to edit it. I believe the registry key has a maximum value of about 700K. If that still doesn't work for you, then the best you can do is to reduce the number of counters in the perfmon log and or in the PAL threshold file.
Sep 10, 2008 at 7:43 PM
Which threshold file is causing this error?