Saya menggunakan Table Input dimana terdapat kolom "tanggal" dengan tipe data datetime
2014/10/30 10:19:47 - Trans - This transformation can be replayed with replay date: 2014/10/30 10:19:47
2014/10/30 10:19:47 - Transaksi.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : Unexpected error :
2014/10/30 10:19:47 - Transaksi.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : 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 2008/09/30 11:32:36) : at org.pentaho.di.core.database.Database.getRow(Database.java:2861)
2014/10/30 10:19:47 - Transaksi.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : at org.pentaho.di.core.database.Database.getRow(Database.java:2776)
2014/10/30 10:19:47 - Transaksi.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:137)
2014/10/30 10:19:47 - Transaksi.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2664)
2014/10/30 10:19:47 - Transaksi.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : at org.pentaho.di.trans.steps.tableinput.TableInput.run(TableInput.java:343)
2014/10/30 10:19:47 - Transaksi.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : Caused by: java.sql.SQLException: 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) : at com.mysql.jdbc.ResultSet.getNativeTimestamp(ResultSet.java:3918)
2014/10/30 10:19:47 - Transaksi.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : at com.mysql.jdbc.ResultSet.getTimestampInternal(ResultSet.java:5561)
2014/10/30 10:19:47 - Transaksi.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : at com.mysql.jdbc.ResultSet.getTimestamp(ResultSet.java:5219)
2014/10/30 10:19:47 - Transaksi.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : at org.pentaho.di.core.database.Database.getRow(Database.java:2841)
2014/10/30 10:19:47 - Transaksi.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : ... 4 more
2014/10/30 10:19:47 - Transaksi.0 - Finished reading query, closing connection.
2014/10/30 10:19:47 - dummy.0 - Finished processing (I=0, O=0, R=4, W=4, U=4, E=0)
2014/10/30 10:19:47 - Transaksi.0 - Finished processing (I=103, O=0, R=0, W=102, U=102, E=1)
2014/10/30 10:19:47 - Kettle - Transformation detected one or more steps with errors.
2014/10/30 10:19:47 - Kettle - Transformation is killing the other steps!
dan dengan preview, datanya tetap muncul tapi data dari tabel input tersebut tidak keluar semua.
Waktu saya googling error semacam ini muncul karena kesalahan dari mysql dan harus mensetting database connection dengan zeroDateTimeBehavior = convertToNull