Remedy Smart Reporting - DocumentData table size increases in the repository database

Version 2
    Share This:

    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


    COMPONENT:

    Smart Reporting Remedy


    APPLIES TO:

    Smart Reporting 9.1



    PROBLEM:

    Smart Reporting DB is consuming disk space.
    The 
    DocumentData table appears to be the culprit.


    SOLUTION:

     

    There is a setting in Smart Reporting to configure report caching that allows the user to keep the latest result sets, instead of of the complete set archived over a period.

      
       
    1. Login to the Smart Reporting using a Report Admin User
    2.  
    3. Admin Console > Content Categories > Navigate to the respective Report category Eg. Change Management
    4.  
    5. Navigate to Report Version History > Select the Version History option to "Only keep the latest result set" > Click Save
       Note: Once this option is set for all the identified categories, the system cleanup task will run overnight and purge the old results set automatically.
    Please note that this may be cause some overhead on DB transaction log, so please ensure you have a 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