Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Trouble with "database lookup" and error handling

  1. #1

    Default Trouble with "database lookup" and error handling

    Hi, I found a few threads where this topic was mentioned but it is still not clear to me what I am doing wrong.

    I have a very simple input table with say 1000 rows I do an (oracle 11) database-lookup step to find rows with a key field
    I check both check boxes

    1. Do not pass row if lookup fails
    2. fail on multiple rows

    I have a write to log as my error step, but when I run the transformation the input to the lookup is 1000 rows but the output is only 998.
    The write to log does not print the two records that supposedly failed the lookup.
    If I un-check error handling it prints every row.

    I'm using PDI 4.2

  2. #2
    Join Date
    May 2012



    You do want to pass the row when lookup fails, so uncheck box and enter your 3 variable names in the error box and write to log on error.
    Regards Vince

  3. #3


    Great, that worked.
    Thanks, Vince

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.