Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Get output count when error inserting rows

  1. #1
    Join Date
    Jan 2007
    Posts
    19

    Default Get output count when error inserting rows

    Hello everybody,

    I have a table output, and I would like to retrieve count of rows which have been really inserted.
    Because I have activated "Ignore insert errors" so that the transformation didn't exit when a row can't be inserted (constraint violation for example).

    When my transformation finishes, on "table output" step have the same read and written number, even if not all rows have been inserted.

    Have someone an idea to get the right count ?

    thanks a lot

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

    Default

    Use error handling code of 2.5.0

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.