Article Content
Article Number | 000030524 |
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 tblIVSelectContentselect 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. |