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.


    Remedy AR System Server


    Smart Reporting Remedy


    Smart Reporting 9.1


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



    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
    3. Admin Console > Content Categories > Navigate to the respective Report category Eg. Change Management
    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:


    Article Type:

    Solutions to a Product Problem

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