1

Closed

is missing the terminator: error when PAL starts to process BLG file

description

Hi,
 
Have tried this with several different blg's and consistently get the same error. This is what I am submitting :-

Powershell ".\PAL.ps1"
-Log E:\DBA\PAL\BLG's\SIDUV1\PAL_Microsoft_SQL_Server_2005_2008.blg
-ThresholdFile 'C:\Program Files\PAL\PAL\SQLServer.xml'
-Interval 'AUTO'
-IsOutputHtml $True
-HtmlOutputFileName '[LogFileName]_PAL_ANALYSIS_[DateTimeStamp].htm'
-IsOutputXml $False
-XmlOutputFileName '[LogFileName]_PAL_ANALYSIS_[DateTimeStamp].xml'
-OutputDir 'E:\DBA\PAL\Reports'
-AllCounterStats $True
-NumberOfThreads 1
-NumberOfProcessors '16'
-ThreeGBSwitch $False
-SixtyFourBit $True
-TotalMemory '24'
-RAID5Drives 'NULL'
-RAID1Drives 'NULL'
 
This is the error I get :-
 
The string starting:
At line:1 char:526
  • .\PAL.ps1 -Log E:\DBA\PAL\BLG's\SIDUV1\PAL_Microsoft_SQL_Server_2005_2008.blg
    -ThresholdFile 'C:\Program Files\PAL\PAL\SQLServer.xml' -Interval 'AUTO' -IsOu
    tputHtml $True -HtmlOutputFileName '[LogFileName]_PAL_ANALYSIS_[DateTimeStamp].
    htm' -IsOutputXml $False -XmlOutputFileName '[LogFileName]_PAL_ANALYSIS_[DateTi
    meStamp].xml' -AllCounterStats $True -OutputDir 'E:\DBA\PAL\Reports' -NumberOfT
    hreads 1 -NumberOfProcessors '16' -ThreeGBSwitch $False -SixtyFourBit $True -To
    talMemory '24' -RAID5Drives 'NULL' -RAID1Drives 'NULL <<<< '
    is missing the terminator: '.
    At line:1 char:527
  • .\PAL.ps1 -Log E:\DBA\PAL\BLG's\SIDUV1\PAL_Microsoft_SQL_Server_2005_2008.blg
    -ThresholdFile 'C:\Program Files\PAL\PAL\SQLServer.xml' -Interval 'AUTO' -IsOu
    tputHtml $True -HtmlOutputFileName '[LogFileName]_PAL_ANALYSIS_[DateTimeStamp].
    htm' -IsOutputXml $False -XmlOutputFileName '[LogFileName]_PAL_ANALYSIS_[DateTi
    meStamp].xml' -AllCounterStats $True -OutputDir 'E:\DBA\PAL\Reports' -NumberOfT
    hreads 1 -NumberOfProcessors '16' -ThreeGBSwitch $False -SixtyFourBit $True -To
    talMemory '24' -RAID5Drives 'NULL' -RAID1Drives 'NULL' <<<<
    • CategoryInfo : ParserError: (:String) [], ParentContainsErrorRe
      cordException
    • FullyQualifiedErrorId : TerminatorExpectedAtEndOfString

file attachments

Closed Jun 21, 2012 at 7:51 AM by ClintH
The user removed the single quote from the file path which was being interpreted as a literal string in PowerShell.

comments

ClintH wrote Jun 18, 2012 at 11:15 PM

The single quote in your log path is being interpreted by PowerShell as a literal quote. Please use file paths that do not include single quotes.

ClintH wrote Jun 18, 2012 at 11:17 PM

Please let me know if removing the single quote from the path resolves this issue. Thank you.

ParmG wrote Jun 19, 2012 at 4:15 PM

Hi Clint,

The single quote in the path was the problem. Once I removed the quote, it all worked fine.

Thanks for your help. Please close the call.

ClintH wrote Jun 21, 2012 at 7:50 AM

Great! Thank you for letting me know that it worked. :-)