Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: sql insert error log in batch model

  1. #1
    Join Date
    Jul 2007
    Posts
    10

    Default sql insert error log in batch model

    When I use the table output to write some rows coming from the table input into db in batch model ,if there is some error occur,my kettle will stop writting rows to db,but it will still read rows from the table input,so it will says 'out of memory'!
    If I do the same thing after selecting 'ignore insert error' and not use the batch model,my kettle will puts the sql error and go on.
    What I want is that,when I use batch model,if there is some error occur,kettle can tell me the sql error but not the 'out of memory',how can I do this?Thanks for any help!

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    That was solved in 3.0, not yet in 2.5.0/2.5.1 ... you will still get the out of memory error but that will cause the whole transformation to be stopped.

    Regards,
    Sven

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.