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

Google Groups | Tomo Suryolaksono | 2 years ago
  1. 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
  2. 0

    Kettle job synchronization problem.

    openbravopos | 8 years ago | bennylhy
    org.pentaho.di.core.exception.KettleDatabaseException: 2009/03/27 15:35:28 - I/U PRODUCTS.0 - ERROR (version 3.1.0, build 826 from 2009/03/27 12:09:39) : Couldn't get row from result set 2009/03/27 15:35:28 - I/U PRODUCTS.0 - ERROR (version 3.1.0, build 826 from 2009/03/27 12:09:39) : ERROR: large object 800011 does not exist 2009/03/27 15:35:28 - I/U PRODUCTS.0 - ERROR (version 3.1.0, build 826 from 2009/03/27 12:09:39) :
  3. 0

    Kettle job synchronization problem.

    openbravopos | 8 years ago | bennylhy
    org.pentaho.di.core.exception.KettleDatabaseException: 2009/03/26 12:59:44 - Insert/Update TAXCATEGORIES.0 - ERROR (version 3.1.0, build 826 from 2009/03/26 12:22:09) : Error looking up row in database 2009/03/26 12:59:44 - Insert/Update TAXCATEGORIES.0 - ERROR (version 3.1.0, build 826 from 2009/03/26 12:22:09) : ERROR: relation "taxcategories" does not exist 2009/03/26 12:59:44 - Insert/Update TAXCATEGORIES.0 - ERROR (version 3.1.0, build 826 from 2009/03/26 12:22:09) :
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    IO Error: Socket read timed out when using the Table Input in transformation

    pentaho.com | 8 months ago
    org.pentaho.di.core.exception.KettleDatabaseException: - Couldn't get row from result set - IO Error: Socket read timed out
  6. 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'

    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

      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

      at org.pentaho.di.core.database.Database.getRow()
    2. org.pentaho.di
      Database.getRow
      1. org.pentaho.di.core.database.Database.getRow(Database.java:2861)
      1 frame