Notification of a critical issue with database cleanup in SQL Server installations


BMC Software is alerting users of TrueSight Server Automation 21.02.01 to a critical issue that occurs with the JobRunEvent data during database cleanup on Microsoft SQL Server databases.

Problem

After you upgrade to version 21.02.01 and run database cleanup, the JobRunEvent data newer than the specified retention time is incorrectly deleted.

Notes

  • Data other than the JobRunEvent data is not affected.
  • This problem does not affect fresh installations of version 21.02.01.
  • This problem does not affect version 21.02.
  • This problem does not affect installations that use Oracle as the database backend.

Mitigation

The TrueSight Server Automation 21.02.01 installers on the Electronic Product Distribution (EPD) site have been replaced with the updated installers, as shown in the following table. The table also includes MD5 or SHA256 checksum results that you can verify before installation.

File

MD5 Checksum

SHA256 Checksum

Installers updated on

TSSA210201-WIN64.zip

593c2868334457b16fa9290401ed5e9e

1180b0e9a348fed66a6875f1d8f891ab8f4592b9e2001ce60cd648552db93f7a

July 15, 2021

TSSA210201-WIN32.zip

0afd0fe29e00aa9320f7bc19b53e14c6

d17cc99d28eadd58f550906c54aced72740d314b3d1848839b646faf1f55901c

July 15, 2021

TSSA210201-LIN64.zip

249fd10b9900914cdf6421e18ca45f4f

6a0ccba0854fd7ea05dbee0fb79fb6cbf3d24c80cb4bd610a359a010751e2305

July 22, 2021


Do one the following depending on when you downloaded the installers and whether you used them for upgrading:

  • If you have downloaded installers before the date listed in the Installers updated on column, and have not already used them for upgrading your installation, download the updated installers from EPD and use them for upgrade.
  • If you have downloaded installers before the date listed Installers updated on column, and already used them for upgrading your installation, contact BMC Support for a hotfix.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*