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 11.3.01.000.10 hotfix before 31 December 2019.
Do the following:
On the server where the TrueSight Operations Management Reporting database is installed, download the Hotfix_113010000010.zip file.
The file is attached in this Knowledge Article .Save the file in a temporary folder and extract all the files.
- 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
- (Oracle)
Was this page helpful? Yes No
Submitting...
Thank you
Comments
Hello ,
We were unable to access KA link to download Hotfix_113010000010.zip. Can you check it for me?
Thanks.
Dear ,
Can the oracle related script be ran by sys or any other dba account ,
not by Report Engine user name and password
Regards
Abhay
Hello Abhay,
Thanks for reaching out.
On Oracle, the schema and the user are the same. Since we need the changes in the Report Engine database schema (Oracle), the script needs to be run by the Report Engine user.
Admin privileges are not required to run the script.
Hope this helps.
Regards,
Mukta
Log in or register to comment.