5.10 Invalid column type: 1111

tunney — Fri, 06 Jun 2014 16:37:05 GMT

I'm upgrading my application to run on 5.10, was on 5.9On startup I am getting the below exception and I am lost. Any suggestions?### Error querying database. Cause: org.hibernate.exception.GenericJDBCException: Invalid column type: 1111### The error may involve org.activiti.engine.impl.persistence

Re: 5.10 Invalid column type: 1111

tunney — Fri, 06 Jun 2014 17:09:27 GMT

Actually the H2 database version of the error is a little more informative but again no idea why it is occurring?

Caused by: org.h2.jdbc.JdbcSQLException: Data conversion error converting "2014-06-06 18:08:47.397"; SQL statement:
select
     JOB.*
    from ACT_RU_JOB JOB
     LEFT OUTER JOIN ACT_RU_EXECUTION PI ON PI.ID_ = JOB.PROCESS_INSTANCE_ID_
     LEFT OUTER JOIN ACT_RE_PROCDEF PD ON PD.ID_ = PI.PROC_DEF_ID_
    where (JOB.RETRIES_ > 0)
      and (JOB.DUEDATE_ is null or JOB.DUEDATE_ < ?)
      and (JOB.LOCK_OWNER_ is null or JOB.LOCK_EXP_TIME_ < ?)
   and (
        (JOB.EXECUTION_ID_ is null)
     or ((PI.SUSPENSION_STATE_ = 1)
         and (PD.SUSPENSION_STATE_ = 1))
      )
    LIMIT ? OFFSET ? [22018-163]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:158)
at org.h2.value.Value.convertTo(Value.java:852)
at org.h2.value.Value.getInt(Value.java:417)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:558)
at org.h2.command.dml.Query.query(Query.java:297)
at org.h2.command.dml.Query.query(Query.java:267)
at org.h2.command.dml.Query.query(Query.java:36)
at org.h2.command.CommandContainer.query(CommandContainer.java:82)
at org.h2.command.Command.executeQuery(Command.java:187)
at org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:177)
at com.jolbox.bonecp.PreparedStatementHandle.execute(PreparedStatementHandle.java:138)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122)
… 20 more
Caused by: java.lang.NumberFormatException: For input string: "2014-06-06 18:08:47.397"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:458)
at java.lang.Integer.parseInt(Integer.java:499)
at org.h2.value.Value.convertTo(Value.java:809)
… 34 more

Re: 5.10 Invalid column type: 1111

jbarrez — Tue, 17 Jun 2014 10:01:35 GMT

That's odd … seems there is a wrong date string in your db. Could you try to manually update it to something which might be parseable?

topic 5.10 Invalid column type: 1111 in Alfresco Archive

5.10 Invalid column type: 1111

Re: 5.10 Invalid column type: 1111

Re: 5.10 Invalid column type: 1111