SQL Monitor has stopped emailing after license activation
gslick
Posts: 3
Hi,
We where using SQL Monitor 2 and everything was working fine, the trial ran out, and it stopped emailing alerts.
We purchased the correct amount of licenses for our server and the status of the Host and SQL Instance both say 'OK' but when alerts that should happen are triggered, an email is not sent out and the alert in not raised in SQL Monitor 2.
It was working perfectly before the trial period ran out and have checked our email address (test email works and have reset everything back to default settings and also unlicensed the re-licensed the servers using the tab), it just has stopped monitoring.
I looked in the Base Monitor log and there is this error message
2011-10-07 09:02:25,722 [ 27] WARN RedGate.Response.Common.SmartAssembly.HeadlessUnhandledExceptionHandler - Error reporting is disabled.
2011-10-07 09:02:33,538 [ 45] WARN RedGate.Response.Common.Utilities.Scheduling.JobRunner - Unhandled exception in job run: JobRef(DataCollectionScheduler:Root[].[Cluster][[Name]=sql1].[Machine][[Name]=], IntervalJobSchedule(00:00:15))
System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "Cluster_Machine_LogicalDisk_UnstableSamples_Cluster_Machine_LogicalDisk_Keys". The conflict occurred in database "RedGateMonitor", table "data.Cluster_Machine_LogicalDisk_Keys", column 'Id'.
The statement has been terminated.
Can anybody help ?
We where using SQL Monitor 2 and everything was working fine, the trial ran out, and it stopped emailing alerts.
We purchased the correct amount of licenses for our server and the status of the Host and SQL Instance both say 'OK' but when alerts that should happen are triggered, an email is not sent out and the alert in not raised in SQL Monitor 2.
It was working perfectly before the trial period ran out and have checked our email address (test email works and have reset everything back to default settings and also unlicensed the re-licensed the servers using the tab), it just has stopped monitoring.
I looked in the Base Monitor log and there is this error message
2011-10-07 09:02:25,722 [ 27] WARN RedGate.Response.Common.SmartAssembly.HeadlessUnhandledExceptionHandler - Error reporting is disabled.
2011-10-07 09:02:33,538 [ 45] WARN RedGate.Response.Common.Utilities.Scheduling.JobRunner - Unhandled exception in job run: JobRef(DataCollectionScheduler:Root[].[Cluster][[Name]=sql1].[Machine][[Name]=], IntervalJobSchedule(00:00:15))
System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "Cluster_Machine_LogicalDisk_UnstableSamples_Cluster_Machine_LogicalDisk_Keys". The conflict occurred in database "RedGateMonitor", table "data.Cluster_Machine_LogicalDisk_Keys", column 'Id'.
The statement has been terminated.
Can anybody help ?
Comments
Please do contact us if you need our help and assistance in the future.
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com