Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Table Output strange error..

  1. #1

    Question Table Output strange error..

    Hi,
    I'm using a Table output in my flow to insert about 10000 rows in a table.

    Often i get rejected rows, in different 'number and shape'. I mean that if i start the flow 3 times, the result is unpredictable.
    Once i get 1 rejected row, once again 3, and so on.. and the rejected rows are each time different from the previous execution.

    Anyone knows what the problem could be?


    Thanks,

    JP

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

    Default

    You try to insert multiple times rows with the same primary key? try insert/update else.

    Regards,
    Sven

  3. #3

    Default

    I forgot to say primary keys are generated by a db sequence, so they are always different.

    Thanks,
    JP

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

    Default

    without seeing more, there's not much more to say on it... I would suggest to put logging to rowlevel and check which rows you have a problem with.

    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.