Important This space contains documentation for TrueSight Smart Reporting for Server Automation 20.02.01. For earlier releases, see TrueSight Smart Reporting for Sever Automation 19.2.

Handshake between ETL and  TrueSight Server Automation database

The handshake between the TrueSight Server Automation - Data Warehouse ETL and the TrueSight Server Automation database informs you whether ETL is running when you try running the Database Maintenance utility on the TrueSight Server Automation database. Also, it informs you whether the Database Maintenance utility is running on the TrueSight Server Automation database when you try running ETL, as follows:

  • If you try running ETL and the Database Maintenance utility is running on the TrueSight Server Automation database in offline mode, the following error message appears on the ETL Detailed Status  page at the CHECK_TSA_DB_CLEANUP step:

    Offline TSA DB Maintenance is running so cannot start ETL. Please wait till completion 

    BMC recommends that you let the Database Maintenance utility complete. After that, run ETL.

  • If you try running ETL and the Database Maintenance utility is running on the TrueSight Server Automation database in online mode, the following error message appears on the ETL Detailed Status page at the CHECK_TSA_DB_CLEANUP step:

    Online TSA DB Maintenance is running so cannot start ETL. Please wait till completion

    You can use the -b option in the run_etl.nsh script to stop the Database Maintenance utility, as shown in the following command:

    ./run_etl.nsh -s <siteID> -b [-d <logLevel>] [-f <propertyFile>]

    When you use this option, the script waits for 90 seconds for the Database Maintenance utility to stop. If the utility does not stop, ETL terminates with the following error message:

    Online TSA DB Maintenance taking longer than required so aborting ETL. 

    Note

    (Oracle only) To use the -b option, the TrueSight Server Automation database user must be assigned the DBMS_LOCK permission.

  • If you try running the Database Maintenance utility on the TrueSight Server Automation database and ETL is running, the Database Maintenance Wizard displays an error message similar to the following: 

    Database Maintenance cannot be started due to following reason(s): ETL Process is running on the database.

    In this case, you must wait until ETL completes and then, re-run the Database Maintenance utility.  

  • If ETL or the database maintenance process does not complete and any of these processes is in a hung state, use the following methods to stop the processes:
    • To stop ETL, use the stop_etl.nsh script.  
    • To stop the database maintenance process, stop the Database Maintenance utility.

  • You can retain the deleted data (deleted through TrueSight Server Automation Console or BLCLI) in TrueSight Server Automation for certain number of days by using the RetainDeletedDataForETLInDays option. This option minimizes the chances of permanent deletion of data before it is used for ETL. For more information, see the To set the retention period for deleted data section on Marking data for deletion.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*