Logging

Set the transformation logging level ..

Workshop - Logging

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.

Logging

---

Create a new Transformation

Any one of these actions opens a new Transformation tab for you to begin designing your transformation.

• By clicking File > New > Transformation

• By using the CTRL-N hot key

1. Modify Generate Rows

Generate Rows

Generate rows outputs a specified number of rows. By default, the rows are empty; however, they can also contain several static fields. This step is used primarily for testing purposes. It may be useful for generating a fixed number of rows, for example, if you require exactly 12 rows for 12 months.

Sometimes you may use Generate Rows to generate one row that is an initiating point for your transformation.

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.

➡️ Next: Finally RUN the transformation

2. RUN

RUN the Transformation

This final part of the creating a transformation, executed locally.

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