Set the transformation logging level ..
Use logging to diagnose transformation problems. Create a controlled type mismatch error. Use log level and output to find the cause.
What you’ll do
Change field metadata to trigger an error
Run with Basic and Row level logging
Use Execution results to find the failing step
Locate the same error in pdi.log
pdi.log
Prerequisites: Complete the Hello World workshop
Estimated time: 5 minutes
Create a new transformation
Use any of these options to open a new transformation tab:
Select File > New > Transformation
Use Ctrl+N (Windows/Linux) or Cmd+N (macOS)
Ctrl+N
Cmd+N
Start from the transformation you built in Hello World.
Generate Rows is a test-data step. It is a quick way to validate logging and error handling.
To create an error, change the field type for message from String to Integer.
message
Double-click the Generate Rows step.
Change the type for message to Integer.
Select OK.
Run with a higher log level to see row-level detail.
Select Run in the canvas toolbar.
Set Log level to Basic.
Select Run.
Run again with Log level set to Row level.
Select Run. The failing step is highlighted.
In Execution results, open the Log tab.
The error text is in the log output. Look for the first ERROR entry.
Tip: Select the minus icon to show errors only.
The same error is written to pdi.log:
C:\\Pentaho\\design-tools\\data-integration\\logs\\pdi.log
~/Pentaho/design-tools/data-integration/logs/pdi.log
Next workshop: Error Handling
Last updated 1 month ago
Was this helpful?
