org.pentaho.di.core.exception.KettleException: An error occurred while writing the kettle metrics data to a log table Unable to write log record to log table op_log_channel Error inserting/updating row Unknown column 'METRICS_DATE' in 'field list'

Pentaho BI Platform Tracking | Jens Bleuel | 4 years ago
  1. 0

    Reproduction: - Within kettle.properties set: KETTLE_CHANNEL_LOG_DB=operations_db KETTLE_CHANNEL_LOG_TABLE=op_log_channel - Make sure the Channel log table is existing - run a simple test transformation, the following exception is thrown: ERROR (version 5.0.0-M1 from 2013/04/18 14:03:51.618) : Error writing metrics information ERROR (version 5.0.0-M1 from 2013/04/18 14:03:51.618) : org.pentaho.di.core.exception.KettleException: An error occurred while writing the kettle metrics data to a log table Unable to write log record to log table op_log_channel Error inserting/updating row Unknown column 'METRICS_DATE' in 'field list' at org.pentaho.di.trans.Trans.writeMetricsInformation(Trans.java:2298) at org.pentaho.di.trans.Trans$3.transFinished(Trans.java:1200) at org.pentaho.di.trans.Trans.fireTransFinishedListeners(Trans.java:1318) at org.pentaho.di.trans.Trans$1.stepFinished(Trans.java:1123) at org.pentaho.di.trans.step.BaseStep.markStop(BaseStep.java:2704) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:118) at java.lang.Thread.run(Unknown Source) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Unable to write log record to log table op_log_channel Error inserting/updating row Unknown column 'METRICS_DATE' in 'field list' at org.pentaho.di.core.database.Database.writeLogRecord(Database.java:3109)

    Pentaho BI Platform Tracking | 4 years ago | Jens Bleuel
    org.pentaho.di.core.exception.KettleException: An error occurred while writing the kettle metrics data to a log table Unable to write log record to log table op_log_channel Error inserting/updating row Unknown column 'METRICS_DATE' in 'field list'
  2. 0

    Reproduction: - Within kettle.properties set: KETTLE_CHANNEL_LOG_DB=operations_db KETTLE_CHANNEL_LOG_TABLE=op_log_channel - Make sure the Channel log table is existing - run a simple test transformation, the following exception is thrown: ERROR (version 5.0.0-M1 from 2013/04/18 14:03:51.618) : Error writing metrics information ERROR (version 5.0.0-M1 from 2013/04/18 14:03:51.618) : org.pentaho.di.core.exception.KettleException: An error occurred while writing the kettle metrics data to a log table Unable to write log record to log table op_log_channel Error inserting/updating row Unknown column 'METRICS_DATE' in 'field list' at org.pentaho.di.trans.Trans.writeMetricsInformation(Trans.java:2298) at org.pentaho.di.trans.Trans$3.transFinished(Trans.java:1200) at org.pentaho.di.trans.Trans.fireTransFinishedListeners(Trans.java:1318) at org.pentaho.di.trans.Trans$1.stepFinished(Trans.java:1123) at org.pentaho.di.trans.step.BaseStep.markStop(BaseStep.java:2704) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:118) at java.lang.Thread.run(Unknown Source) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Unable to write log record to log table op_log_channel Error inserting/updating row Unknown column 'METRICS_DATE' in 'field list' at org.pentaho.di.core.database.Database.writeLogRecord(Database.java:3109)

    Pentaho BI Platform Tracking | 4 years ago | Jens Bleuel
    org.pentaho.di.core.exception.KettleException: An error occurred while writing the kettle metrics data to a log table Unable to write log record to log table op_log_channel Error inserting/updating row Unknown column 'METRICS_DATE' in 'field list'
  3. 0

    Reproduction: - In Spoon 4.4 create a log table in a simple transformation (see attachment) - let it run in Spoon 4.4 - look at the execution history (refresh) and see one log line - Close Spoon 4.4 - Open Spoon 5.0 (on Windows, use SpoonConsole.bat to see the exception mentioned below) - it automatically opens the previous transformation - It opens the Execution history but this is empty The following exception is shown on the console: Unable to get rows of data from logging table test_dbx-log_table4_5_test org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL: SELECT ID_JOB, STATUS, LINES_READ, LINES_WRITTEN, LINES_UPDATED, LINES_INPUT, LINES_OUTPUT, LINES_REJECTED, ERRORS, STARTDATE, ENDDATE, LOGDATE, DEPDATE, REPLAYDATE, LOG_FIELD, EXECUTING_SERVER, EXECUTING_USER, START_JOB_ENTRY, CLIENT FROM log_table4_5_test WHERE JOBNAME LIKE ? ORDER BY ID_JOB DESC Unknown column 'EXECUTING_SERVER' in 'field list' at org.pentaho.di.core.database.Database.openQuery(Database.java:1610) [...] Note: - We added the fields EXECUTING_SERVER, EXECUTING_USER and CLIENT to the log table in 5.0 - I propose to make these fields disabled by default to keep compatible with previous log tables

    Pentaho BI Platform Tracking | 4 years ago | Jens Bleuel
    org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL: SELECT ID_JOB, STATUS, LINES_READ, LINES_WRITTEN, LINES_UPDATED, LINES_INPUT, LINES_OUTPUT, LINES_REJECTED, ERRORS, STARTDATE, ENDDATE, LOGDATE, DEPDATE, REPLAYDATE, LOG_FIELD, EXECUTING_SERVER, EXECUTING_USER, START_JOB_ENTRY, CLIENT FROM log_table4_5_test WHERE JOBNAME LIKE ? ORDER BY ID_JOB DESC Unknown column 'EXECUTING_SERVER' in 'field list'
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Apache thrift transportaion TTransportException error while using Hive data integration using Pentaho

    Stack Overflow | 2 years ago | Jiten Patel
    org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database</p> <p>Error connecting to database: (using class org.apache.hadoop.hive.jdbc.HiveDriver) org.apache.thrift.transport.TTransportException</p> <pre><code>at org.pentaho.di.core.database.Database.normalConnect(Database.java:428)
  6. 0

    Value '0000-00-0' can not be represented as java.sql.Date

    Google Groups | 2 years ago | Tomo Suryolaksono
    org.pentaho.di.core.exception.KettleDatabaseException: 2014/10/30 10:19:47 - Transaksi.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : Couldn't get row from result set 2014/10/30 10:19:47 - Transaksi.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : Value '0000-00-00' can not be represented as java.sql.Timestamp 2014/10/30 10:19:47 - Transaksi.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : 2014/10/30 10:19:47 - Transaksi.0 - ERROR (version 3.1.0, build 826 from

    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.KettleDatabaseException

      Unable to write log record to log table op_log_channel Error inserting/updating row Unknown column 'METRICS_DATE' in 'field list'

      at org.pentaho.di.core.database.Database.writeLogRecord()
    2. org.pentaho.di
      Database.writeLogRecord
      1. org.pentaho.di.core.database.Database.writeLogRecord(Database.java:3109)
      1 frame