Property 'MIN' cannot be found on this object. Make sure that it exists

Sep 8 at 8:20 PM

Windows PowerShell Transcript Start
Start time: 20160908101047
Username : PACCAR-NA\s-hthomas
Machine : PECCOLMVP212 (Microsoft Windows NT 6.1.7601 Service Pack 1)

Transcript started, output file is C:\Users\S-HTHO~1\AppData\Local\Temp\3\PAL.l
og
PAL 2.7.5 (http://pal.codeplex.com)
Written by: Clint Huffman (clinth@microsoft.com) and other contributors.
Last Modified: 09/07/2016 12:43:24
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 responsibility for damages or losses incurred by use of this tool.

Your locale is set to: English (United States)
SCRIPT ARGUMENTS:

Name Value

AllCounterStats False
AnalysisInterval AUTO
BeginTime
DisplayReport True
EndTime
HtmlOutputFileName [LogFileName]_PAL_ANALYSIS_[DateTimeStamp].htm
Interval AUTO
IsLowPriority False
IsOutputHtml True
IsOutputXml False
Log D:\PAL_Microsoft_SQL_Server_2008___R2.blg
NumberOfThreads 2
OLTPvsOLAP $True
OS 64-bit Windows Server 2008 R2
OutputDir [My Documents]\PAL Reports
PhysicalMemory 32
PLEHealth 1000
ThresholdFile D:\PAL_Flatfiles_v2.7.6_x64\SQLServer2008R2.xml
UserVa 2048
XmlOutputFileName [LogFileName]_PAL_ANALYSIS_[DateTimeStamp].xml

Creating session working directory...
Creating directory "C:\Users\S-HTHO~1\AppData\Local\Temp\3\615d2210-168c-407b-9382-b0f2709a19e0"
Creating directory "C:\Users\s-hthomas\Documents\PAL Reports\"
Creating file "C:\Users\s-hthomas\Documents\PAL Reports\PAL_Microsoft_SQL_Server_2008___R2_PAL_ANALYSIS_20160908101047.htm"
Creating directory "C:\Users\s-hthomas\Documents\PAL Reports\PAL_Microsoft_SQL_Server_2008___R2_PAL_ANALYSIS_20160908101047\"

Threshold File Load History (in order of priority):
D:\PAL_Flatfiles_v2.7.6_x64\SQLServer2008R2.xml
SystemOverview.xml
QuickSystemOverview.xml

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

relog.exe "D:\PAL_Microsoft_SQL_Server_2008___R2.blg" -cf "C:\Users\S-HTHO~1\AppData\Local\Temp\3\615d2210-168c-407b-9382-b0f2709a19e0\CounterListFilter.txt" -f csv -o "C:\Users\S-HTHO~1\AppData\Local\Temp\3\615d2210-168c-407b-9382-b0f2709a19e0_FilteredPerfmonLog.csv" -y

Input

File(s):
 D:\PAL_Microsoft_SQL_Server_2008___R2.blg (Binary)
Begin: 9/7/2016 14:44:30
End: 9/8/2016 7:01:31
Samples: 3909

Output

File: C:\Users\S-HTHO~1\AppData\Local\Temp\3\615d2210-168c-407b-9382-b0f270
9a19e0_FilteredPerfmonLog.csv
Begin: 9/7/2016 14:44:30
End: 9/8/2016 7:01:31
Samples: 3909
The command completed successfully.

Auto analysis interval (one time only)...Done
Number Of Counter Instances In Perfmon Log: 1577

Quantized index (one time only)...Done!
Matching counter instances to threshold data sources...Done [1.451 seconds]
Calculating counter statistics [very CPU intensive]...
Number of jobs passed into Thread(0): 39
Security Warning
Run only scripts that you trust. While scripts from the Internet can be useful,
this script can potentially harm your computer. Do you want to run
D:\PAL_Flatfiles_v2.7.6_x64\PalGenerateMultiCounterStats.ps1?
[D] Do not run [R] Run once [S] Suspend [?] Help (default is "D"): R
C:\Users\s-hthomas\Documents\PAL Reports\PAL_Microsoft_SQL_Server_2008___R2Erro
r0_PAL.htm
Start-Job : File D:\PAL_Flatfiles_v2.7.6_x64\PalGenerateMultiCounterStats.ps1 c
annot be loaded because you have elected to not run this software now.
At D:\PAL_Flatfiles_v2.7.6_x64\PAL.ps1:2233 char:32
  • $oJobReturn = Start-Job <<<< -FilePath .\PalGenerateMultiCounterStat
    s.ps1 -ArgumentList $oBatch, $global:oPal.QuantizedIndex, $global:oPal.ArgsProc
    essed.AnalysisInterval, $global:oPal.ArgsProcessed.IsLowPriority, $t
    • CategoryInfo : NotSpecified: (:) [Start-Job], PSSecurityExcepti
      on
    • FullyQualifiedErrorId : RuntimeException,Microsoft.PowerShell.Commands.S
      tartJobCommand
Creating generated counter data [This is PAL working with multiple counters to produce a single result]...
Network Interface % Network Utilization
C:\Users\s-hthomas\Documents\PAL Reports\PAL_Microsoft_SQL_Server_2008___R2Erro
r0_PAL.htm
Invoke-Expression : Property 'CounterInstance' cannot be found on this object.
Make sure that it exists.
At D:\PAL_Flatfiles_v2.7.6_x64\PAL.ps1:2454 char:22
  • Invoke-Expression <<<< -Command $sCode
    • CategoryInfo : InvalidOperation: (.:OperatorToken) [Invoke-Expr
      ession], RuntimeException
    • FullyQualifiedErrorId : PropertyNotFoundStrict,Microsoft.PowerShell.Comm
      ands.InvokeExpressionCommand
Generating Charts...
 Process % Privileged Time
C:\Users\s-hthomas\Documents\PAL Reports\PAL_Microsoft_SQL_Server_2008___R2Erro
r0_PAL.htm
Invoke-Expression : Property 'Max' cannot be found on this object. Make sure th
at it exists.
At D:\PAL_Flatfiles_v2.7.6_x64\PAL.ps1:2454 char:22
  • Invoke-Expression <<<< -Command $sCode
    • CategoryInfo : InvalidOperation: (.:OperatorToken) [Invoke-Expr
      ession], RuntimeException
    • FullyQualifiedErrorId : PropertyNotFoundStrict,Microsoft.PowerShell.Comm
      ands.InvokeExpressionCommand
Processing Thresholds...
 Process % Privileged Time
C:\Users\s-hthomas\Documents\PAL Reports\PAL_Microsoft_SQL_Server_2008___R2Erro
r0_PAL.htm
Property 'MIN' cannot be found on this object. Make sure that it exists.
At D:\PAL_Flatfiles_v2.7.6_x64\PAL.ps1:3505 char:82
  • $XmlNewCounterInstance.SetAttribute("MIN", $($XmlCounterInsta
    nce. <<<< MIN))
    • CategoryInfo : InvalidOperation: (.:OperatorToken) [], RuntimeE
      xception
    • FullyQualifiedErrorId : PropertyNotFoundStrict
Generating the HTML Report...
Script Execution Duration: 02:06:49.5085114

C:\Users\s-hthomas\Documents\PAL Reports\PAL_Microsoft_SQL_Server_2008___R2Erro
r0_PAL.htm
Property 'MIN' cannot be found on this object. Make sure that it exists.
At D:\PAL_Flatfiles_v2.7.6_x64\PAL.ps1:5091 char:180
  • '<TR><TD BGCOLOR="#00FF00
    ">OK</TD><TD>' + $sCounterInstance + '</TD><TD>' + $(AddThousandsSeparator -Val
    ue $XmlCounterInstance. <<<< MIN) + '</TD><TD>' + $(AddThousandsSeparator -Valu
    e $XmlCounterInstance.AVG) + '</TD><TD>' + $(AddThousandsSeparator -Value $XmlC
    ounterInstance.MAX) + '</TD><TD>' + $(AddThousandsSeparator -Value $XmlCounterI
    nstance.TREND) + '</TD><TD>' + $(AddThousandsSeparator -Value $XmlCounterInstan
    ce.STDDEV) + '</TD><TD>' + $(AddThousandsSeparator -Value $XmlCounterInstance.P
    ERCENTILENINETYTH) + '</TD><TD>' + $(AddThousandsSeparator -Value $XmlCounterIn
    stance.PERCENTILEEIGHTYTH) + '</TD><TD>' + $(AddThousandsSeparator -Value $XmlC
    ounterInstance.PERCENTILESEVENTYTH) + '</TD></TR>' >> $h
    • CategoryInfo : InvalidOperation: (.:OperatorToken) [], RuntimeE
      xception
    • FullyQualifiedErrorId : PropertyNotFoundStrict
C:\Users\s-hthomas\Documents\PAL Reports\PAL_Microsoft_SQL_Server_2008___R2_PAL
_ANALYSIS_20160908101047.htm

Windows PowerShell Transcript End
End time: 20160908121736

Oct 14 at 1:55 PM
Hello, I run into the same issue. Last version is not stable PAL_Flatfiles_v2.7.6_x64.zip. Could you please add the installation file?

Thank you.