1

Closed

Start PAL over Powershell - Error

description

Hello,
I have installed PAL v2.3.
No i have manuell create a pal job, it is working fine.
When i wan't to start this command over Powershell_ISE, i get an error.
 
Command:
 
cls
cd 'C:\Program Files\PAL\PAL'
 
Powershell ".\PAL.ps1" -Log 'O:\PerfLogs\SQL\SQL_PRE101_2012053121.blg'
-ThresholdFile 'C:\Program Files\PAL\PAL\SQLServer.xml' -Interval 'AUTO' -IsOutputHtml $True
-HtmlOutputFileName 'SQL_PRE101_RushHour_normalBusiness.htm' -IsOutputXml $False -XmlOutputFileName '[LogFileName]_PAL_ANALYSIS_[DateTimeStamp].xml'
-OutputDir 'C:\Users\xyz\Documents\PAL Reports\Loadtest' -AllCounterStats $False -NumberOfThreads 1 -NumberOfProcessors '8'
-ThreeGBSwitch $False -SixtyFourBit $True -TotalMemory '32' -RAID5Drives 'd,E,F,L,M,N' -RAID1Drives 'NULL'
-BeginTime '01.06.2012 07:45:00' -EndTime '01.06.2012 08:30:00'
 
Error:
 
Transcript started, output file is C:\Users\YADWUT~1\AppData\Local\Temp\2\PAL1.
log
PAL v2.3 (http://www.codeplex.com/PAL)
Written by: Clint Huffman (clinth@microsoft.com) and other contributors.
Last Modified: 05/04/2012 10:51:10
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 respon
sibility for damages or losses incurred by use of this tool.
 
Your locale is set to: German (Germany)
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.
powershell.exe : Method invocation failed because [System.Int32] doesn't contain a method named
At C:\Users\xyz\Desktop\PAL_Aufruf_2.ps1:5 char:11
  • Powershell <<<< ".\PAL.ps1" `
    • CategoryInfo : NotSpecified: (Method invocati...a method named :String) [], RemoteException
    • FullyQualifiedErrorId : NativeCommandError
       
       
      How can i start a pal job over PS_Ise or normal PS window?
      I hope, somebody can help me,
      Horst
Closed Oct 3, 2013 at 6:16 PM by ClintH

comments

ClintH wrote Jun 4, 2012 at 7:59 AM

Yes, you should be able to run PAL.ps1 by itself in PowerShell ISE or at a PowerShell command prompt, but you have to disable the Transcript first. Comment out the line starting with StartDebugLogFile in the Main() function and comment out the StopDebugLogFile line in the Main() function. This will allow the debugger to debug it in the ISE.
With that said, it looks like you are getting an error with the parameters you passed in. Try using the PAL Wizard first, then using the batch file that it creates as a start.
Unfortunately, PAL only works with English locales. This is due to how the strings are compared between the counter log and the threshold files. Try setting your desktop to an English locale.
Also, the single tick (`) characters at the end of each line might be causing a problem. Try removing them.
Finally, the begin time and end times are odd because they have periods in them. Try using dashes like this '01-06-2012 07:45AM'.