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 name | Description |
|---|---|
BSA_site_siteID_timeStamp_run_etl.log | Main log file detailing the run_etl process |
BSA_site_siteID_timeStamp_0_BSARA_ETL_SCEN.log | Information about each scenario as it runs |
BSA_site_siteID_timeStamp_0_BSARA_ETL_SCEN.err | Information about any errors that occurred during each scenario run |
site_siteID_timestamp_5_MDM_SCEN.log | Information about the 5_MDM scenario as it runs |
site_siteID_timeStamp_4_MDM_SCEN.err | Information 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 name | Description |
|---|---|
BSA_site_siteID_timeStamp_stop_etl.log | Main 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 agentlogs.properties 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 blreports_config.properties file, which is located in the <TSSA-DWInstallationDirectory>/bin directory.