Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: error handling tab

  1. #1
    Join Date
    Sep 2007
    Posts
    834

    Default error handling tab

    A question about the error handling tab of some input steps (i.e.text file input)
    What kind of errors does it capture (or is it supposed to capture) ?

    I ask this because many times I fail using it and I don't know if it is because I'm not using it correctly, or because the tab is not prepared to handle the kind of errors my data has.

    thanks
    mc

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    It's a left-over of an era when animals could still speak.

    If you set the directories and enable the error handling, the step will write down line numbers into a file called <original filename>_<timestamp>.line in case it encounters a parsing error etc.

    If you then "fix" the file (same for XLS input by the way) you can "Replay" the transformation specifying <timestamp> as replay date.
    This will cause the "Text File Input" (and "Excel Input") step to only consider the lines in the .line file.

    That's what it was meant for, not the generic step error handling as we know it today.

    Matt

  3. #3
    Join Date
    Sep 2007
    Posts
    834

    Default

    Thanks, Matt.
    All that you mentioned here can perfectly be done without using that tab. In fact, as you said, now there are better ways to capture and handle errors.
    In fact, we HAVE to use other solutions for the input steps that don't have that error tab.
    May I conclude that the error tab is obsolete?

    mc

  4. #4

    Talking There's a way around

    Hi there!

    My humble contribution to this is: there exists a "Data validation" step, that lets you define validation rules.

    And even better: you have an example in the keetle installation dir.

    See: http://wiki.pentaho.com/display/EAI/Data+Validator

    Regards,

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.