Adding daylight saving information in the Reporting database

The TrueSight Operations Management Reporting database does not contain information about daylight saving for the period after 31 December 2019. This might cause the following issues:

• Data would not be available in the hourly and daily data tables in the Reporting database.
• Daylight saving time would not be calculated, which would result in an incorrect time difference.

Solution

To resolve this issue, install the 10.7.000.10 hotfix before 31 December 2019.

Do the following:

1. On the server where the TrueSight Operations Management Reporting database is installed, download the Hotfix_1070000010.zip file.
   The file is attached in  this Knowledge Article .

2. Save the file in a temporary folder and extract all the files.

3. Connect to the TrueSight Operations Management Reporting database with the Report Engine user name and password and run the following command:
   • (Oracle) rpt_timezone_oracle.sql
   • (SQL Server) rpt_timezone_mssql.sql