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-DWInstallationDirectory>/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)

The following log files are created in the <TSSA-DWInstallationDirectory>/logs/etl/timeStamp directory when you run the run_etl.nsh script:

Log file nameDescription
BSA_site_siteID_timeStamp_run_etl.logMain log file detailing the run_etl process
BSA_site_siteID_timeStamp_0_BSARA_ETL_SCEN.logInformation about each scenario as it runs
BSA_site_siteID_timeStamp_0_BSARA_ETL_SCEN.errInformation about any errors that occurred during each scenario run
site_siteID_timestamp_5_MDM_SCEN.logInformation about the 5_MDM scenario as it runs
site_siteID_timeStamp_4_MDM_SCEN.errInformation about any errors that occurred during the 5_MDM scenario run

The following log file is created in the <TSSA-DWInstallationDirectory>/logs/etl/timeStamp directory when you run the stop_etl.nsh script:

Log file nameDescription
BSA_site_siteID_timeStamp_stop_etl.logMain log file detailing the stop_etl process

Viewing the agent log files for ETL runs

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

These log files are located in the following directories: <TSSA-DWInstallationDirectory>/etl and agentLogFilesDirectory.

The location of the agentLogFilesDirectory is specified during the TrueSight Server Automation - Data Warehouse installation. This location is recorded as the agentlogpath property in the file, which is located in the <TSSA-DWInstallationDirectory>/bin directory.

Note for Unix platform

If you move the log files on UNIX platforms, ensure that the path name for agentLogFilesDirectory does not contain any spaces. Also, update the value of the agentlogpath in the file.

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