|Applies To||RSA Product Set: Archer|
RSA Product/Service Type: tblVSelectContent Table
|Issue||Over time the tblIVSelectContent table will grow large in size. The massive size of this table may cause substantial delay in daily DB re-indexing which ultimately leads to DB connection issues while Archer is running.|
The tblIVSelectContent tab basically has information on field_id > Content_id > Select_value_id.
|Resolution||Run the below queries against Archer Instance DB to find the module and field that has the maximum entries in tblIVSelectContent|
select SC.field_id, FD.field_name, COUNT(*) as count1 from tblIVSelectContent SC join tblIVFieldDef FD ON FD.field_id = SC.field_id
The module might be a Test Module into which a lot of test data might have been dumped. Take appropriate action such as deleting unwanted records or the entire module.