clinthuffman/PAL

Can not convert value during data processing

Closed this issue · 1 comments

jonsey80 commented

Recreating: converting a 60 mins perfmon file with multiple system and SQL counters using the all threashold File title on Pal v2.7.7

when it started processing Edge Transport - physical Disk avg.disk sec/reads the error was thrown

Invoke-Expression : Could not compare "0" to "0.02". Error: "Cannot convert value "0.02" to type "System.Char". Error:
"Invalid cast from 'Double' to 'Char'.""
At C:\Program Files\PAL\PAL\PAL.ps1:4337 char:9

  •     Invoke-Expression -Command $sCode

  •     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    • CategoryInfo : InvalidOperation: (:) [Invoke-Expression], RuntimeException
    • FullyQualifiedErrorId : ComparisonFailure,Microsoft.PowerShell.Commands.InvokeExpressionCommand

From the HTML Report:

Overall progress... Status: Applying thresholds, PAL 2.7.7 Progress: 82%... Applying thresholds, Edge Transport - PhysicalDisk Avg. Disk sec/Read

An error occurred on...
If ($oCounterInstance.QuantizedAvg[$t] -ge 0.02)
At line:11 char:7 + If ($oCounterInstance.QuantizedAvg[$t] -ge 0.02) + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Could not compare "0" to "0.02". Error: "Cannot convert value "0.02" to type "System.Char". Error: "Invalid cast from 'Double' to 'Char'.""

SCRIPT ARGUMENTS:
Log: C:\Users\mark.jones\Documents\ledw_etl\DBEDWSTGP1_DataCollector01.blg
ThresholdFile: C:\Program Files\PAL\PAL\All.xml
AnalysisInterval: AUTO
IsOutputHtml: $True
IsOutputXml: $False
HtmlOutputFileName: [LogFileName]PAL_ANALYSIS[DateTimeStamp].htm
XmlOutputFileName: [LogFileName]PAL_ANALYSIS[DateTimeStamp].xml
OutputDir: C:\Users\mark.jones\Documents\ledw_etl\preissue
AllCounterStats: $False
NumberOfThreads: 4
IsLowPriority: $True
DisplayReport: True

Please contact the PAL tool team with this error by posting it to pal.codeplex.com. Thank you!

from the pal log

Edge Transport - PhysicalDisk Avg. Disk sec/Read
PS>TerminatingError(Invoke-Expression): "Could not compare "0" to "0.02". Error: "Cannot convert value "0.02" to type "System.Char". Error: "Invalid cast from 'Double' to 'Char'."""

TerminatingError(Invoke-Expression): "Could not compare "0" to "0.02". Error: "Cannot convert value "0.02" to type "System.Char". Error: "Invalid cast from 'Double' to 'Char'."""
TerminatingError(Invoke-Expression): "Could not compare "0" to "0.02". Error: "Cannot convert value "0.02" to type "System.Char". Error: "Invalid cast from 'Double' to 'Char'."""
TerminatingError(Invoke-Expression): "Could not compare "0" to "0.02". Error: "Cannot convert value "0.02" to type "System.Char". Error: "Invalid cast from 'Double' to 'Char'."""
Invoke-Expression : Could not compare "0" to "0.02". Error: "Cannot convert value "0.02" to type "System.Char". Error:
"Invalid cast from 'Double' to 'Char'.""
At C:\Program Files\PAL\PAL\PAL.ps1:4337 char:9

  •     Invoke-Expression -Command $sCode

  •     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    • CategoryInfo : InvalidOperation: (:) [Invoke-Expression], RuntimeException
    • FullyQualifiedErrorId : ComparisonFailure,Microsoft.PowerShell.Commands.InvokeExpressionCommand
      Invoke-Expression : Could not compare "0" to "0.02". Error: "Cannot convert value "0.02" to type "System.Char". Error:
      "Invalid cast from 'Double' to 'Char'.""
      At C:\Program Files\PAL\PAL\PAL.ps1:4337 char:9
  •     Invoke-Expression -Command $sCode

  •     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    • CategoryInfo : InvalidOperation: (:) [Invoke-Expression], RuntimeException
    • FullyQualifiedErrorId : ComparisonFailure,Microsoft.PowerShell.Commands.InvokeExpressionCommand

Generating the HTML Report...

clinthuffman commented