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 ?
I just restared the Base Monitor service and everything is working now.
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 ?