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
BSA 8.9.02 and below
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.
Defect (QM002399539) - the cleanup script does not pass the value for RETENTION through to the cleanupHistoricalData command called in TYPICAL mode
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]
- 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: