Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Now to capture the table output error

  1. #1

    Default Now to capture the table output error

    Hi All,

    I using the Table output step. If one rows is wrong , I hope the job will go on. but I want to capture which rows cause the error.

    Name:  test.jpg
Views: 534
Size:  6.2 KB

    I do the test like above case. The job will finish , But We can not capture any record that errors.

    I test. If we using the insert/update step. It works. But you know this step have wrong performance.
    Name:  test_2.jpg
Views: 539
Size:  6.0 KB

    How Can I do. Thanks for your help.
    Last edited by zxx2403; 02-01-2016 at 06:05 AM.

  2. #2
    Join Date
    Jun 2013
    Posts
    24

    Default

    You have to also define the error handling for the step. Right click the table output step and click Error Handling.... There you can define new fields that contain the information you want, and reference those fields in your text file output.

  3. #3
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    NOTE: If you are using Batch Update, even error handling won't work the way you want it to.
    You have to turn Batch Mode off in the Table Output for it to work particularly well.

  4. #4

    Default

    Hi All,

    Do we have any solution on batch updates with error handling in 5.0.1. If yes please let me know the solution.

  5. #5
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Quote Originally Posted by surendarkumar View Post
    Do we have any solution on batch updates with error handling in 5.0.1.
    The grouping of the error is not a PDI function - it's a DB function.

    Because the DB will suppress the errors (that's part of how Batch Updates work - it will report that there was an error in the batch, not which row in the batch), PDI has no option to be able to determine the error.

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.