TrueSight Server Automation (TSSA): Recommended Database Cleanup Job run in TYPICAL mode does not honor the retention parameter thus causing more data being removed

Version 18
    Share This:

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


    PRODUCT:

    BladeLogic Server Automation Suite


    APPLIES TO:

    BSA 8.9.02 and below



    PROBLEM:

    After running the Recommended Database Cleanup Job in TYPICAL mode with a large Retention time configured, observed that more data (Job Run Logs, Audit Trail, Job Schedule) were removed than expected.
     


    CAUSE:

    Defect (QM002399539) - the cleanup script does not pass the value for RETENTION through to the cleanupHistoricalData command called in TYPICAL mode


    SOLUTION:

    The defect was logged for this behavior (QM002399539), which has been fixed after 8.9.03.

    The attached fixed script can be used with all TSSA versions.

    [md5sum of the script file]
    21182e0e4fe30e216eb34d94128237d1    DB_and_FS_Cleanup.nsh

    NOTE:
    - Upgraded environments might still contain older version of the cleanup script so make sure to check the md5sum of the file and replace with the updated script
    - In order to find the script location, please open the database cleanup script depot object in TSSA console to check the "File location" as below:

    cleanup script


    Article Number:

    000156089


    Article Type:

    Solutions to a Product Problem



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