search

clinthuffman / PAL

Performance Analysis of Logs (PAL) tool
MIT License
481 stars 101 forks source link

An error occurred on... relog.exe #38

Open JoelAntero opened 5 years ago

JoelAntero commented 5 years ago

Hi, Help please I'm getting the fowlloing error

Overall progress... Status: Preparing counter log(s), PAL 2.8.2 Progress: 24%... Preparing counter log(s),

An error occurred on... relog.exe "C:\Users\Jantero\Desktop\Autitoria_PAN&Past_SQL2012\PAN&past_PAL_Microsoft_SQL_Server_2012.blg" -f csv -o "C:\Users\Jantero\AppData\Local\Temp\b81f8f44-f876-4578-beea-cac447330f4c_FilteredPerfmonLog.csv" -y At line:1 char:1 + relog.exe "C:\Users\Jantero\Desktop\Autitoria_PAN&Past_SQL2012\PAN&pa ... + ~~~~~ The term 'relog.exe' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.

SCRIPT ARGUMENTS: Log: C:\Users\Jantero\Desktop\Autitoria_PAN&Past_SQL2012\PAN&past_PAL_Microsoft_SQL_Server_2012.blg ThresholdFile: C:\Program Files\PAL\PAL\SQLServer2012.xml AnalysisInterval: AUTO IsOutputHtml: $True IsOutputXml: $False HtmlOutputFileName: [LogFileName]_PALANALYSIS[DateTimeStamp].htm XmlOutputFileName: [LogFileName]_PALANALYSIS[DateTimeStamp].xml OutputDir: [My Documents]\PAL Reports AllCounterStats: $False NumberOfThreads: 4 IsLowPriority: $True DisplayReport: True

clinthuffman commented 5 years ago

Hi Joel,

C:\Users\Jantero\Desktop\Autitoria_PAN&Past_SQL2012\PAN&past_PAL_Microsoft_SQL_Server_2012.blg Remove the ampersands (&) from the file name and file path. Ampersand is a special character that Powershell treats differently.

Thank you,

From: JoelAntero notifications@github.com Sent: Friday, February 15, 2019 7:35:07 AM To: clinthuffman/PAL Cc: Subscribed Subject: [clinthuffman/PAL] An error occurred on... relog.exe (#38)

Hi, Help please I'm getting the fowlloing error

Overall progress... Status: Preparing counter log(s), PAL 2.8.2 Progress: 24%... Preparing counter log(s),

An error occurred on... relog.exe "C:\Users\Jantero\Desktop\Autitoria_PAN&Past_SQL2012\PAN&past_PAL_Microsoft_SQL_Server_2012.blg" -f csv -o "C:\Users\Jantero\AppData\Local\Temp\b81f8f44-f876-4578-beea-cac447330f4c_FilteredPerfmonLog.csv" -y At line:1 char:1 + relog.exe "C:\Users\Jantero\Desktop\Autitoria_PAN&Past_SQL2012\PAN&pa ... + ~~~~~ The term 'relog.exe' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.

SCRIPT ARGUMENTS: Log: C:\Users\Jantero\Desktop\Autitoria_PAN&Past_SQL2012\PAN&past_PAL_Microsoft_SQL_Server_2012.blg ThresholdFile: C:\Program Files\PAL\PAL\SQLServer2012.xml AnalysisInterval: AUTO IsOutputHtml: $True IsOutputXml: $False HtmlOutputFileName: [LogFileName]PAL_ANALYSIS[DateTimeStamp].htm XmlOutputFileName: [LogFileName]PAL_ANALYSIS[DateTimeStamp].xml OutputDir: [My Documents]\PAL Reports AllCounterStats: $False NumberOfThreads: 4 IsLowPriority: $True DisplayReport: True

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHubhttps://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fclinthuffman%2FPAL%2Fissues%2F38&data=02%7C01%7C%7C1e5ca47a20c546afaab508d6935b2ba1%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636858417110039024&sdata=eo515%2BoY5jWZOADoPGrM%2FLAcwgzoJYAQ%2FGWs%2BxX9iXc%3D&reserved=0, or mute the threadhttps://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAS48VMXkv9C2anFyY2TjiAOX_aHpHooUks5vNtOrgaJpZM4a946o&data=02%7C01%7C%7C1e5ca47a20c546afaab508d6935b2ba1%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636858417110049029&sdata=764GnXu62vJNJXJxl0tgvyKVKeQ9JJj40Hk7y002blQ%3D&reserved=0.

JoelAntero commented 5 years ago

Hi Clint Huffman, Thank you for your reply :-). Unfortunately it didn't resolve the error

error------- Overall progress... Status: Preparing counter log(s), PAL 2.8.2 Progress: 24%... Preparing counter log(s),

An error occurred on... relog.exe "C:\PerfLogs\PanAndPastPALSQL2012.blg" -f csv -o "C:\Users\Jantero\AppData\Local\Temp\e9fa4d44-ef3f-492e-b34a-f55b2f36584a_FilteredPerfmonLog.csv" -y At line:1 char:1 + relog.exe "C:\PerfLogs\PanAndPastPALSQL2012.blg" -f csv -o "C:\Users\ ... + ~~~~~ The term 'relog.exe' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.

SCRIPT ARGUMENTS: Log: C:\PerfLogs\PanAndPastPALSQL2012.blg ThresholdFile: C:\Program Files\PAL\PAL\SystemOverview.xml AnalysisInterval: AUTO IsOutputHtml: $True IsOutputXml: $False HtmlOutputFileName: [LogFileName]_PALANALYSIS[DateTimeStamp].htm XmlOutputFileName: [LogFileName]_PALANALYSIS[DateTimeStamp].xml OutputDir: [My Documents]\PAL Reports AllCounterStats: $False NumberOfThreads: 4 IsLowPriority: $True DisplayReport: True

Please contact the PAL tool team with this error by posting it to GitHub.com/clinthuffman/PAL. Thank you!

For detailed information, please look at the script execution log at

2nd error------------------------------------------------------------- Overall progress... Status: Getting time data from counter log(s), PAL 2.8.2 Progress: 29%... Getting time data from counter log(s),

An error occurred on... $aRawCounterList = $oCSVFile[0].Split(",") At C:\Program Files\PAL\PAL\PAL.ps1:2145 char:2 + $aRawCounterList = $oCSVFile[0].Split(",") + ~~~~~~~~~~ Cannot index into a null array.

SCRIPT ARGUMENTS: Log: C:\PerfLogs\PanAndPastPALSQL2012.blg ThresholdFile: C:\Program Files\PAL\PAL\SQLServer2008R2.xml AnalysisInterval: AUTO IsOutputHtml: $True IsOutputXml: $False HtmlOutputFileName: [LogFileName]_PALANALYSIS[DateTimeStamp].htm XmlOutputFileName: [LogFileName]_PALANALYSIS[DateTimeStamp].xml OutputDir: [My Documents]\PAL Reports AllCounterStats: $False NumberOfThreads: 4 IsLowPriority: $True DisplayReport: True

Please contact the PAL tool team with this error by posting it to GitHub.com/clinthuffman/PAL. Thank you!

For detailed information, please look at the script execution log at

3rd error-------------------------------------------------- Overall progress... Status: Determining the analysis interval, PAL 2.8.2 Progress: 35%... Determining the analysis interval,

An error occurred on... [datetime] $dtBeginDateTime = $dtBeginDateTime At C:\Program Files\PAL\PAL\PAL.ps1:2166 char:9 + [datetime] $dtBeginDateTime = $dtBeginDateTime + ~~~~~~~~~~ Cannot convert null to type "System.DateTime".

SCRIPT ARGUMENTS: Log: C:\PerfLogs\PanAndPastPALSQL2012.blg ThresholdFile: C:\Program Files\PAL\PAL\SQLServer2008R2.xml AnalysisInterval: AUTO IsOutputHtml: $True IsOutputXml: $False HtmlOutputFileName: [LogFileName]_PALANALYSIS[DateTimeStamp].htm XmlOutputFileName: [LogFileName]_PALANALYSIS[DateTimeStamp].xml OutputDir: [My Documents]\PAL Reports AllCounterStats: $False NumberOfThreads: 4 IsLowPriority: $True DisplayReport: True

4th error ----------------------------------------------------------- Overall progress... Status: Quantizing the analysis interval, PAL 2.8.2 Progress: 53%... Quantizing the analysis interval,

An error occurred on... [datetime] $dTimeCursor = [datetime] $ArrayOfTimes[0] At C:\Program Files\PAL\PAL\PAL.ps1:2557 char:2 + [datetime] $dTimeCursor = [datetime] $ArrayOfTimes[0] + ~~~~~~~~~~~~~ Cannot convert null to type "System.DateTime".

SCRIPT ARGUMENTS: Log: C:\PerfLogs\PanAndPastPALSQL2012.blg ThresholdFile: C:\Program Files\PAL\PAL\SQLServer2008R2.xml AnalysisInterval: AUTO IsOutputHtml: $True IsOutputXml: $False HtmlOutputFileName: [LogFileName]_PALANALYSIS[DateTimeStamp].htm XmlOutputFileName: [LogFileName]_PALANALYSIS[DateTimeStamp].xml OutputDir: [My Documents]\PAL Reports AllCounterStats: $False NumberOfThreads: 4 IsLowPriority: $True DisplayReport: True

5th error---------------------------------------------------- Overall progress... Status: Calculating counter statistics [very CPU intensive]..., PAL 2.8.2 Progress: 65%... Calculating counter statistics [very CPU intensive]...,

An error occurred on... $iPercentComplete = ConvertToDataType $(($iIndexOfJobs / $iTotalJobs) 100) 'integer' At C:\Program Files\PAL\PAL\PAL.ps1:2526 char:49 + ... ete = ConvertToDataType $(($iIndexOfJobs / $iTotalJobs) 100) 'integ ... + ~~~~~~~ Attempted to divide by zero.

SCRIPT ARGUMENTS: Log: C:\PerfLogs\PanAndPastPALSQL2012.blg ThresholdFile: C:\Program Files\PAL\PAL\SQLServer2008R2.xml AnalysisInterval: AUTO IsOutputHtml: $True IsOutputXml: $False HtmlOutputFileName: [LogFileName]_PALANALYSIS[DateTimeStamp].htm XmlOutputFileName: [LogFileName]_PALANALYSIS[DateTimeStamp].xml OutputDir: [My Documents]\PAL Reports AllCounterStats: $False NumberOfThreads: 4 IsLowPriority: $True DisplayReport: True

6th error---------------------------------------------------------- An error occurred on... $Date1 = Get-Date $([datetime]$global:oPal.aTime[0]) -format $global:sDateTimePattern At C:\Program Files\PAL\PAL\PAL.ps1:4701 char:25 + $Date1 = Get-Date $([datetime]$global:oPal.aTime[0]) -format $glo ... + ~~~~~~~ Cannot convert null to type "System.DateTime".

SCRIPT ARGUMENTS: Log: C:\PerfLogs\PanAndPastPALSQL2012.blg ThresholdFile: C:\Program Files\PAL\PAL\SQLServer2008R2.xml AnalysisInterval: AUTO IsOutputHtml: $True IsOutputXml: $False HtmlOutputFileName: [LogFileName]_PALANALYSIS[DateTimeStamp].htm XmlOutputFileName: [LogFileName]_PALANALYSIS[DateTimeStamp].xml OutputDir: [My Documents]\PAL Reports AllCounterStats: $False NumberOfThreads: 4 IsLowPriority: $True DisplayReport: True