Home

Step debug level

You can set a specific debug level on a step. This debugging information is stored in the transformation metadata. You can set specific debug level and on which rows this will be enabled (you can set a range and a condition).

• Set : "step / Logging ... / Set specific step logging level"
• Clear "step / Logging ... / Clear specific step logging level" Make sure to clear all step debugging information from your transformation before checking it into version control. Use the step menu item for this.
• Clear all : "step / Logging ... / Clear all logging info from steps"

Job entry debug level

You can set a specific debug level on a job entry. This information is also stored in the job metadata. The same options as for the step (see above) are also available in the job entry right click menu. You can opt to not only modify the logging level but also choose to log (minimal logging level) the result after execution, modified variables (compared to the parent job at the start), result rows and result files.

Debug level metadata

To support the ability to debug specific steps or job entries on remote servers we need to store a little bit of information in the Transformation or Job metadata. This sort of metadata is stored completely separated from the rest of the metadata and is only used when the kettle-debug-plugin is installed. Because of this there is no risk to having this extra information stored in the metadata or even checked into version control. Below are the affected attributes added. As you can see they are pretty self explanatory:

Step metadata attributes:

• The logging level: log_level
• Start row: start_row
• End row: end_row
• The condition XML: condition

Job entry metadata attributes:

• The logging level: log_level
• Log result?: entry_log_result (Y/N)
• Log variables?: entry_log_variables (Y/N)
• Log result rows?: entry_log_result_rows (Y/N)
• Log result files?: entry_log_result_files (Y/N)

Duration timing information

With this plugin enabled you now see the duration of transformations and jobs when they're done. You can disable this by setting KETTLE_DEBUG_DURATION to N or false;

Zoom levels

As far as is possible through plugins this plugin will remember the last zoom level of transformations and jobs. For when it can't you can recall the last zoom level with CTRL-U or the "View/Zoom to last level" menu.

Releases

Get your updated plugin over here : Releases