TrueSight Server Automation (TSSA): Offline cleanup is not purging data from specific tables

Version 1
    Share This:

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


    BladeLogic Server Automation Suite


    BladeLogic Server Automation


    BSA 8.9.2 and higher


    After running the recommended TrueSight Server Automation (TSSA) database cleanup or offline cleanup, we noticed that some job related tables are not having old data removed:

    job_nsh_param_runtime job_option_value job_nsh_parameter_value



    These tables are part of the cleanupHistoricalData OldVersionJob cleanup


    Offline cleanup does not remove this data.  

    These tables are part of the cleanupHistoricalData OldVersionJob cleanup, added in 8.9.02.  This cleanup is now part of cleanupHistoricalData and can be called explicitly by running:

    blcli Delete cleanupHistoricalData OldVersionJob

    The Data from the above tables will be only deleted if the related Jobs are being deleted from the Environment


    If the job are being created and are not deleted in this scenario nothing will be deleted and the count of the tables will increase


    Please observe the Database Cleanup Job Logs and check if the Jobs is successfully Completed and there are no INFO Message related to skipping objects

    Details about "blcli Delete cleanupHistoricalData OldVersionJob"


    Article Number:


    Article Type:

    Solutions to a Product Problem

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