Search code examples
mysqlamazon-s3pentaho-spoon

PDI Timestamp : Unable to get timestamp from resultset at index 5

I have a transformation in PDI which basically read data from amazon S3 bucket and push data into mysql database.But today i am facing below error in PDI in time of transformation execution.

org.pentaho.di.core.exception.KettleDatabaseException: 
Couldn't get row from result set

Timestamp : Unable to get timestamp from resultset at index 5
Value '37467412015-04-18 13:58:472015-04-18 13:58:4700000-00-00 00:00:001:138' can not be represented as java.sql.Timestamp


at org.pentaho.di.core.database.Database.getRow(Database.java:2397)
at org.pentaho.di.core.database.Database.getRow(Database.java:2368)
at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:145)
at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.pentaho.di.core.exception.KettleDatabaseException:

I have already used zeroDateTimeBehavior = convertToNull option in PDI

Solution

  • Go to database connection window then select Option then put below values

    Parameter=zeroDateTimeBehavior
Value= convertToNull

    Then restart spoon