Deleting em_alert records creates difficult to remove orphaned records in EM DashboardDescriptionWhen Alert records are deleted, these are not removed from the Event Management dashboard. Clicking on their link on the EM Dashboard redirects to a non existing URL, since the record no longer exists. The EM Dashboard does not ever remove these Alerts because it references em_alert_history, which links through to em_alert. The alerts are only flushed from the EM Dashboard when the "Active Alert End Time" field exceeds the current date time. Since the alert record is deleted, the timestamp value is never automatically updated, hence leading to the Alert remaining in the Dashboard indefinitely. Steps to Reproduce 1 - Create active Alerts.2 - View them on the EM Dashboard.3 - Delete an Alert record.Note that the deleted Alert does not actually go away, and clicking on it leads to an unavailable URL link. WorkaroundAfter carefully considering the severity and frequency of the issue, and the cost and risk of attempting a fix, it has been decided to not address this issue in any current or near future releases. We do not make these decisions lightly, and we apologize for any inconvenience. As a workaround, update the "Active Alert End Time" field for the orphaned em_alert_history records to be a date-time in the past. A Business Rule on the em_alert table is triggered when a record is being deleted, to update the alert in em_alert_history setting vt_end to the current date time. In addition, any option has been removed from the UI to delete alerts that are not in closed state. Once closed, the only role that has permission to delete alerts is em_admin.The only way an alert can get stuck in the dashboard is if some script did a bulk delete (not recommended) and the expected Business Rule rules did not run. If needed to delete alerts in bulk, these should first be closed in bulk, then after the impact job has updated the vt_end, the alerts can be deleted in bulk.Related Problem: PRB1304612