Event removal through the DB

Products

• CA Business Service Insight

Issue/Introduction

How to identify and remove corrupt/incorrect events for a metric.

Environment

Release:  8.3.5
Component: CA Business Service Insight

Resolution

The best, simplest, safest and fully-supported way to remove an event is through the UI.

However, if for some reason that is not possible, then the event is stored in two tables: t_raw_data and t_raw_data_changes

What is required  is identify the row or rows in t_raw_data that are the problem. If you can see the "problem" event(s) in the UI, you should be able to get the values for time_stamp, create_date, modify_date and resource_id, in order to pick it, though the data column itself isn't human-readable. Make a note of the raw_data_id before you do so, however, as you'll need to clean the related rows in t_raw_data_changes with the same raw_data_id as well, to maintain consistency.