1
Vote

While processing the counters I keep getting this error (nvokeExpressionCommand)

description

Error0_PAL.htm
Test-Path : Cannot retrieve the dynamic parameters for the cmdlet. The specifie
d wildcard pattern is not valid: [Gen_Svr_09_Prod__PAL_ANALYSIS_2016122323553
8
At C:\Program Files\PAL\PAL\PAL.ps1:2771 char:37
  • $bFileExists = Test-Path <<<< -Path $sFilePath
    • CategoryInfo : InvalidArgument: (:) [Test-Path], ParameterBindi
      ngException
    • FullyQualifiedErrorId : GetDynamicParametersException,Microsoft.PowerShe
      ll.Commands.TestPathCommand
Processing Thresholds...
 SQLServer:Buffer Manager Buffer cache hit ratio
 SQLServer:Buffer Manager Free pages
 SQLServer:Buffer Manager Lazy writes/sec
 SQLServer:Buffer Manager Page life expectancy
 SQLServer:Buffer Manager Page lookups/sec
 SQLServer:Buffer Manager Page reads/sec
 SQLServer:Buffer Manager Page writes/sec
 SQLServer:General Statistics Logins/sec
 SQLServer:General Statistics Logouts/sec
 SQLServer:General Statistics User Connections
 SQLServer:Memory Manager Memory Grants Pending
 SQLServer:SQL Statistics Batch Requests/sec
 SQLServer:SQL Statistics SQL Compilations/sec
 SQLServer:SQL Statistics SQL Re-Compilations/sec
 SQLServer:Memory Manager Memory Grants Outstanding
 SQLServer:Memory Manager\Granted Workspace Memory  Granted Workspace Memory (KB)
 SQLServer:Memory Manager\Maximum Workspace Memory  Maximum Workspace Memory (KB)
 SQLServer:SQL Statistics Auto-Param Attempts/sec
 SQLServer:SQL Statistics Failed Auto-Params/sec
 SQLServer:SQL Statistics Safe Auto-Params/sec
 SQLServer:SQL Statistics Unsafe Auto-Params/sec
 SQLServer:Buffer Manager Free list stalls/sec
 SQLServer:Buffer Manager Checkpoint pages/sec
 SQLServer:Buffer Manager Readahead pages/sec
 SQLServer:Buffer Manager Stolen pages
 SQLServer:SQL Statistics SQL Attention rate
 SQLServer:Transactions\Free Space in tempdb  Free Space in tempdb (KB)
 SQLServer:Transactions Longest Transaction Running Time
 SQLServer:Transactions NonSnapshot Version Transactions
 SQLServer:Transactions Snapshot Transactions
 SQLServer:Transactions\Version Cleanup rate  Version Cleanup rate (KB/s)
 SQLServer:Transactions\Version Generation rate  Version Generation rate (KB/s)
 SQLServer:SQL Plan Re-Use Rate
 Memory Available MBytes
 Processor % Processor Time
 Processor % Privileged Time
 Network Interface % Network Utilization
 Network Interface Output Queue Length
 Network Interface % Network Utilization Sent
 Network Interface % Network Utilization Received
 System Processor Queue Length
 PhysicalDisk Read Latency Analysis
 PhysicalDisk Write Latency Analysis
 Paging File % Usage
 Network Interface Packets Outbound Errors
 PhysicalDisk Current Disk Queue Length
 PhysicalDisk Avg. Disk Queue Length
 Network Interface Bytes Total/sec
 PhysicalDisk Disk Bytes/sec
 Network Interface Current Bandwidth
 Network Interface Packets/sec
 Network Interface Packets Sent/sec
 Network Interface Packets Received/sec
Generating the HTML Report...C:\Users\amitsa\Documents\PAL Reports\Gen_Svr_09_prod_12_23_System_Monitor_Log
Error0_PAL.htm
The specified wildcard pattern is not valid: [Gen_Svr_09_Prod__PAL_ANALYSIS_2
0161223235538.htm
At C:\Program Files\PAL\PAL\PAL.ps1:4587 char:15
  • '<HTML>' > <<<< $h
    • CategoryInfo : NotSpecified: (:) [], WildcardPatternException
    • FullyQualifiedErrorId : RuntimeException
C:\Users\amitsa\Documents\PAL Reports[Gen_Svr_09_Prod__PAL_ANALYSIS_201612232
35538.htm
C:\Users\amitsa\Documents\PAL Reports\Gen_Svr_09_prod_12_23_System_Monitor_Log
Error0_PAL.htm
Invoke-Expression : The specified wildcard pattern is not valid: [Gen_Svr_09_
Prod__PAL_ANALYSIS_20161223235538.htm
At C:\Program Files\PAL\PAL\PAL.ps1:5255 char:22
  • Invoke-Expression <<<< -Command "&'$HtmlOutputFileName'"
    • CategoryInfo : NotSpecified: (:) [Invoke-Expression], WildcardP
      atternException
    • FullyQualifiedErrorId : RuntimeException,Microsoft.PowerShell.Commands.I
      nvokeExpressionCommand

Windows PowerShell Transcript End
End time: 20161224001734

comments

amitsa wrote Jan 1 at 7:54 PM

Found and resolved the issue! On the FileOutput screen of the wizard, I was inputting server name in the LogFileName placeholder. [LogFileName]_PAL_ANALYSIS_[DateTimeStamp].htm. I stopped doing that and kept the default and the issue stopped resurfacing.