Viewing the log files for ETL runs


Running the run_etl.nsh or stop_etl.nsh script creates log files that contain details related to the script, scenario execution, and errors. The log files are created in the <TSSA-DW_installation_directory>/logs/etl/timeStamp or agentLogFilesDirectory directory, where timeStamp represents the date and time that the log file was created. A new timeStamp directory is created for each ETL run. If a script fails, you can use these logs to determine the point at which the script failed and how to recover. The administrator can remove the log files from the directory when appropriate.

In the log file names, variables are defined as follows:

  • siteID: The site ID
  • timeStamp: Date and time that the log file was created; uses the format YYMMDDHHMMSS (year, month, day, hour, minute, and second)

When you run the the run_etl.nsh script, the following log files are created in the <TSSA-DW_installation_directory>/logs/etl/timeStamp directory:

Log file name

Description

BSA_site_siteID_run_etl.log

Main log file that provides details of the run_etl process.

BSA_site_siteID_exception_run_etl.err

Log file that contains exceptions.

When you run the stop_etl.nsh script, the following log files are created in the <TSSA-DW_installation_directory>/logs/etl/timeStamp directory:

Log file name

Description

BSA_site_siteID_timeStamp_stop_etl.log

Main log file that provides the details of the stop_etl process.

BSA_site_siteID_exception_stop_etl.err

Log file that contains exceptions.

Viewing the agent log files for ETL runs

When you run the run_etl.nsh script using the -f argument with the agentlogs.properties file, a set of log files is created for the agent log.

These log files are located in the following directories: <TSSA-DW_Installation_Directory>/etl and AgentLogProcess

The location of the agentLogFilesDirectory is specified during TrueSight Server Automation - Data Warehouse installation.

 

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