Cleaning up BSI Document Repository

book

Article ID: 77060

calendar_today

Updated On:

Products

OBLICORE GUARANTEE

Issue/Introduction



How can the Business Service Insight Document Repository be cleaned up? If it gets too full, it can become so slow to display that it times out.
 

Environment

Release:
Component: OBLCRE

Resolution

To clean up these in the database, you'll need to archive a few of the rows of the table T_DOCUMENT_REPOSITORY; there were too many for a prompt response.

To delete the entries, we need to remove them from the following tables. For example taking the ID range of under 1000:

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'll just need to amend those where clauses to reflect the actual IDs you need to scrub.