Where FN_ADJUSTED_DATE and POPULATE_TIMEZONE are located in AR System after BMC Analytics is EOL

Version 4
    Share This:

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


    PRODUCT:

    BMC Analytics for BSM


    COMPONENT:

    BMC Analytics for BSM


    APPLIES TO:

    Current AR System versions (i.e. 18.05 and newest )



    QUESTION:

     Fn_Adjusted_date cannot be located anymore


    ANSWER:

    Current Remedy AR System versions and BMC Analytics compatibility is not officially tested.
    Due FN_ADJUST _DATE is generated at the time Analytics is installed, and this is not a valid option due above incompatibility event, an AR fix for fn_adjused_date we have introduce for DST they can use it from Analytics.

    RESOLUTION: New Remedy has a FN_ADJUSTED_DATE by execute them from

       
    1. SQL      
           
      1. : \Program Files\BMC Software\ARSystem\artools\arjdbc\MSSQL\Date        
               
        1. PC_POPULATE_TIMEZONE_DDL_MSSQL
        2.      
        3. PC_POPULATE_TIMEZONE_INFO_MSSQL
        4.      
        5. SR_FN_ADJUSTED_DATE_MSSQL
        6.     
      2.   
    2.  
    3. Oracle      
           
      1. :\Program Files\BMC Software\ARSystem\artools\arjdbc\ORACLE\Date        
               
        1. PC_POPULATE_TIMEZONE_DDL_ORA
        2.      
        3. PC_POPULATE_TIMEZONE_INFO_ORA
        4.      
        5. SR_FN_ADJUSTED_DATE_ORA
        6.     
      2.   
       After that You need to execute the FN   
       
    • i.e.: execute [dbo].[POPULATE_TIMEZONE_INFO]
      


      

     


    Article Number:

    000188450


    Article Type:

    FAQ/Procedural



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