Divide by Zero error

Jan 19, 2017 at 2:05 PM
I have been running PAL to generate the charts for CPU based process logs, it runs till last min and crashes mentioning divide by zero, Can someone please throw some light on how to fix it.
Feb 1, 2017 at 9:19 PM
Edited Feb 1, 2017 at 9:26 PM
I have the same issue.

PAL 2.7.7

2 hour PAL SQL Server Profile trace as input.

During the generation of the ...PAL Reports\PAL_Microsoft_SQL_Server_2012Error0_PAL.htm file, I recieve the following error.

Note: the file being processed by PAL can successfully be opened by SQL Profiler.

"Attempted to divide by zero.
...Program Files\PAL\PAL\PAL.ps1:2293 char:49
$iPercentComplete = COnvertToDatType $(($iIndexOfJobs / $iTotalJobs) * ...
CategoryInfo : NotSpecified: (:) [], RuntimeException
FullyQualifiedErrorId : RuntimeException

Hope someone can help :-)
Feb 1, 2017 at 10:33 PM
It seems on the "Threshold file" tab of PAL I had specified an incompatible template.

If I capture SQL Server Counters and specify "Microsoft SQL Server 2012" as the Threshold file title from the drop down box everything works and the report is nicely produced.

A Team Mate pointed this out to me and saved the day ..... thank god for Team Mates :-)

Hope this helps someone :-)