In Strategy Intelligence Server 9.0.2, the scheduled administrative task 'Clean History List database' has been introduced.
Below is a list of the operations performed by this task:
Cleans up orphaned rows in the DSSCSCONTENT and DSSCSRPTCACH (new table introduced in Strategy Intelligence Server 9.2.0) table when the Caches for the History List message is deleted first and then History list message itself is deleted from the remote node (cleanup report cache orphan row)
Cleans up History list for those users deleted from Metadata. The old methods of History List deletion (Message Lifetime, Scheduled task) are based on the user being present in the Metadata. It is always possible for a user object to be deleted in 2- tier, without the users History List being cleared, or an administrator may delete a user from the Metadata without remembering to clear the users History List messaged as well. In this scenario, the users History List message will remain on disk and the associated “History” cache will never be deleted.
Cleans up History List for those projects deleted from the metadata.
