Preparing to upgrade TrueSight Server Automation - Data Warehouse

Where you are in the Upgrade process

1.Prepare for the upgrade (You are here)

Upgrade TrueSight Server Automation - Data Warehouse

3.Complete the post-upgrade activities

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. (For SQL Server only) Ensure that you have assigned the dbcreator role to the following database users:

    • ETL Master repository user. The default is TSSSADW_ETL_MASTER.
    • ETL Work repository user. The default is TSSSADW_ETL_WORK.
  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. Back up the following databases:

    • Reports data warehouse
    • ETL Master repository 
    • ETL Work repository 
    • TrueSight Smart Reporting - Platform repository database
  6. Back up the following files depending on the authentication types that are used:

    Authentication typeFiles to be backed up
    Domain authentication
    • <TSSA-DWInstallationDirectory>/br/blappserv_login.conf 
    • <TSSA-DWInstallationDirectory>/br/blappserv_krb5.conf
    LDAP authentication


    RSA SecurID authentication


  7. If you have custom certificates, ensure that your files are not overwritten by the upgrade process. For more information, see  Implementing private certificates in TrueSight Smart Reporting.

  8. Close all the files and folders opened in the current sessions. Also, close other user sessions on the server before starting the upgrade.

  9. Disable all the authentications that you configured:
    1. On the reports server, start the Application Server Administration console (the blasadmin utility) as follows.
      • (Windows) Navigate to the <TSSA-DWInstallationDirectory>\bin directory and enter the following command: blasadmin.exe
      • (UNIX) Navigate to the <TSSA-DWInstallationDirectory>/br directory and enter the following command: ./blasadmin
    2. Disable the authentications that you are using by running the following commands:

      Authentication typeCommand to disable the authentication
      Domainset AuthServer isDomainAuthEnabled false
      RSA Secure IDset AuthServer IsSecurIDAuthEnabled false
      LDAPset AuthServer IsLdapAuthEnabled false
      PKIset PkiAuth IsEnabled false

      For more information about the authentication types, see Implementing authentication.

  10. (For PKI authentication) Back up .jks or PKI truststore file that is available at the following path, and then remove this file from this path:

Where to go from here:

Upgrade TrueSight Server Automation - Data Warehouse using one of the following options:

Was this page helpful? Yes No Submitting... Thank you


  1. Drew Trachy

    I have 19.01 GA installed. Neither of the files mentioned in steps 7a/7b exist anywhere in the installation.

    Jul 22, 2019 11:48