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 have disabled the NSH proxy on the reports server before installation, enable it by adding the appserver_protocol=ssoproxy entry in the secure file. Use the following command to add the entry:

   secadmin -m default -p 5 -appserver_protocol ssoproxy
2. Configure TrueSight Server Automation - Data Warehouse by using the console.
3. 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.

4. 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;
5. Install TrueSight Smart Reporting - Platform 20.02 and apply the 20.02.02 patch. For instructions, see the following topics:

   1. Installing TrueSight Smart Reporting - Platform 20.02

   2. Applying the 20.02.02 service pack

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

7. (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.
        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'
8. Perform the initial ETL run.
9. 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.