org.pentaho.di.core.exception.KettleException: Error batch inserting rows into table [extractie.ext_woz_objectcyclus]. Errors encountered (first 10): Batch entry 0 INSERT INTO extractie."extractie.ext_woz_objectcyclus" (BELOBJNR, INDGEBOUWD, HOOFDCODE_GEBR, DDINGANG, WOZBELOBJNR, DDEINDE) VALUES ( 2160, G, 1121, 1994-01-01 00:00:00.000000 +01:00:00, 011400002160, 2005-12-31 00:00:00.000000 +01:00:00) was aborted. Call getNextException to see the cause. ERROR: relation "extractie.extractie.ext_woz_objectcyclus" does not exist Error updating batch Batch entry 0 INSERT INTO extractie."extractie.ext_woz_objectcyclus" (BELOBJNR, INDGEBOUWD, HOOFDCODE_GEBR, DDINGANG, WOZBELOBJNR, DDEINDE) VALUES ( 2160, G, 1121, 1994-01-01 00:00:00.000000 +01:00:00, 011400002160, 2005-12-31 00:00:00.000000 +01:00:00) was aborted. Call getNextException to see the cause.

Pentaho BI Platform Tracking | Rutger Deterd Oude Weme | 9 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    [PDI-1679] schema qualifing table output is not working for postgresql connection - Pentaho BI Platform Tracking

    pentaho.com | 1 year ago
    org.pentaho.di.core.exception.KettleException: Error batch inserting rows into table . Errors encountered (first 10): Batch entry 0 INSERT INTO extractie."extractie.ext_woz_objectcyclus" (BELOBJNR, INDGEBOUWD, HOOFDCODE_GEBR, DDINGANG, WOZBELOBJNR, DDEINDE) VALUES ( 2160, G, 1121, 1994-01-01 00:00:00.000000 +01:00:00, 011400002160, 2005-12-31 00:00:00.000000 +01:00:00) was aborted. Call getNextException to see the cause. ERROR: relation "extractie.extractie.ext_woz_objectcyclus" does not exist Error updating batch Batch entry 0 INSERT INTO extractie."extractie.ext_woz_objectcyclus" (BELOBJNR, INDGEBOUWD, HOOFDCODE_GEBR, DDINGANG, WOZBELOBJNR, DDEINDE) VALUES ( 2160, G, 1121, 1994-01-01 00:00:00.000000 +01:00:00, 011400002160, 2005-12-31 00:00:00.000000 +01:00:00) was aborted. Call getNextException to see the cause.
  2. 0

    when using a target schema value in the table output properties with an connection to an postgresql database gives the following error message: (the schema is "extractie", what kettle does wrong is qualifing twice) Prepared statement : INSERT INTO extractie."extractie.ext_woz_objectcyclus" (BELOBJNR, INDGEBOUWD, HOOFDCODE_GEBR, DDINGANG, WOZBELOBJNR, DDEINDE) VALUES ( ?, ?, ?, ?, ?, ?) Because of an error, this step can't continue: org.pentaho.di.core.exception.KettleException: Error batch inserting rows into table [extractie.ext_woz_objectcyclus]. Errors encountered (first 10): Batch entry 0 INSERT INTO extractie."extractie.ext_woz_objectcyclus" (BELOBJNR, INDGEBOUWD, HOOFDCODE_GEBR, DDINGANG, WOZBELOBJNR, DDEINDE) VALUES ( 2160, G, 1121, 1994-01-01 00:00:00.000000 +01:00:00, 011400002160, 2005-12-31 00:00:00.000000 +01:00:00) was aborted. Call getNextException to see the cause. ERROR: relation "extractie.extractie.ext_woz_objectcyclus" does not exist Error updating batch Batch entry 0 INSERT INTO extractie."extractie.ext_woz_objectcyclus" (BELOBJNR, INDGEBOUWD, HOOFDCODE_GEBR, DDINGANG, WOZBELOBJNR, DDEINDE) VALUES ( 2160, G, 1121, 1994-01-01 00:00:00.000000 +01:00:00, 011400002160, 2005-12-31 00:00:00.000000 +01:00:00) was aborted. Call getNextException to see the cause. at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:337) at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:78) at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2654) at org.pentaho.di.trans.steps.tableoutput.TableOutput.run(TableOutput.java:630) Caused by: org.pentaho.di.core.exception.KettleDatabaseBatchException: Error updating batch Batch entry 0 INSERT INTO extractie."extractie.ext_woz_objectcyclus" (BELOBJNR, INDGEBOUWD, HOOFDCODE_GEBR, DDINGANG, WOZBELOBJNR, DDEINDE) VALUES ( 2160, G, 1121, 1994-01-01 00:00:00.000000 +01:00:00, 011400002160, 2005-12-31 00:00:00.000000 +01:00:00) was aborted. Call getNextException to see the cause. at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:251) ... 3 more Caused by: java.sql.BatchUpdateException: Batch entry 0 INSERT INTO extractie."extractie.ext_woz_objectcyclus" (BELOBJNR, INDGEBOUWD, HOOFDCODE_GEBR, DDINGANG, WOZBELOBJNR, DDEINDE) VALUES ( 2160, G, 1121, 1994-01-01 00:00:00.000000 +01:00:00, 011400002160, 2005-12-31 00:00:00.000000 +01:00:00) was aborted. Call getNextException to see the cause. at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2534) at org.postgresql.core.v3.QueryExecutorImpl$ErrorTrackingResultHandler.handleError(QueryExecutorImpl.java:282) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1317) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:331) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2596) at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:246) ... 3 more (the sql button and functionality works fine though) version 3.1.0-RC1, build 771 from 2008/07/08 11:57:26

    Pentaho BI Platform Tracking | 9 years ago | Rutger Deterd Oude Weme
    org.pentaho.di.core.exception.KettleException: Error batch inserting rows into table [extractie.ext_woz_objectcyclus]. Errors encountered (first 10): Batch entry 0 INSERT INTO extractie."extractie.ext_woz_objectcyclus" (BELOBJNR, INDGEBOUWD, HOOFDCODE_GEBR, DDINGANG, WOZBELOBJNR, DDEINDE) VALUES ( 2160, G, 1121, 1994-01-01 00:00:00.000000 +01:00:00, 011400002160, 2005-12-31 00:00:00.000000 +01:00:00) was aborted. Call getNextException to see the cause. ERROR: relation "extractie.extractie.ext_woz_objectcyclus" does not exist Error updating batch Batch entry 0 INSERT INTO extractie."extractie.ext_woz_objectcyclus" (BELOBJNR, INDGEBOUWD, HOOFDCODE_GEBR, DDINGANG, WOZBELOBJNR, DDEINDE) VALUES ( 2160, G, 1121, 1994-01-01 00:00:00.000000 +01:00:00, 011400002160, 2005-12-31 00:00:00.000000 +01:00:00) was aborted. Call getNextException to see the cause.
  3. 0

    when using a target schema value in the table output properties with an connection to an postgresql database gives the following error message: (the schema is "extractie", what kettle does wrong is qualifing twice) Prepared statement : INSERT INTO extractie."extractie.ext_woz_objectcyclus" (BELOBJNR, INDGEBOUWD, HOOFDCODE_GEBR, DDINGANG, WOZBELOBJNR, DDEINDE) VALUES ( ?, ?, ?, ?, ?, ?) Because of an error, this step can't continue: org.pentaho.di.core.exception.KettleException: Error batch inserting rows into table [extractie.ext_woz_objectcyclus]. Errors encountered (first 10): Batch entry 0 INSERT INTO extractie."extractie.ext_woz_objectcyclus" (BELOBJNR, INDGEBOUWD, HOOFDCODE_GEBR, DDINGANG, WOZBELOBJNR, DDEINDE) VALUES ( 2160, G, 1121, 1994-01-01 00:00:00.000000 +01:00:00, 011400002160, 2005-12-31 00:00:00.000000 +01:00:00) was aborted. Call getNextException to see the cause. ERROR: relation "extractie.extractie.ext_woz_objectcyclus" does not exist Error updating batch Batch entry 0 INSERT INTO extractie."extractie.ext_woz_objectcyclus" (BELOBJNR, INDGEBOUWD, HOOFDCODE_GEBR, DDINGANG, WOZBELOBJNR, DDEINDE) VALUES ( 2160, G, 1121, 1994-01-01 00:00:00.000000 +01:00:00, 011400002160, 2005-12-31 00:00:00.000000 +01:00:00) was aborted. Call getNextException to see the cause. at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:337) at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:78) at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2654) at org.pentaho.di.trans.steps.tableoutput.TableOutput.run(TableOutput.java:630) Caused by: org.pentaho.di.core.exception.KettleDatabaseBatchException: Error updating batch Batch entry 0 INSERT INTO extractie."extractie.ext_woz_objectcyclus" (BELOBJNR, INDGEBOUWD, HOOFDCODE_GEBR, DDINGANG, WOZBELOBJNR, DDEINDE) VALUES ( 2160, G, 1121, 1994-01-01 00:00:00.000000 +01:00:00, 011400002160, 2005-12-31 00:00:00.000000 +01:00:00) was aborted. Call getNextException to see the cause. at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:251) ... 3 more Caused by: java.sql.BatchUpdateException: Batch entry 0 INSERT INTO extractie."extractie.ext_woz_objectcyclus" (BELOBJNR, INDGEBOUWD, HOOFDCODE_GEBR, DDINGANG, WOZBELOBJNR, DDEINDE) VALUES ( 2160, G, 1121, 1994-01-01 00:00:00.000000 +01:00:00, 011400002160, 2005-12-31 00:00:00.000000 +01:00:00) was aborted. Call getNextException to see the cause. at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2534) at org.postgresql.core.v3.QueryExecutorImpl$ErrorTrackingResultHandler.handleError(QueryExecutorImpl.java:282) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1317) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:331) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2596) at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:246) ... 3 more (the sql button and functionality works fine though) version 3.1.0-RC1, build 771 from 2008/07/08 11:57:26

    Pentaho BI Platform Tracking | 9 years ago | Rutger Deterd Oude Weme
    org.pentaho.di.core.exception.KettleException: Error batch inserting rows into table [extractie.ext_woz_objectcyclus]. Errors encountered (first 10): Batch entry 0 INSERT INTO extractie."extractie.ext_woz_objectcyclus" (BELOBJNR, INDGEBOUWD, HOOFDCODE_GEBR, DDINGANG, WOZBELOBJNR, DDEINDE) VALUES ( 2160, G, 1121, 1994-01-01 00:00:00.000000 +01:00:00, 011400002160, 2005-12-31 00:00:00.000000 +01:00:00) was aborted. Call getNextException to see the cause. ERROR: relation "extractie.extractie.ext_woz_objectcyclus" does not exist Error updating batch Batch entry 0 INSERT INTO extractie."extractie.ext_woz_objectcyclus" (BELOBJNR, INDGEBOUWD, HOOFDCODE_GEBR, DDINGANG, WOZBELOBJNR, DDEINDE) VALUES ( 2160, G, 1121, 1994-01-01 00:00:00.000000 +01:00:00, 011400002160, 2005-12-31 00:00:00.000000 +01:00:00) was aborted. Call getNextException to see the cause.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

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

    stackexchange.com | 2 years 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.
  6. 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.

    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 0 INSERT INTO extractie."extractie.ext_woz_objectcyclus" (BELOBJNR, INDGEBOUWD, HOOFDCODE_GEBR, DDINGANG, WOZBELOBJNR, DDEINDE) VALUES ( 2160, G, 1121, 1994-01-01 00:00:00.000000 +01:00:00, 011400002160, 2005-12-31 00:00:00.000000 +01:00:00) 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:2534)
      2. org.postgresql.core.v3.QueryExecutorImpl$ErrorTrackingResultHandler.handleError(QueryExecutorImpl.java:282)
      3. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1317)
      4. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:331)
      5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2596)
      5 frames
    3. org.pentaho.di
      TableOutput.run
      1. org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:246)
      2. org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:78)
      3. org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2654)
      4. org.pentaho.di.trans.steps.tableoutput.TableOutput.run(TableOutput.java:630)
      4 frames