Logging

Set the transformation logging level

In this workshop we'll take a look at the basic logging options. The degree of logging can be set from ‘Nothing’ to ‘Row Level’.

• Change Metadata Data Type

• Examine the various levels of logging.

To create an error, change the Type for the field, message, from String to Integer, then view the Execution Results > Logging tab.

1. Double-click on the Generate Rows Step and change the Type, as illustrated below.

Change data type

1. Click OK.

---

Run the Transformation

1. Click the RUN button in the Canvas Toolbar.

2. Change the Log level from Basic to Row Level.

Set row level debugging

1. Click Run. The misconfigured Step is highlighted.

error in step

1. Click on the Log tab in the Execution Results pane.

logging - error

Its a bit of an art .. but the reason for the error is in there..!

You can display just the logging 'error' by clicking on the minus icon.

The ERROR is also logged in:

Windows

C:\Pentaho\design-tools\data-integration\logs\pdi.log

Linux

~/Pentaho/design-tools/data-integration/logs/pdi.log

pdi.log - Linux

---