java.lang.reflect.InvocationTargetException: Error saving transformation: org.pentaho.di.core.exception.KettleException: Error saving transformation to repository! Error updating batch Batch entry 435 INSERT INTO R_STEP_ATTRIBUTE(ID_STEP_ATTRIBUTE, ID_TRANSFORMATION, ID_STEP, NR, CODE, VALUE_NUM, VALUE_STR) VALUES ( 663, 2, 7, 0, field_precision, 0.0, N) was aborted. Call getNextException to see the cause.

Pentaho BI Platform Tracking | Jake Cornelius | 9 years ago
  1. 0

    Attached is a transformation that was originally created in PDI 2.5. It will import into PDI 3.0 fine, but when you go to save it to the repository, it errors out and seems to swallow the underlying exception. Here is the stack trace I get: java.lang.reflect.InvocationTargetException: Error saving transformation: org.pentaho.di.core.exception.KettleException: Error saving transformation to repository! Error updating batch Batch entry 435 INSERT INTO R_STEP_ATTRIBUTE(ID_STEP_ATTRIBUTE, ID_TRANSFORMATION, ID_STEP, NR, CODE, VALUE_NUM, VALUE_STR) VALUES ( 663, 2, 7, 0, field_precision, 0.0, N) was aborted. Call getNextException to see the cause. at org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run(SaveProgressDialog.java:59) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113) Caused by: org.pentaho.di.core.exception.KettleException: Error saving transformation to repository! Error updating batch Batch entry 435 INSERT INTO R_STEP_ATTRIBUTE(ID_STEP_ATTRIBUTE, ID_TRANSFORMATION, ID_STEP, NR, CODE, VALUE_NUM, VALUE_STR) VALUES ( 663, 2, 7, 0, field_precision, 0.0, N) was aborted. Call getNextException to see the cause. at org.pentaho.di.trans.TransMeta.saveRep(TransMeta.java:1888) at org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run(SaveProgressDialog.java:55) ... 1 more Caused by: org.pentaho.di.core.exception.KettleDatabaseBatchException: Error updating batch Batch entry 435 INSERT INTO R_STEP_ATTRIBUTE(ID_STEP_ATTRIBUTE, ID_TRANSFORMATION, ID_STEP, NR, CODE, VALUE_NUM, VALUE_STR) VALUES ( 663, 2, 7, 0, field_precision, 0.0, N) was aborted. Call getNextException to see the cause. at org.pentaho.di.core.database.Database.insertFinished(Database.java:1373) at org.pentaho.di.repository.Repository.closeStepAttributeInsertPreparedStatement(Repository.java:2790) at org.pentaho.di.trans.TransMeta.saveRep(TransMeta.java:1797) ... 2 more Caused by: java.sql.BatchUpdateException: Batch entry 435 INSERT INTO R_STEP_ATTRIBUTE(ID_STEP_ATTRIBUTE, ID_TRANSFORMATION, ID_STEP, NR, CODE, VALUE_NUM, VALUE_STR) VALUES ( 663, 2, 7, 0, field_precision, 0.0, N) was aborted. Call getNextException to see the cause. at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2512) at org.postgresql.core.v3.QueryExecutorImpl$ErrorTrackingResultHandler.handleError(QueryExecutorImpl.java:279) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1310) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:328) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2574) at org.pentaho.di.core.database.Database.insertFinished(Database.java:1358) ... 4 more Transformation is attached.

    Pentaho BI Platform Tracking | 9 years ago | Jake Cornelius
    java.lang.reflect.InvocationTargetException: Error saving transformation: org.pentaho.di.core.exception.KettleException: Error saving transformation to repository! Error updating batch Batch entry 435 INSERT INTO R_STEP_ATTRIBUTE(ID_STEP_ATTRIBUTE, ID_TRANSFORMATION, ID_STEP, NR, CODE, VALUE_NUM, VALUE_STR) VALUES ( 663, 2, 7, 0, field_precision, 0.0, N) was aborted. Call getNextException to see the cause.
  2. 0

    talend aatams_acoustic_reporting failing

    GitHub | 2 years ago | danfruehauf
    java.sql.BatchUpdateException: Batch entry 9,760 INSERT INTO "dw_aatams_acoustic"."aatams_acoustic_detections_data" ("detection_id","project_name","installation_name","station_name","bottom_depth","common_name","transmitter_id","release_date","release_locality","detection_date","longitude","latitude","sex","measurement_type","measurement_value","measurement_unit","phylum","order_name","scientific_name","geom","detected") VALUES (82014474,Logan River Catadromous Fish Migration,Upper Logan River,TBLJA,2.3,Australian Bass,A69-1601-9054,2013-04-05 02:00:00.000000 +1100,Teviot Brook,2013-04-14 14:25:08.000000 +1000,152.93,-27.83,UNKNOWN,WEIGHT,310.0,g,Chordata,Perciformes,Macquaria novemaculeata,SRID=4326;POINT(152.93 -27.83),1) was aborted. Call getNextException to see the cause.
  3. 0

    geoserver - ImageMosaic-JDBC Error - Geographic Information Systems Stack Exchange

    stackexchange.com | 1 year ago
    java.sql.BatchUpdateException: Batch entry 0 INSERT INTO tileaveiro_0 (location,geom,data) VALUES ('AveiroRDFS_rgb_5_8.png',geomfromwkb(?,4326),?) was aborted. Call getNextException to see the cause.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ImageMosaic-JDBC Error

    Geographic Information Systems | 4 years ago | user17653
    java.sql.BatchUpdateException: Batch entry 0 INSERT INTO tileaveiro_0 (location,geom,data) VALUES ('AveiroRDFS_rgb_5_8.png',geomfromwkb(?,4326),?) was aborted. Call getNextException to see the cause.
  6. 0

    Problem with 0.3.7 and postgresql

    GitHub | 3 years ago | tvaughan
    java.sql.BatchUpdateException: Batch entry 1 <unknown> was aborted. Call getNextException to see the cause., compiling:(/tmp/form-init3619964908012902520.clj:1:90)

    10 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.BatchUpdateException

      Batch entry 435 INSERT INTO R_STEP_ATTRIBUTE(ID_STEP_ATTRIBUTE, ID_TRANSFORMATION, ID_STEP, NR, CODE, VALUE_NUM, VALUE_STR) VALUES ( 663, 2, 7, 0, field_precision, 0.0, N) was aborted. Call getNextException to see the cause.

      at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError()
    2. PostgreSQL JDBC Driver
      AbstractJdbc2Statement.executeBatch
      1. org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2512)
      2. org.postgresql.core.v3.QueryExecutorImpl$ErrorTrackingResultHandler.handleError(QueryExecutorImpl.java:279)
      3. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1310)
      4. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:328)
      5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2574)
      5 frames
    3. org.pentaho.di
      SaveProgressDialog$1.run
      1. org.pentaho.di.core.database.Database.insertFinished(Database.java:1358)
      2. org.pentaho.di.repository.Repository.closeStepAttributeInsertPreparedStatement(Repository.java:2790)
      3. org.pentaho.di.trans.TransMeta.saveRep(TransMeta.java:1797)
      4. org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run(SaveProgressDialog.java:55)
      4 frames
    4. JFace
      ModalContext$ModalContextThread.run
      1. org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)
      1 frame