PolyMon RC2 has been released

Topics: News & Releases
Coordinator
Dec 27, 2006 at 5:02 PM
RC2 has been released.

RC2 updates include:
- Various stabilizations (bug fixes!)
- Database install scripts for both SQL 2000 and SQL 2005
- Various database optimizations (indexes, stored procs)
- Visual enhancements
- Enhanced URL (HTML) and File monitors and new URL (XML) and TCP Port monitors.
Jan 4, 2007 at 5:55 PM
Hi,

Just downloaded & installed RC2 source - Note there is an issue with the updowntimecalculation trigger on dbo.monitorevent. - With empty db table, this throws divide by 0 exception in both Monitor & Exec. - traced this back to :

--UpDownTimeSecs
update MonitorEvent
set UpDownTimeSecs = coalesce(datediff(ss, dbo.fn_PrevEventDT(@MonitorID, EventID), @CurrEventDT) * @FailMult,0)
where EventID=@CurrEventID


As workaround, disable this trigger in SQL Management studio until all defined monitors have run at least once, then reenable.

Perhaps add to the fix list ?

Regards

Simon Birchall
Coordinator
Jan 5, 2007 at 12:10 PM
This discussion has been copied to Work Item 7030. You may wish to continue further discussion there.
Coordinator
Jan 5, 2007 at 12:12 PM
Thanks for bringing this up. I will fix this for the upcoming RC3 release.
In the meantime this can be fixed manually by modifying the SQL trigger on MonitorEvent as follows:

Replace the UpDownTimeSecs block with the following code:
-------------------------------------------------------------
--UpDownTimeSecs
if exists(select * from MonitorEvent where MonitorID=@MonitorID and EventID <> @CurrEventID)
begin
update MonitorEvent
set UpDownTimeSecs = coalesce(datediff(ss, dbo.fn_PrevEventDT(@MonitorID, EventID), @CurrEventDT) * @FailMult,0)
where EventID=@CurrEventID
end
-------------------------------------------------------------

Thanks,
Fred.