TrueSight Capacity Optimization (TSCO): how can one set an aging parameter for Reports cleanup? INCLUDES VIDEO

Knowledge Article

Article Number

000306828

Old Article Number

000097301

Article Type

Solutions to a Product Problem

Title

TrueSight Capacity Optimization (TSCO): how can one set an aging parameter for Reports cleanup? INCLUDES VIDEO

Summary

In TSCO how can one set an aging parameter for Reports cleanup?

Product

TrueSight Capacity Optimization

Component

Capacity Optimization 11.5.01

Applies to

TrueSight Capacity Optimization 20.02, 11.5, 11.3.01, 11.0, 10.7, 10.5, 10.3, 10.0

Problem

In TrueSight Capacity Optimization (TSCO) how can one set an aging parameter for Reports cleanup? We need to setup repository cleanup for the report results, to prevent our report repository from reaching 100% full on the file system.

Cause

Solution

This article describes how to set reports retention and how to automatically delete old reports.

Steps for TrueSight Capacity Optimization (TSCO) versions 11.3 and later

By default the last 100 report results are ALWAYS retained for each report.

You can verify and change this setting from:

· Administration >
· ETL & SYSTEM TASKS >
· System tasks >
· Database Cleaner

Edit the Database Cleaner task run configuration and check the "report aging" parameter setting (see below screenshot for guidance).

Be careful when changing the report retention parameter into the database cleaner task, since this acts GLOBALLY on all report results, so other stakeholders could be interested in higher report results retention.

User-added image

For TrueSight Capacity Optimization versions 11.0 and earlier

Note: This article works on TrueSight Capacity Optimization 10.0 only if you have installed CHF4 for CP1 or newer CHF
This solution works for both TSCO instance running on an Oracle DB and on Postgres

1. Preliminary steps

Edit the "Database Cleaner" in TSCO system tasks

Verify if it's part of the "maintenance activity chain", if so select the chain and unschedule it

Go back to the "Database Cleaner" configuration page and edit its run configuration in Advanced mode

2. Adding the custom cleanup queries into Database Cleaner task Run confguration

Add the following 2 properties to the Database Cleaner Task, replacing "100" with the desired number results you want to keep for each report:

For StandardReport.custom.query entry Value is:

DELETE FROM rep_result t1 WHERE (repid, rundate) IN (SELECT repid, rundate FROM (SELECT t2.repid, t2.rundate, ROW_NUMBER () OVER (PARTITION BY repid ORDER BY rundate DESC) RANK FROM rep_result t2) WHERE RANK > 100)

For StandardReportProps.custom.query entry Value is:

DELETE FROM rep_result_props t1 WHERE (repid, rundate) IN (SELECT repid, rundate FROM (SELECT t2.repid, t2.rundate, ROW_NUMBER () OVER (PARTITION BY repid ORDER BY rundate DESC) RANK FROM rep_result t2) WHERE RANK > 100)

3. Enabling the custom cleanup queries (changes for BCO 9.X)

Append the following string to the query.name.list property of the Database Cleaner Task to remove the reports out of the RANK from the database:

;StandardReportProps;StandardReport

3. Enabling the custom cleanup queries (changes for TSCO 10.0 CP1 CHF4 or 10.3 or 10.5 or 10.7)

Add the following property to the Database Cleaner Task:additional.tables

Append the following string to the additional.tables property of the Database Cleaner Task to remove the reports out of the RANK from the database:

StandardReportProps;StandardReport

4. Final steps

Save the run configuration
Go back into the Maintenance activity chain and reschedule it

How To Video

Attachment(s):