Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Table Output Replaced with Insert/Update

  1. #1

    Default Table Output Replaced with Insert/Update

    Hi All,

    I have a transformation

    Table Input -> Table Output

    transferring the record from source database table to destination database table.
    I tested initially the transformation with MYSQL 5.0 , it works fine.
    Then i tested the same transformation with the Oracle , its not working.
    I was getting the error :

    Table Output. - ERROR : ORA-00001: unique constraint violated
    No record is inserted into destination table.

    Now i have removed the step table output and replaced insert/update step.
    Now record is inserted but still the error is occurring.

    Can any one tell me why is it so happening. Does the transformation steps are database dependent ?

    Please Help me.

    Regards,
    Sham

  2. #2
    Join Date
    Apr 2010
    Posts
    127

    Default

    You have some unique index defined in your oracle table but not in the mysql one i think..
    (Maybe you're using an autoincremental key in Mysql?)

  3. #3
    Join Date
    Feb 2009
    Posts
    321

    Default

    one or more rows are being updated,
    use (select count(1) from table) in both db and take a look......
    (must be different)

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.