java.sql.SQLException

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(EtlExecutor.java:190) at com.zensar.scrptellaTest.App.main(App.java:21) Caused by: scriptella.core.ExceptionInterceptor$ExecutionException: /etl/query[1]/script[1] failed: Unable to get parameter 4 at scriptella.core.ExceptionInterceptor.execute(ExceptionInterceptor.java:44) at scriptella.core.QueryExecutor$QueryCtxDecorator.processRow(QueryExecutor.java:114) at scriptella.jdbc.StatementWrapper.query(StatementWrapper.java:92) at scriptella.jdbc.SqlExecutor.statementParsed(SqlExecutor.java:128) at scriptella.jdbc.SqlParserBase.handleStatement(SqlParserBase.java:129) at scriptella.jdbc.SqlParserBase.parse(SqlParserBase.java:72) at scriptella.jdbc.SqlExecutor.execute(SqlExecutor.java:85) at scriptella.jdbc.JdbcConnection.executeQuery(JdbcConnection.java:222) at scriptella.core.QueryExecutor.execute(QueryExecutor.java:71) at scriptella.core.ContentExecutor.execute(ContentExecutor.java:73) at scriptella.core.ElementInterceptor.executeNext(ElementInterceptor.java:56) at scriptella.core.StatisticInterceptor.execute(StatisticInterceptor.java:41) at scriptella.core.ElementInterceptor.executeNext(ElementInterceptor.java:56) at scriptella.core.ConnectionInterceptor.execute(ConnectionInterceptor.java:36) at scriptella.core.ElementInterceptor.executeNext(ElementInterceptor.java:56) at scriptella.core.ExceptionInterceptor.execute(ExceptionInterceptor.java:39) at scriptella.core.Session.execute(Session.java:103) at scriptella.execution.EtlExecutor.execute(EtlExecutor.java:227) at scriptella.execution.EtlExecutor.execute(EtlExecutor.java:183) ... 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.