Cleanup Document Repository

Products

• CA Business Service Insight

Issue/Introduction

How can the CA Business Service Insight Document Repository be cleaned up?
 

Environment

CA Business Service Insight 8.3.x and 9.x

Resolution

The BSI document repository needs to be cleaned via the BSI database.

As always, use extreme caution when deleting data from the BSI database and ensure that you have a valid database backup.

You will need to archive rows in the tables t_document_repository, t_rpt_usr_group_permissions and t_report_galleries

For example, taking the ID range of under 1000 the following queries need to be executed:

delete from t_rpt_usr_group_permissions u where u.report_id in ( select g.report_id from t_report_galleries g where g.document_id < '1000') ;
delete from t_report_galleries where document_id < '1000';
delete from t_document_repository where document_id < '1000';

You need to amend those where clauses to reflect the actual IDs to be deleted.