DocumentData table size increases in Smart Reporting DB

Version 2
    Share:|

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Remedy AR System Server


    APPLIES TO:

    Smart Reporting 9.1



    PROBLEM:

    Smart Reporting DB is consuming huge space. DocumentData under Smart Reporting DB is the most consuming Table


    SOLUTION:

    We have settings in Smart Reporting application for configuring the report caching in from report/content categories, which shall help to only cache the contents for the latest result set and not based on results which are archived over the period.

    Navigate to the Smart reporting using Report Admin User :

    Administrator -> Admin Console -> Content Categories -> Navigate to the respective Report category , For example : Click on Change Management

    Navigate to the Report Version History -> and select the Version History option to "Only keep the latest result set", click on Save

    Once this option is set for all the identified categories, then whenever the system cleanup task runs overnight, it should purge automatically.

    Please note that this may be quite overhead on DB transaction log , please make sure you have DB setting in place to take care of this"

     


    Article Number:

    000128354


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles