Cleaning up BSI Document Repository
Article ID: 77060
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
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.
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.
Feedback
Powered by
