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

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 want to load data for the Property class type properties, consult your database administrator to perform the following steps: 
   • Oracle
   1. 
      
      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. 
      

      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';

6. If you are deploying with the Oracle database, run the following command as a TSSADW_DW user to compile the V_DB_SIZE view:

   alter view V_DB_SIZE compile;

7. Perform the initial ETL run.
8. If you are migrating from BMC Decision Support for Server Automation to TrueSight Server Automation - Data Warehouse 8.9.04.004, run the ETL for the patch domain and then generate reports. Otherwise, patch reports might show data discrepancy.
   Note: After upgrading to TrueSight Server Automation - Data Warehouse 8.9.04.004, the ETL run might take some time to complete execution due to schema changes.
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. 

Where to go from here

Now that you have successfully installed and configured  TrueSight Server Automation - Data Warehouse, the next step in the installation process is to install TrueSight Smart Reporting - Platform. For instructions, see one of the following topics depending on the version of TrueSight Server Automation - Data Warehouse that you are using. 

• TrueSight Server Automation - Data Warehouse 8.9.04.002 is compatible with TrueSight Smart Reporting - Platform 19.2 .
• TrueSight Server Automation - Data Warehouse 8.9.04.003 is compatible with  TrueSight Smart Reporting - Platform 19.3 .
• TrueSight Server Automation - Data Warehouse 8.9.04.004 is compatible with  TrueSight Smart Reporting - Platform 20.02 .