Cannot convert value '2006' from column 4 to TIMESTAMP.

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web8505

  • via Stack Overflow by g_p
    , 9 months ago
    Cannot convert value '2006' from column 4 to TIMESTAMP.
  • Cannot convert value '2016-06-13 05:56:59.000' from column 4 to TIMESTAMP.
  • via GitHub by scanbit
    , 1 year ago
    Cannot convert value '0000-00-00 00:00:00' from column 4 to TIMESTAMP.
  • Stack trace

    • java.sql.SQLException: Cannot convert value '2006' from column 4 to TIMESTAMP. at scriptella.execution.EtlExecutor.execute( at com.zensar.scrptellaTest.App.main( Caused by: scriptella.core.ExceptionInterceptor$ExecutionException: /etl/query[1]/script[1] failed: Unable to get parameter 4 at scriptella.core.ExceptionInterceptor.execute( at scriptella.core.QueryExecutor$QueryCtxDecorator.processRow( at scriptella.jdbc.StatementWrapper.query( at scriptella.jdbc.SqlExecutor.statementParsed( at scriptella.jdbc.SqlParserBase.handleStatement( at scriptella.jdbc.SqlParserBase.parse( at scriptella.jdbc.SqlExecutor.execute( at scriptella.jdbc.JdbcConnection.executeQuery( at scriptella.core.QueryExecutor.execute( at scriptella.core.ContentExecutor.execute( at scriptella.core.ElementInterceptor.executeNext( at scriptella.core.StatisticInterceptor.execute( at scriptella.core.ElementInterceptor.executeNext( at scriptella.core.ConnectionInterceptor.execute( at scriptella.core.ElementInterceptor.executeNext( at scriptella.core.ExceptionInterceptor.execute( at scriptella.core.Session.execute( at scriptella.execution.EtlExecutor.execute( at scriptella.execution.EtlExecutor.execute( ... 1 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You’re the first here who have seen this exception.