Post-installation tasks for TrueSight Server Automation - Data Warehouse

Where you are in the Installation process

Complete the following post-installation activities in TrueSight Server Automation - Data Warehouse:

1. If you are performing the initial migration of BMC Decision Support for Server Automation warehouse to TrueSight Server Automation - Data Warehouse, you must run a diagnostic SQL query to verify that the version of BMC Decision Support for Server Automation warehouse is as expected. For more information, see this knowledge article.

2. If you have disabled the NSH proxy on the reports server before upgrade, enable it by adding appserver_protocol=ssoproxy the entry in the secure file. Use the following command to add the entry:

   secadmin -m default -p 5 -appserver_protocol ssoproxy
3. Configure TrueSight Server Automation - Data Warehouse by using the console.
4. Restart the RSCD agent. Do the following:
   • Windows
     1. Choose Start > Settings > Control Panel > Administrative Tools > Services.
     2. Right-click TrueSight Server Automation RSCD Agent and select Restart.
   • Linux

     • From the command line, type the command:
       <RSCD/NSHinstalldir>/[NSH|RSCD]/sbin/agentctl restart

       The sbin directory is present in either NSH or RSCD, depending on the type of the installer used.

5. If you are deploying with the Oracle database, consult your database administrator to perform the following steps:
   
   1. Run the following commands as a system administrator user to provide the indicated permissions to the data warehouse user:
      
      1. GRANT SELECT ON dba_data_files TO <datawarehouseUser>;
      2. GRANT SELECT ON  dba_free_space TO <datawarehouseUser>;
   2. Run the following command as a data warehouse user to compile the V_DB_SIZE view:
      Alter view V_DB_SIZE compile;
6. Install TrueSight Smart Reporting - Platform 20.02 and then apply the 20.02.01 patch. For instructions, see the following topics:

   1. Installing TrueSight Smart Reporting - Platform 20.02

   2. Applying TrueSight Smart Reporting - Platform 20.02.01 patch

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

8. (optional) If you want to load data for the Property class type properties, consult your database administrator to perform the following steps: 

   • Oracle
     
     1. Log on to SQL Plus as TSSADW_DW or the name you choose for this user.

     2. Run the following commands:

        sqlplus tssadw_dw/<password>@<TNS_ENTRY>
        update system_property set value = 'true' where NAME='LoadPropertyClass';
        commit;

   • SQL Server
     
     1. Log on to the SQL Server database as TSSADW_DW or the name you choose for this user by using the SQL Server Management Studio.

     2. Run the following command:

        update system_property set value = 'true' where NAME='LoadPropertyClass'

9. Perform the initial ETL run.

   After upgrading to TrueSight Server Automation - Data Warehouse 20.02.01, the ETL run might take some time to complete execution due to schema changes.

10. If your company policy requires global_names parameter to be set back to true after the TrueSight Server Automation - Data Warehouse installation is completed, your database administrator can set the value of global_names to true. This also requires few additional steps to be run on the database. Consult your database administrator to perform the steps mentioned here.
11. If you want to use TrueSight Server Automation - Data Warehouse with Oracle Exadata, apply this hotfix.