Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: Update Transformation fails when running multiple step copies.

  1. #1
    Join Date
    Apr 2014
    Posts
    18

    Angry Update Transformation fails when running multiple step copies.

    I have the transformation below that selects records from an intersect query and then update a table. The updates are in the hundreds of thousands .



    When running multiple steps copies it generates the error below and stop.

    2015/03/20 02:34:29 - Update.4 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Error in step, asking everyone to stop because of:
    2015/03/20 02:34:29 - Update.4 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseBatchException:
    2015/03/20 02:34:29 - Update.4 - Error updating batch

    The next lines in the log just show the sql statement of the record being updated, which I copy and execute manually without getting any error.

    2015/03/20 02:34:29 - Update.4 - at org.pentaho.di.core.database.Database.insertRow(Database.java:1179)
    2015/03/20 02:34:29 - Update.4 - at org.pentaho.di.trans.steps.update.Update.lookupValues(Update.java:196)
    2015/03/20 02:34:29 - Update.4 - at org.pentaho.di.trans.steps.update.Update.processRow(Update.java:327)
    2015/03/20 02:34:29 - Update.4 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)
    2015/03/20 02:34:29 - Update.4 - at java.lang.Thread.run(Thread.java:701)
    2015/03/20 02:34:29 - Update.4 - Caused by: java.sql.BatchUpdateException: Batch entry 226 UPDATE <TABLE BEING UPDATED HERE>

    Is this a bug? I had the same transformation running fine and it start failing all of the sudden. It works fine when I run it without multiple steps copies.
    Last edited by reynunez; 03-20-2015 at 09:11 AM.

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.