ETL+ Web: Log Page

The following is a sample screenshot from the LOG page:

Number of Log Rows showing / Index
- Enter a new number and press Enter to load a different of number of log rows.
- Index =1 at the bottom of the list, and it increases going up.
Entity ID (Key): shows <Entity ID> (<Entity Key>) per line.
Job: Enter a Job ID and press Enter to filter the log rows accordingly.
Date Time:
- Shows the date and time for each line.
- The time zone can be customized using the TZ header dropdown.
- By default, it shows the latest Log rows.
- Use the Start and End boxes to define a different log period than the default.
Duration
- Shows the duration by individual log row.
- Use the sort icon to quickly view the longest log steps. You might also want to increase the number of Log Rows to capture all relevant log steps.
Description
- Shows the description for each log row. It can over beginning and end of Jobs, user actions, as well as object loading.
- It shows the following for table loading: <Source Name>.<Object Name> (<number of rows> rows <load type>). Example from the sample screenshot: ERP.Whse (1 rows upserted)
Type: Use this dropdown to select the log types to show
RunID: When applicable, shows the log section RunID.
Dw: Shows the data warehouse’s SQL instance.
Device/User: When applicable, shows the device name and Windows user running the ETL+ Windows Service where the log row ran.
Icons under the header labels:
- Hide column (use … on the far right to reset hidden columns)
- Sort: Click the Sort icon on a column header to order the list by this column plus the DateTime column.
- Auto-scroll: This checkbox is only relevant when the Live checkbox is ON. In this case, uncheck the Auto-scroll box to prevent the list from auto-scrolling as new log lines are added to the bottom of the list.
- Live: When checked, it’ll auto populate new log lines to the bottom of the list.
- … on the far right:
  - Reset Size/Hide columns
  - Export to CSV