Moving the TrueSight Server Automation - Data Warehouse environment

To move the TrueSight Server Automation - Data Warehouse infrastructure to a new environment, you must first back up and then restore product files, directories, and databases.

See the following topics:

• Files and databases to be backed up
• Restoring the TrueSight Server Automation - Data Warehouse environment

Files and databases to be backed up

Back up following files, directories, and databases:

Restoring the TrueSight Server Automation - Data Warehouse  environment

You can restore the following files that you backed up on a new environment:

Complete the following steps to restore the reports server in a new environment:

1. Restore the Reports data warehouse that you backed up.
2. Install TrueSight Server Automation - Data Warehouse in the new environment.
3. Configure the TrueSight Server Automation - Data Warehouse using the "Migration from BDSSA" option and providing the backed up bds.properties file. For more information, see Configuring TrueSight Server Automation - Data Warehouse by using the console.
4. 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
   • keystore.jks (or the custom keystore file)
   • cacerts

What's next

• Change the TrueSight Server Automation - Data Warehouse host 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.
• If you want to change the TrueSight Smart Reporting - Platform host, do the following:

1. 
   
   1. Log in to the system 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 in 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, and paste it in the <TrueSight Smart Reporting 20.02_install_directory>Disk1 directory.
      7. Open the <TrueSight Smart Reporting 20.02_install_directory>Disk1>silent.options file.
      8. Ensure that the following parameter values are set as follows:
         -J REPORTING_DB_OPTION=EXISTING_DB 
         -J REPORTING_USER_OPTION=EXISTING_USER

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

      10. 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.01 patch. For instructions, see Applying the 20.02.01 patch.

   4. Change the TrueSight Server Automation - Data Warehouse host name in the TrueSight Smart Reporting - Platform console:

      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 host name.
      4. Save the changes.

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