Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: Records not getting populated correctly when no.of.copies > 1

  1. #1
    Join Date
    Feb 2014

    Default Records not getting populated correctly when no.of.copies > 1

    Hi ,

    We face a weird scenario and wanted to check whether this is any pentaho bug or not

    We have transformation designed to read from a table and write to another table. The target table has got unique index on a ID field

    Table output step used has got multiple copies enabled to 4 , a step is added to the error handling hop as well to capture the DB errors from the step.

    When we have duplicate ID records from source table , the no .of rejects and the no.of records loaded in the table are not matching with no.of copies > 1 .
    it is working fine when we set no.of copies =1

    I did try avoiding the reject scenario by dropping the index on the target table and load with multiple copies settings . This also works fine.

    Anyone faced similar kind of issues ?

    Note : Pentaho Version 6.1 , MySQL Lib 5.1.27
    Last edited by pdiman; 02-25-2019 at 10:49 AM.

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.