Deleting data from t_raw_data table

Products

• CA Business Service Insight

Issue/Introduction

How to delete some problematic records from t_raw_data table?

Environment

CA Business Service Insight 8.3.x and 9.x

Resolution

Note that the records in the t_raw_data table are encapsulated. You can read the encapsulated "info" for events in this table using the Oracle database function FNC_DATA_FIELD_EXTRACT.  Consult with your Oracle DBA for further assistance.

There are a couple of approaches:

1.  RECOMMENDED Delete records through the UI. This will clear out everything for that event. 

2.  Stop the BSI services and then delete the records in the t_raw_data table based on some criteria. Y

Here is an example to delete all records from a particular adapter
=========================================================================== 
1. Get the Adapter ID by running the query:

Select * from t_readers 

2. Find the Adapter ID according to the adapter name.

3. Check the records in t_raw_data table by running this query:

select * from t_raw_data where reader_id = xx  (where xx is the adapter id) 

4.  Verify that these are the raw data events from the Adapter. Look at the timestamp, resource and event type fields. 

Make sure that you use the right Adapter ID and do not delete raw data events from another adapter. 

5. Delete the records from t_raw_data table by running this query

Delete from t_raw_data where reader_id = xx (where xx is the adapter id)

6.  Commit the transaction