Processing Error

Jul 1, 2011 at 12:16 PM

Hi there,

I'm testing PAL using a small (1Mb) .BLG file of data captured from a Win 2008R2 server running SQL 2008. The log file is OK and can be loaded and viewed in PerfMon, however, when I try to process it in PAL, it generates the following {GUID}_RunPAL.bat file:

C:
cd "C:\Program Files\PAL\PAL v2.0.7"
Powershell -NoProfile ".\PAL.ps1" -Log 'C:\Temp\SQL\SQL_Server_2005_2008.blg' -ThresholdFile 'C:\Program Files\PAL\PAL v2.0.7\SQLServer.xml' -Interval 'AUTO' -IsOutputHtml $True -HtmlOutputFileName '[LogFileName]_PAL_ANALYSIS_[DateTimeStamp].htm' -IsOutputXml $False -XmlOutputFileName '[LogFileName]_PAL_ANALYSIS_[DateTimeStamp].xml' -AllCounterStats $False -OutputDir 'C:\Temp\report' -NumberOfProcessors 1 -ThreeGBSwitch $False -SixtyFourBit $True -TotalMemory 2

The processing starts but fails, generating the following output:

PAL v2.0.6 (http://www.codeplex.com/PAL)
Written by: Clint Huffman (clinth@microsoft.com) and other contributors.
Last Modified: 01/19/2011 12:46:40
The information and actions by this tool is provided "as is" and is intended for
 information purposes only. The authors and contributors of this tool take no re
sponsibility for damages or losses incurred by use of this tool.

Your locale is set to: English (United States)
SCRIPT ARGUMENTS:
-Log C:\Temp\SQL\SQL_Server_2005_2008.blg
-ThresholdFile C:\Program Files\PAL\PAL v2.0.7\SQLServer.xml
-Interval AUTO
-OutputDir C:\Temp\report
-IsOutputHtml True
-HtmlOutputFileName [LogFileName]_PAL_ANALYSIS_[DateTimeStamp].htm
-AllCounterStats False
-IsOutputXml False
-XmlOutputFileName [LogFileName]_PAL_ANALYSIS_[DateTimeStamp].xml
-BeginTime
-EndTime


Creating session working directory...
Creating directory "C:\DOCUME~1\ADMINI~1.TES\LOCALS~1\Temp\{a3d72c81-52df-429c-b
2e0-4e542caab56e}"
Creating file "C:\Temp\report\SQL_Server_2005_2008_PAL_ANALYSIS_2011-07-01_12-05
-39.htm"
Creating directory "C:\Temp\report\SQL_Server_2005_2008_PAL_ANALYSIS_2011-07-01_
12-05-39\"

Threshold File Load History:
C:\Program Files\PAL\PAL v2.0.7\SQLServer.xml
QuickSystemOverview.xml

Generating the counter list to filter on...Done
Removing duplicate counter expressions from counter list...Done

relog.exe "C:\Temp\SQL\SQL_Server_2005_2008.blg" -cf "C:\Documents and Settings\
administrator.TESTDOM\Local Settings\Temp\{a3d72c81-52df-429c-b2e0-4e542caab56e}
\CounterListFilter.txt" -f csv -o "C:\Documents and Settings\administrator.TESTD
OM\Local Settings\Temp\{a3d72c81-52df-429c-b2e0-4e542caab56e}\_FilteredPerfmonLo
g.csv" -y
Input
----------------
File(s):
     C:\Temp\SQL\SQL_Server_2005_2008.blg (Binary)
Begin:    1/1/1601 0:00:00
End:      1/1/1601 0:00:00
Samples:  0
Output
----------------
File:     C:\Documents and Settings\administrator.TESTDOM\Local Settings\Temp\{
a3d72c81-52df-429c-b2e0-4e542caab56e}\_FilteredPerfmonLog.csv
Begin:    1/1/1601 0:00:00
End:      1/1/1601 0:00:00
Samples:  0
The command completed successfully.
MergeConvertFilterPerfmonLogs : [MergeConvertFilterPerfmonLogs] ERROR: Unable t
o use the log file(s):"C:\Documents and Settings\administrator.TESTDOM\Local Se
ttings\Temp\{a3d72c81-52df-429c-b2e0-4e542caab56e}\_FilteredPerfmonLog.csv" -y
At C:\Program Files\PAL\PAL v2.0.7\PAL.ps1:5031 char:38
+         MergeConvertFilterPerfmonLogs <<<<  -sPerfmonLogPaths $Log
    + CategoryInfo          : NotSpecified: (:) [Write-Error], WriteErrorExcep
   tion
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorExceptio
   n,MergeConvertFilterPerfmonLogs

MergeConvertFilterPerfmonLogs : The counters in the log(s) do not contain any u
seable samples.
At C:\Program Files\PAL\PAL v2.0.7\PAL.ps1:5031 char:38
+         MergeConvertFilterPerfmonLogs <<<<  -sPerfmonLogPaths $Log
    + CategoryInfo          : NotSpecified: (:) [Write-Error], WriteErrorExcep
   tion
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorExceptio
   n,MergeConvertFilterPerfmonLogs


C:\Program Files\PAL\PAL v2.0.7>

Can you please advise where I'm going wrong?

Cheers,

S.