TrueSight Operations Management Reporting Updating Daylight-saving information in the Reporting database for the year 2020 and later

Version 24
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    TrueSight Operations Management Reporting


    COMPONENT:

    TrueSight Operations Management Reporting


    APPLIES TO:

    TrueSight Operations Management Reporting 10.7, 11.3.x version



    PROBLEM:

    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 attached hotfix before 31 December 2019. Do the following:

       
    1. Depending on the TrueSight Operations Management Reporting version that you are using, download and extract one of the following hotfix files:     
           
      • Version 9.5: readme_TSOM_Reporting_950200010
      •    
      • Version 9.6: readme_TSOM_Reporting_9600000010
      •    
      • Version 10.0: readme_TSOM_Reporting_1000000010
      •    
      • Version 10.7: readme_TSOM_Reporting_1070000010
      •    
      • Version 11.3.01: readme_TSOM_Reporting_1130100010
      •    
      • Save the file in a temporary folder and extract all the files.
      •   
    2.  
    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
      •   

     


    Article Number:

    000175257


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles