org.pentaho.di.core.exception.KettleException: Impossibile eseguire logging alla fine della trasformazione Errore di scrittura dei record di log sulle performance del passo Error updating batch L'operazione «batch» 1 INSERT INTO etl.performance (ID_BATCH, SEQ_NR, LOGDATE, TRANSNAME, STEPNAME, STEP_COPY, LINES_READ, LINES_WRITTEN, LINES_UPDATED, LINES_INPUT, LINES_OUTPUT, LINES_REJECTED, ERRORS, INPUT_BUFFER_ROWS, OUTPUT_BUFFER_ROWS) VALUES ( '0', '1', '2013-04-10 19:18:34.742000 +02:00:00', 'import_country', 'Output', '0', '236', '236', '0', '0', '0', '0', '0', '0', '0') è stata interrotta. Chiamare «getNextException» per scoprirne il motivo.

Pentaho BI Platform Tracking | Nicola Benaglia | 4 years ago
  1. 0

    Running SPOON without logging, it execute these transformations: INFO 10-04 19:11:31,307 - ::: Running transformation: /home/nicola/Scaricati/data-integration-4.4.0/plugins/spoon/agile-bi/platform/pentaho-solutions/system/pentaho-geo/dataimport/import_country.ktr INFO 10-04 19:11:31,603 - ::: Read 236 lines from /home/nicola/Scaricati/data-integration-4.4.0/plugins/spoon/agile-bi/platform/pentaho-solutions/system/pentaho-geo/dataimport/import_country.ktr INFO 10-04 19:11:31,606 - ::: Running transformation: /home/nicola/Scaricati/data-integration-4.4.0/plugins/spoon/agile-bi/platform/pentaho-solutions/system/pentaho-geo/dataimport/import_custom.ktr INFO 10-04 19:11:31,636 - ::: Read 248 lines from /home/nicola/Scaricati/data-integration-4.4.0/plugins/spoon/agile-bi/platform/pentaho-solutions/system/pentaho-geo/dataimport/import_custom.ktr If I want to enable LOGGING for all my transformations and job I edit my kettle.properties file with the needed variables, for example: KETTLE_JOB_LOG_SCHEMA=etl KETTLE_PLUGIN_CLASSES= KETTLE_PERFORMANCE_LOGGING_SECS=10 KETTLE_CHANNEL_TIMEOUT_DAYS=100000 KETTLE_CORE_JOBENTRIES_FILE= KETTLE_ROWSET_GET_TIMEOUT=50 KETTLE_TRANS_LOG_DB=tpl KETTLE_CHANNEL_LOG_DB=tpl KETTLE_MAX_LOG_TIMEOUT_IN_MINUTES=1440 KETTLE_JOB_LOG_DB=tpl KETTLE_JOB_LOG_TABLE=job KETTLE_STEP_TIMEOUT_DAYS=100 KETTLE_TRANS_PAN_JVM_EXIT_CODE= KETTLE_TRANS_LOGGING_SECS=10 KETTLE_JOB_PERFORMANCE_LOG_TABLE=performance KETTLE_TRANS_PERFORMANCE_LOG_TABLE=performance KETTLE_ROWSET_PUT_TIMEOUT=50 KETTLE_MAX_JOB_ENTRIES_LOGGED=1000 [.....] But launching spoon again I get this error: INFO 10-04 19:18:34,228 - ::: Running transformation: /home/nicola/Scaricati/data-integration-4.4.0/plugins/spoon/agile-bi/platform/pentaho-solutions/system/pentaho-geo/dataimport/import_country.ktr ERROR 10-04 19:18:34,537 - ::: CsvReader.ERROR_0005 - Check error: /home/nicola/Scaricati/data-integration-4.4.0/plugins/spoon/agile-bi/platform/pentaho-solutions/system/pentaho-geo/dataimport/import_country.ktr, null ERROR 10-04 19:18:34,785 - import_country - import_country : Errore inatteso alla fine della trasformazione ERROR 10-04 19:18:34,786 - import_country - org.pentaho.di.core.exception.KettleException: Impossibile eseguire logging alla fine della trasformazione Errore di scrittura dei record di log sulle performance del passo Error updating batch L'operazione «batch» 1 INSERT INTO etl.performance (ID_BATCH, SEQ_NR, LOGDATE, TRANSNAME, STEPNAME, STEP_COPY, LINES_READ, LINES_WRITTEN, LINES_UPDATED, LINES_INPUT, LINES_OUTPUT, LINES_REJECTED, ERRORS, INPUT_BUFFER_ROWS, OUTPUT_BUFFER_ROWS) VALUES ( '0', '1', '2013-04-10 19:18:34.742000 +02:00:00', 'import_country', 'Output', '0', '236', '236', '0', '0', '0', '0', '0', '0', '0') è stata interrotta. Chiamare «getNextException» per scoprirne il motivo. at org.pentaho.di.trans.Trans$7.transFinished(Trans.java:1991) at org.pentaho.di.trans.Trans.fireTransFinishedListeners(Trans.java:1180) at org.pentaho.di.trans.Trans$1.stepFinished(Trans.java:999) at org.pentaho.di.trans.step.BaseStep.markStop(BaseStep.java:2640) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:98) at java.lang.Thread.run(Thread.java:662) Caused by: org.pentaho.di.core.exception.KettleException: Errore di scrittura dei record di log sulle performance del passo Error updating batch L'operazione «batch» 1 INSERT INTO etl.performance (ID_BATCH, SEQ_NR, LOGDATE, TRANSNAME, STEPNAME, STEP_COPY, LINES_READ, LINES_WRITTEN, LINES_UPDATED, LINES_INPUT, LINES_OUTPUT, LINES_REJECTED, ERRORS, INPUT_BUFFER_ROWS, OUTPUT_BUFFER_ROWS) VALUES ( '0', '1', '2013-04-10 19:18:34.742000 +02:00:00', 'import_country', 'Output', '0', '236', '236', '0', '0', '0', '0', '0', '0', '0') è stata interrotta. Chiamare «getNextException» per scoprirne il motivo. [...] It seems that those unknowns transformations (import_country.ktr, import_customs.ktr) causes the error. Bye.

    Pentaho BI Platform Tracking | 4 years ago | Nicola Benaglia
    org.pentaho.di.core.exception.KettleException: Impossibile eseguire logging alla fine della trasformazione Errore di scrittura dei record di log sulle performance del passo Error updating batch L'operazione «batch» 1 INSERT INTO etl.performance (ID_BATCH, SEQ_NR, LOGDATE, TRANSNAME, STEPNAME, STEP_COPY, LINES_READ, LINES_WRITTEN, LINES_UPDATED, LINES_INPUT, LINES_OUTPUT, LINES_REJECTED, ERRORS, INPUT_BUFFER_ROWS, OUTPUT_BUFFER_ROWS) VALUES ( '0', '1', '2013-04-10 19:18:34.742000 +02:00:00', 'import_country', 'Output', '0', '236', '236', '0', '0', '0', '0', '0', '0', '0') è stata interrotta. Chiamare «getNextException» per scoprirne il motivo.
  2. 0

    Running SPOON without logging, it execute these transformations: INFO 10-04 19:11:31,307 - ::: Running transformation: /home/nicola/Scaricati/data-integration-4.4.0/plugins/spoon/agile-bi/platform/pentaho-solutions/system/pentaho-geo/dataimport/import_country.ktr INFO 10-04 19:11:31,603 - ::: Read 236 lines from /home/nicola/Scaricati/data-integration-4.4.0/plugins/spoon/agile-bi/platform/pentaho-solutions/system/pentaho-geo/dataimport/import_country.ktr INFO 10-04 19:11:31,606 - ::: Running transformation: /home/nicola/Scaricati/data-integration-4.4.0/plugins/spoon/agile-bi/platform/pentaho-solutions/system/pentaho-geo/dataimport/import_custom.ktr INFO 10-04 19:11:31,636 - ::: Read 248 lines from /home/nicola/Scaricati/data-integration-4.4.0/plugins/spoon/agile-bi/platform/pentaho-solutions/system/pentaho-geo/dataimport/import_custom.ktr If I want to enable LOGGING for all my transformations and job I edit my kettle.properties file with the needed variables, for example: KETTLE_JOB_LOG_SCHEMA=etl KETTLE_PLUGIN_CLASSES= KETTLE_PERFORMANCE_LOGGING_SECS=10 KETTLE_CHANNEL_TIMEOUT_DAYS=100000 KETTLE_CORE_JOBENTRIES_FILE= KETTLE_ROWSET_GET_TIMEOUT=50 KETTLE_TRANS_LOG_DB=tpl KETTLE_CHANNEL_LOG_DB=tpl KETTLE_MAX_LOG_TIMEOUT_IN_MINUTES=1440 KETTLE_JOB_LOG_DB=tpl KETTLE_JOB_LOG_TABLE=job KETTLE_STEP_TIMEOUT_DAYS=100 KETTLE_TRANS_PAN_JVM_EXIT_CODE= KETTLE_TRANS_LOGGING_SECS=10 KETTLE_JOB_PERFORMANCE_LOG_TABLE=performance KETTLE_TRANS_PERFORMANCE_LOG_TABLE=performance KETTLE_ROWSET_PUT_TIMEOUT=50 KETTLE_MAX_JOB_ENTRIES_LOGGED=1000 [.....] But launching spoon again I get this error: INFO 10-04 19:18:34,228 - ::: Running transformation: /home/nicola/Scaricati/data-integration-4.4.0/plugins/spoon/agile-bi/platform/pentaho-solutions/system/pentaho-geo/dataimport/import_country.ktr ERROR 10-04 19:18:34,537 - ::: CsvReader.ERROR_0005 - Check error: /home/nicola/Scaricati/data-integration-4.4.0/plugins/spoon/agile-bi/platform/pentaho-solutions/system/pentaho-geo/dataimport/import_country.ktr, null ERROR 10-04 19:18:34,785 - import_country - import_country : Errore inatteso alla fine della trasformazione ERROR 10-04 19:18:34,786 - import_country - org.pentaho.di.core.exception.KettleException: Impossibile eseguire logging alla fine della trasformazione Errore di scrittura dei record di log sulle performance del passo Error updating batch L'operazione «batch» 1 INSERT INTO etl.performance (ID_BATCH, SEQ_NR, LOGDATE, TRANSNAME, STEPNAME, STEP_COPY, LINES_READ, LINES_WRITTEN, LINES_UPDATED, LINES_INPUT, LINES_OUTPUT, LINES_REJECTED, ERRORS, INPUT_BUFFER_ROWS, OUTPUT_BUFFER_ROWS) VALUES ( '0', '1', '2013-04-10 19:18:34.742000 +02:00:00', 'import_country', 'Output', '0', '236', '236', '0', '0', '0', '0', '0', '0', '0') è stata interrotta. Chiamare «getNextException» per scoprirne il motivo. at org.pentaho.di.trans.Trans$7.transFinished(Trans.java:1991) at org.pentaho.di.trans.Trans.fireTransFinishedListeners(Trans.java:1180) at org.pentaho.di.trans.Trans$1.stepFinished(Trans.java:999) at org.pentaho.di.trans.step.BaseStep.markStop(BaseStep.java:2640) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:98) at java.lang.Thread.run(Thread.java:662) Caused by: org.pentaho.di.core.exception.KettleException: Errore di scrittura dei record di log sulle performance del passo Error updating batch L'operazione «batch» 1 INSERT INTO etl.performance (ID_BATCH, SEQ_NR, LOGDATE, TRANSNAME, STEPNAME, STEP_COPY, LINES_READ, LINES_WRITTEN, LINES_UPDATED, LINES_INPUT, LINES_OUTPUT, LINES_REJECTED, ERRORS, INPUT_BUFFER_ROWS, OUTPUT_BUFFER_ROWS) VALUES ( '0', '1', '2013-04-10 19:18:34.742000 +02:00:00', 'import_country', 'Output', '0', '236', '236', '0', '0', '0', '0', '0', '0', '0') è stata interrotta. Chiamare «getNextException» per scoprirne il motivo. [...] It seems that those unknowns transformations (import_country.ktr, import_customs.ktr) causes the error. Bye.

    Pentaho BI Platform Tracking | 4 years ago | Nicola Benaglia
    org.pentaho.di.core.exception.KettleException: Impossibile eseguire logging alla fine della trasformazione Errore di scrittura dei record di log sulle performance del passo Error updating batch L'operazione «batch» 1 INSERT INTO etl.performance (ID_BATCH, SEQ_NR, LOGDATE, TRANSNAME, STEPNAME, STEP_COPY, LINES_READ, LINES_WRITTEN, LINES_UPDATED, LINES_INPUT, LINES_OUTPUT, LINES_REJECTED, ERRORS, INPUT_BUFFER_ROWS, OUTPUT_BUFFER_ROWS) VALUES ( '0', '1', '2013-04-10 19:18:34.742000 +02:00:00', 'import_country', 'Output', '0', '236', '236', '0', '0', '0', '0', '0', '0', '0') è stata interrotta. Chiamare «getNextException» per scoprirne il motivo.
  3. 0

    Elastic to Postgres data migration fails in kettle

    Stack Overflow | 2 years ago | Marlon Abeykoon
    org.pentaho.di.core.exception.KettleException: The data structure is not the same inside the resource! We found 1000 values for json path [$..LoginSessionId], which is different that the number retourned for path [$.ResourceChangeInfo..ResourceCode] (9325 values). We MUST have the same number of values for all paths.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Spoon PDI Data Validator Error

    Stack Overflow | 2 years ago | Paul
    org.pentaho.di.core.exception.KettleException: Correct Group/Dashboard Assignment Correct Group/Dashboard Assignment
  6. 0

    Error al realizar una transformacion con postgresql - Open Business Intelligence

    redopenbi.com | 1 year ago
    org.pentaho.di.core.exception.KettleException: 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 - Error batch inserting rows into table [ejecmensual]. 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 - Errors encountered (first 10): 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 - Batch entry 0 INSERT INTO transformationpentaho.ejecmensual (ano_eje, sec_ejec, pliego, ejecutora, sec_func, programa, prod_pry, act_ai_obra, funcion, division_func, grupo_func, meta, finalidad, unidad_medida, cantidad, departamento, provincia, distrito, origen, fuente_financ_agregada, fuente_financ, tipo_recurso, categ_gasto, tipo_transaccion, generica, subgenerica, subgenerica_det, especifica, especifica_det, presupuesto, modificacion, pim, m01, m02, m03, m04, m05, m06, m07, m08, m09, m10, m11, m12, total_prog, saldo, porcentaje) VALUES ( '2014',  '001309',  '050',  '001',  '0001',  '0035',  '3000603',  '5004399',  '17',  '054',  '0119',  '00001',  '0107477',  '00194',  '9.0',  '01',  '02',  '99',  NULL,  '1',  NULL,  NULL,  '5',  '2',  '3',  NULL,  NULL,  NULL,  NULL,  '3754.0',  '0.0',  '3754.0',  '190.0',  '600.0',  '0.0',  '630.0',  '77.5',  '658.5',  '0.0',  '0.0',  '0.0',  '0.0',  '0.0',  '0.0',  '2156.0',  '1598.0',  '57.43') was aborted.  Call getNextException to see the cause. 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 - ERROR: column "sec_ejec" of relation "ejecmensual" does not exist 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 -   Position: 57 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 - 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 - 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 - Error updating batch 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 - Batch entry 0 INSERT INTO transformationpentaho.ejecmensual (ano_eje, sec_ejec, pliego, ejecutora, sec_func, programa, prod_pry, act_ai_obra, funcion, division_func, grupo_func, meta, finalidad, unidad_medida, cantidad, departamento, provincia, distrito, origen, fuente_financ_agregada, fuente_financ, tipo_recurso, categ_gasto, tipo_transaccion, generica, subgenerica, subgenerica_det, especifica, especifica_det, presupuesto, modificacion, pim, m01, m02, m03, m04, m05, m06, m07, m08, m09, m10, m11, m12, total_prog, saldo, porcentaje) VALUES ( '2014',  '001309',  '050',  '001',  '0001',  '0035',  '3000603',  '5004399',  '17',  '054',  '0119',  '00001',  '0107477',  '00194',  '9.0',  '01',  '02',  '99',  NULL,  '1',  NULL,  NULL,  '5',  '2',  '3',  NULL,  NULL,  NULL,  NULL,  '3754.0',  '0.0',  '3754.0',  '190.0',  '600.0',  '0.0',  '630.0',  '77.5',  '658.5',  '0.0',  '0.0',  '0.0',  '0.0',  '0.0',  '0.0',  '2156.0',  '1598.0',  '57.43') was aborted.  Call getNextException to see the cause. 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 - 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 -

    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. org.pentaho.di.core.exception.KettleException

      Impossibile eseguire logging alla fine della trasformazione Errore di scrittura dei record di log sulle performance del passo Error updating batch L'operazione «batch» 1 INSERT INTO etl.performance (ID_BATCH, SEQ_NR, LOGDATE, TRANSNAME, STEPNAME, STEP_COPY, LINES_READ, LINES_WRITTEN, LINES_UPDATED, LINES_INPUT, LINES_OUTPUT, LINES_REJECTED, ERRORS, INPUT_BUFFER_ROWS, OUTPUT_BUFFER_ROWS) VALUES ( '0', '1', '2013-04-10 19:18:34.742000 +02:00:00', 'import_country', 'Output', '0', '236', '236', '0', '0', '0', '0', '0', '0', '0') è stata interrotta. Chiamare «getNextException» per scoprirne il motivo.

      at org.pentaho.di.trans.Trans$7.transFinished()
    2. org.pentaho.di
      RunThread.run
      1. org.pentaho.di.trans.Trans$7.transFinished(Trans.java:1991)
      2. org.pentaho.di.trans.Trans.fireTransFinishedListeners(Trans.java:1180)
      3. org.pentaho.di.trans.Trans$1.stepFinished(Trans.java:999)
      4. org.pentaho.di.trans.step.BaseStep.markStop(BaseStep.java:2640)
      5. org.pentaho.di.trans.step.RunThread.run(RunThread.java:98)
      5 frames
    3. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:662)
      1 frame