Preparing to upgrade TrueSight Server Automation - Data Warehouse


Where you are in the Upgrade process

Preparing to upgrade TrueSight Server Automation - Data Warehouse

Upgrading TrueSight Server Automation - Data Warehouse requires you to complete various pre-upgrade tasks. Do the following:

  1. Download the product files from the BMC Electronic Product Distribution (EPD) location:TrueSight Server Automation - Data Warehouse 
  2. Review the System-requirements-for-TrueSight-Server-Automation-Data-Warehouse.
  3. Ensure that you are upgrading from one of the versions supported by upgrade paths.
  4. Ensure that all extract, transform, and load (ETL) runs have completed and that ETL is not running. For more information, see Viewing-the-ETL-status.
  5. Ensure that you have disabled the NSH proxy on the reports server to avoid failure during upgrade. To disable the NSH proxy, run the following command on the NSH client:

    secadmin -m default -p 5 -appserver_protocol clear -T encryption_only -e tls

    This command removes the appserver_protocol=ssoproxy entry from the default line in the secure file (in the rsc folder).

    Important

    After the upgrade completes, remember to add this entry back into the secure file. Use the following command to add the entry:

    secadmin -m default -p 5 -appserver_protocol ssoproxy
  6. Back up the following:

    Artifact

    Files to back up

    Databases

    • Reports data warehouse
    • TrueSight Smart Reporting - Platform repository database

    User roles and permissions related file 

    The user_roles.csv file at the following path:
    <tssadw_installation_directory>\shared\ConfigurationManagement\

  7. Enter the following command to rename the alias as applicable:
    1. If you have imported the TrueSight Smart Reporting - Platform certificate with the alias name other than smartreporting:

      keytool -changealias -alias "<existing_alias_name>" -destalias "smartreporting" -keystore <tssadw_installation_directory>/jre/lib/security/cacerts
    2. If you have RSSO authentication configured and imported the rsso certificate with alias name other than rsso:

      keytool -changealias -alias "<existing_alias_name>" -destalias "rsso" -keystore <tssadw_installation_directory>/jre/lib/security/cacerts
  8. Restart the following services:
    • TrueSight Server Automation - Data Warehouse
    • Authentication Service


Where to go from here

Depending on your environment, upgrade TrueSight Server Automation - Data Warehouse by using one of the following options:

 

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