Moving the TrueSight Server Automation - Data Warehouse environment

You can move your existing TrueSight Server Automation - Data Warehouse infrastructure to a new environment. For example, you might want to set up a new environment that is a replica of your production environment to test operations such as upgrade.

This movement involves backing up your databases and files, installing TrueSight Server Automation - Data Warehouse in a new environment, and restoring the backed up databases and files.

Prerequisites

  • Make sure that the new environment meets the system requirements.
  • The TrueSight Server Automation - Data Warehouse installation files are downloaded to the server where you want to install it.

Procedure

To move your existing TrueSight Server Automation - Data Warehouse environment, do the following:

  1. Log in to the server where your existing TrueSight Server Automation - Data Warehouse is installed.

  2. Back up following files, directories, and databases:

    Location of databases/files/directories

    Databases/files/databases

    Database instance

    Reports data warehouse.

    • (Oracle) expdp [sys username]/[password]@[sid] schemas=[Data warehouse schema] directory=[test_dir] dumpfile=[Data warehouse schema].dmpdp logfile=expdp_[Data warehouse schema]_[date].log
    • (SQL) Right click the database and select Tasks and then Back Up, and perform a full backup.

    <TSSA-DW_installation_directory>/shared/ConfigurationManagement

    • user_roles.csv (if you have changed)
    • bds.properties
    • generic_configuration.properties (if you have changed)

    <TSSA-DW_installation_directory>/tomcat/conf/

    server.xml

    <TSSA-DW_installation_directory>/jre/lib/security

    cacerts

  3. Log in to the new server where you want to move TrueSight Server Automation - Data Warehouse, and do the following:
    1. Restore the Reports data warehouse that you backed up.
      • (Oracle) impdp [sys username]/[password]@[sid] schemas=[Reports data warehouse schema] directory=[test_dir] dumpfile=[Reports data warehouse schema].dmpdp logfile=expdp_[Reports data warehouse schema]_[date].log
      • (SQL) Import or restore the backup that was taken from the production database.
    2. Install TrueSight Server Automation - Data Warehouse. For instructions, see Installing.
    3. Log in to the TrueSight Server Automation - Data Warehouse console with the DWAdmin credentials.
    4. On the Database Prerequisites tab, select Disaster Recovery Install - Setup additional TSSA-DW node using existing or standby warehouse database, and do the following:
      1. Copy the bds.properties file from the existing TrueSight Server Automation - Data Warehouse server (path: <tssadw_installation_directory>/shared/ConfigurationManagement/) to the this path: <tssadw_installation_directory>/migrationData/)
      2. Update the bds.properties file with the new database connection details.
      3. Click Validate. The specified database connections are validated.
      4. Configure the Warehouse and site database details. For more information, see Configuring-TrueSight-Server-Automation-Data-Warehouse.
    5. Restore the following backed up files in the new environment (except the bds.properties file that you already copied):
      • user_roles.csv (if you have changed)
      • generic_configuration.properties (if you have changed)
      • server.xml
      • cacerts

What's next

Do one of the following:

  • To install and set up the TrueSight Smart Reporting - Platform application on a new server, perform these steps:
    1. Log in to the server where you want to set up TrueSight Smart Reporting - Platform.

    2. Install TrueSight Smart Reporting - Platform 20.02:

      Do the following:

      1. From the BMC Electronic Product Distribution (EPD) website, download the TrueSight Smart Reporting - Platform 20.02 zip or tar file.

      2. Unzip the TrueSight Smart Reporting - Platform 20.02 file to a temporary directory.

      3. From the FTP location, download the TrueSightSmartReporting_HotFix_20.02.00.002.zip file.

      4. Unzip the TrueSightSmartReporting_HotFix_20.02.00.002.zip file on the same server in a separate temporary directory.
      5. Navigate to the <TrueSight Smart Reporting 20.02_install_directory>Disk1 directory, and replace the setup.jar file with the setup.jar file that you downloaded.
      6. From the temporary directory where you saved the installation files, copy the silent.options file to the <TrueSight Smart Reporting 20.02_install_directory>Disk1 directory.
      7. Open the silent.options file, and verify that the following parameter values are set as indicated:-J REPORTING_DB_OPTION=EXISTING_DB 
        -J REPORTING_USER_OPTION=EXISTING_USER

      8. Ensure that the repository database details are the same as that of the existing TrueSight Smart Reporting - Platform database.
        For more information about all silent installation parameters, see Installing TrueSight Smart Reporting - Platform silently.

      9. In the command prompt, navigate to the <TrueSight Smart Reporting 20.02_install_directory>Disk1 directory and run the following command:

        Windows
        setup.exe -i silent -DOPTIONS_FILE<TrueSight Smart Reporting 20.02_install_directory>Disk1\silent.options

        Linux
        ./setup.bin -i silent -DOPTIONS_FILE=<TrueSight Smart Reporting 20.02_install_directory>Disk1/silent.options

        To view information about the installation progress, see the TrueSightSmartReporting_install_log.txt file in the temp directory.

    3. Apply the TrueSight Smart Reporting - Platform 20.02.02 patch. For instructions, see Applying the 20.02.02 service pack.

    4. Log in to the TrueSight Smart Reporting - Platform console.

    5. Change the TrueSight Server Automation - Data Warehouse host name:

      Do the following:
      1. Log in to the TrueSight Smart Reporting - Platform host as a platform admin user.
      2. Click Edit corresponding to the TrueSight Server Automation - Data Warehouse component.
      3. In the Hostname field, specify the new TrueSight Server Automation - Data Warehouse host name.
      4. Save the changes.

    6. Import the TrueSight Smart Reporting - Platform certificate into TrueSight Server Automation - Data Warehouse:

      Do the following:

      Import the TrueSight Smart Reporting - Platform certificate into TrueSight Server Automation - Data Warehouse for secure communication.

      1. Run the following command to export the certificate from the TrueSight Smart Reporting - Platform keystore:

        keytool -export -alias smartreporting -keystore <tssr_installation_directory>/appserver/conf/tsr.keystore -rfc -file tsr.cert

        The tsr.cert file is created in the same directory where the keytool was run.

        If TrueSight Server Automation - Data Warehouse and TrueSight Smart Reporting - Platform are installed on different systems, copy the tsr.cert file to the server where TrueSight Server Automation - Data Warehouse is installed.

      2. Run the following command to import the tsr.cert file into the TrueSight Server Automation - Data Warehouse keystore.

        keytool -import -v -trustcacerts -alias tsr -file <path_where_tsr.cert_is_copied>/tsr.cert -keystore <tssadw_installation_
        directory>/jre/lib/security/cacerts -keypass changeit -storepass changeit
      3. Restart the following services:
        • TrueSight Server Automation - Data Warehouse
        • Authentication Service

  • To use the existing TrueSight Smart Reporting - Platform application, update the TrueSight Server Automation - Data Warehouse host name in TrueSight Smart Reporting - Platform:

    1. Log in to the TrueSight Smart Reporting - Platform host as a platform admin user.
    2. Click Edit corresponding to the TrueSight Server Automation - Data Warehouse component.
    3. In the Hostname field, specify the new TrueSight Server Automation - Data Warehouse host name.
    4. Save the changes.


 

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