Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: SQL Exception / Error Handling in a Transformation

  1. #1
    Join Date
    Aug 2016
    Posts
    1

    Lightbulb SQL Exception / Error Handling in a Transformation

    My use case is, When my transformation is trying to insert a row to the table in Vertica DB where a field has exceeded the defined size.
    What happens is that kettle throws java.sql.SQLDataException and aborts the job.
    I understand that this can be handled in Data Validator, ignore those rows which has failed the condition in Data Validator.
    However say in case if i missed to do Data Validation for a column, which will obviously escape and tries to insert that particular row in the table and throws the java.sql.SQLDataException.
    What i would like to know is, is there way to handle such exceptions inside the transformation which will allow the transformation to keep running ignoring the rows with errors. Please suggest.

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Step Table-Output is one of the steps supporting error handling.
    So long, and thanks for all the fish.

Tags for this Thread

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.