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. If a script fails, you can use these logs to determine the point at which the script failed and how to recover.
The log files are created in the BDSSAInstallationDirectory/logs/etl/timeStamp directory, where timeStamp represents the date and time that the log file was created. A new timeStamp directory is created for each ETL run.
The administrator can remove the log files from the directory when appropriate.
The following log files are created when you run the run_etl.nsh script:
Log files for ETL runs
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_4_UPDATE_COGNOS_SCEN.log | Information about the 4_UPDATE_COGNOS scenario as it runs |
site_siteID_timeStamp_4_UPDATE_COGNOS_SCEN.err | Information about any errors that occurred during the 4_UPDATE_COGNOS 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 |
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 stop_etl.nsh script creates the BSA_site_siteID_timeStamp_stop_etl.log file in the BDSSAInstallationDirectory/logs/etl/timeStamp directory.