org.pentaho.di.core.exception.KettleException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • 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
    via by Rutger Deterd Oude Weme,
  • 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
    via by Rutger Deterd Oude Weme,
  • ImageMosaic-JDBC Error
    via Geographic Information Systems by user17653
    ,
    • 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

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    6 more bugmates