Skip to main content
Mitratech Success Center

Logging

Logging is controlled by the /level setting in the batch files. By default, the setting is /level:Basic. You can edit the batch files to change the setting:

Logging Levels

Logging Level

Description

Error

Only show errors

Nothing

Don't show any output

Minimal

Only use minimal logging

Basic

This is the default basic logging level

Detailed

Give detailed logging output

Debug

For debugging purposes; very detailed output

Rowlevel

Logging at a row level; this may generate a lot of data

Individual Transformation Logs

Database table WH_EXTRACT_LOG contains an entry for each individual transformation that runs as part of the refresh job. This logging feature captures the number of rows processed for each object in TeamConnect for each run of the Data Warehouse. It also displays the current status of each ETL transformation as well as a date stamp for entries logged.

You can query this table, sorting by column LOGDATE, to retrieve transformation history. Currently there is no limit on the number of entries in the WH_EXTRACT_LOG. It is up to you to maintain the space used by this table. It is recommended that you delete rows periodically, based on LOGDATE value, to recover space.

WH_EXTRACT_LOG column definitions

Column Name

Usage

ID_BATCH

A number that is incremented by one for each transformation run.

CHANNEL_ID

Internal identifier used by the Kettle tool.

TRANSNAME

The name of the ETL transformation that generated the log entry. This corresponds to the Warehouse table name.

STATUS

Indicates the current status of a transformation. Possible values are:

  • start—indicates the transform has started
  • stopped—indicates the transform has stopped and not run to completion
  • end—indicates that the transform has run to completion

LINES_READ

Not used by Data Warehouse

LINES_WRITTEN

Not used by Data Warehouse

LINES_UPDATED

Not used by Data Warehouse

LINES_INPUT

The number of rows input from the TeamConnect source

LINES_OUTPUT

The number of rows output to the Warehouse

LINES_REJECTED

Not used by Data Warehouse

ERRORS

The number of errors logged by the transformation.

STARTDATE

Not used by Data Warehouse

ENDDATE

Not used by Data Warehouse

LOGDATE

Date the row was updated in WH_EXTRACT_LOG

DEPDATE

Not used by Data Warehouse

REPLAYDATE

Not used by Data Warehouse

  • Was this article helpful?