Post-installation tasks for TrueSight Server Automation - Data Warehouse

Where you are in the Installation process

StepTask
1.Complete the planning activities
2.
3.
4.

Complete the post-installation activities for TrueSight Server Automation - Data Warehouse (You are here)


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

Was this page helpful? Yes No Submitting... Thank you

Comments

  1. Sean Berry

    In this line,

    Right-click TrueSight Server Automation RSCD Agent and select Restart.

    "TrueSight Server Automation RSCD Agent" should all be bolded

    Nov 08, 2019 02:18
  2. Sean Berry

    If you want to load data for the Property class type properties, consult your database administrator to perform the following steps: Should be a checkbox.

    Nov 08, 2019 02:19
    1. Bipin Inamdar

      Hi Berry,

      I am not sure what you mean by a check box. These steps are not performed on the TSSADW UI. Could you please elaborate?

      Regards,

      Bipin Inamdar

      May 29, 2020 06:23
      1. Sulekha Gulati

        Comment is not valid as per my discussion with Sean. Closing it.

        Jul 08, 2020 01:26