1
Vote

Unable to generate PAL reports

description

I have started receiving the following error for any PAL reports that I try to generate.

 

PAL v2.2.1 (http://www.codeplex.com/PAL)
Written by: Clint Huffman (clinth@microsoft.com) and other contributors.
Last Modified: 03/21/2012 14:09:24
The information and actions by this tool is provided "as is" and is intended f
information purposes only. The authors and contributors of this tool take no
sponsibility for damages or losses incurred by use of this tool.
 
Your locale is set to: English (United States)
SCRIPT ARGUMENTS:
-Log C:\Users\XXXXXXXX\Desktop\TR_Load_Test_2011_20120501\Load_Test_2011_201205
1.blg
-ThresholdFile C:\Program Files\PAL\PAL\SQLServer.xml
-Interval AUTO
-OutputDir C:\Users\XXXXXXXX\Desktop\TR_Load_Test_2011_20120501
-IsOutputHtml True
-HtmlOutputFileName [LogFileName]_PAL_ANALYSIS_[DateTimeStamp].htm
-AllCounterStats True
-IsOutputXml False
-XmlOutputFileName [LogFileName]_PAL_ANALYSIS_[DateTimeStamp].xml
-BeginTime
-EndTime
 
 
Creating session working directory...
Creating directory "C:\Users\XXXXXXXX\AppData\Local\Temp{42a369f0-b204-4e9f-97
-b9e545406e0a}"
Creating file "C:\Users\XXXXXXXX\Desktop\TR_Load_Test_2011_20120501\Load_Test_2
1_20120501_PAL_ANALYSIS_2012-05-02_09-48-21.htm"
Creating directory "C:\Users\XXXXXXXX\Desktop\TR_Load_Test_2011_20120501\Load_T
t_2011_20120501_PAL_ANALYSIS_2012-05-02_09-48-21\"
 
Threshold File Load History:
C:\Program Files\PAL\PAL\SQLServer.xml
QuickSystemOverview.xml
SystemOverview.xml
 
Generating the counter list to filter on...Done
Removing duplicate counter expressions from counter list...Done
 
relog.exe "C:\Users\XXXXXXXX\Desktop\TR_Load_Test_2011_20120501\Load_Test_2011_
120501.blg" -f csv -o "C:\Users\XXXXXXXX\AppData\Local\Temp{42a369f0-b204-4e9f
7cc-b9e545406e0a}_FilteredPerfmonLog.csv" -y
 
WARNING: Please post errors or problems with this tool to the PAL web site
located at http://www.codeplex.com/PAL with the following error message and a
brief description of what you were trying to do. Thank you.
Exception calling "Join" with "2" argument(s): "Value cannot be null.
Parameter name: value"
At C:\Program Files\PAL\PAL\PAL.ps1:814 char:49
  • $sRelogOutputAsSingleString = [string]::join <<<< ("", $RelogOutput)
    • CategoryInfo : NotSpecified: (:) [], ParentContainsErrorRecordE
      xception
    • FullyQualifiedErrorId : DotNetMethodException
       
       
      I typically use PAL to generate reports of our SQL 2005/2008 systems. I have attached a copy of the BLG file that was used as input, although it seems to happen on any.

file attachments

comments

ClintH wrote May 29, 2012 at 6:24 AM

I am able to process the log just fine. It looks like Relog.exe (part of the operating system) failed to convert the counter log to a CSV, so PAL an process the log. Please ensure that you are analyzing counter logs on a Windows 7 or Windows Server 2008 R2 computer. The binary counter log (*.blg) format changed as of Windows Vista and Windows Server 2008 and is incompatible on Windows XP and Windows Server 2003 and earlier. Please let me know if this resolves your issue or not.

Shadowen wrote Jul 12, 2012 at 6:41 PM

What is strange is that it fails on this command:

relog.exe "C:\Users\XXXXXXXX\Desktop\TR_Load_Test_2011_20120501\Load_Test_2011_
120501.blg" -f csv -o "C:\Users\XXXXXXXX\AppData\Local\Temp{42a369f0-b204-4e9f
7cc-b9e545406e0a}_FilteredPerfmonLog.csv" -y

However, if I run that command manually in a command prompt it creates a csv file without error. I can then load that csv file into the PAL tool (instead of the blg) and it creates my report. I don't understand why the relog command is failing when it is executed from PAL, and not when it is executed manually.

ClintH wrote Jul 17, 2012 at 11:47 PM

I don't know either.
If the file path has any unual characters in it, then that might cause it to fail.