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. Excerpt named tssr_secure was not found in document xwiki:Automation-DevSecOps.Server-Automation.TrueSight-Smart-Reporting-for-Server-Automation.tssrsa242.Upgrading.Post-upgrade-tasks.WebHome.

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.