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.

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web189

  • via Unknown by Rutger Deterd Oude Weme,
  • via Unknown by Rutger Deterd Oude Weme,
  • Stack trace

    • 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

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    6 more bugmates