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 all extract, transform, and load (ETL) runs have completed and that ETL is not running. For more information, see Viewing the ETL status..

4. 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 

5. (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
6. Back up the following databases:
   • Reports data warehouse
   • ETL Master repository 
   • ETL Work repository 
   • TrueSight Smart Reporting - Platform repository database

7. Back up the following files depending on the authentication types that are used:

   Authentication type	Files to be backed up
   Domain authentication	<TSSA-DWInstallationDirectory>/br/blappserv_login.conf  <TSSA-DWInstallationDirectory>/br/blappserv_krb5.conf
   LDAP authentication	<TSSA-DWInstallationDirectory>/br/ldapTrustStore.p12
   RSA SecurID authentication	<TSSA-DWInstallationDirectory>/br/sdconf.rec

8. 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.

9. Close all the files and folders opened in the current sessions. Also, close other user sessions on the server before starting the upgrade.
10. 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 type	Command to disable the authentication
       Domain	set AuthServer isDomainAuthEnabled false
       RSA Secure ID	set AuthServer IsSecurIDAuthEnabled false
       LDAP	set AuthServer IsLdapAuthEnabled false
       PKI	set PkiAuth IsEnabled false

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

11. (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:
    <TSSA-DWInstallationDirectory>/br/

Where to go from here:

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

• Upgrading using the wizard
• Upgrading silently