5.10 Invalid column type: 1111

[tunney]

I'm upgrading my application to run on 5.10, was on 5.9

On 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.entity.JobEntity.selectJobsByConfiguration-Inline
### The error occurred while setting parameters
### Cause: org.hibernate.exception.GenericJDBCException: Invalid column type: 1111
   at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:61)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:53)
   at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:210)
   at org.activiti.engine.impl.persistence.entity.JobManager.findJobsByConfiguration(JobManager.java:144)
   at org.activiti.engine.impl.bpmn.deployer.BpmnDeployer.removeObsoleteTimers(BpmnDeployer.java:192)
   at org.activiti.engine.impl.bpmn.deployer.BpmnDeployer.deploy(BpmnDeployer.java:148)
   at org.activiti.engine.impl.persistence.deploy.DeploymentCache.deploy(DeploymentCache.java:38)
   at org.activiti.engine.impl.persistence.entity.DeploymentManager.insertDeployment(DeploymentManager.java:42)
   at org.activiti.engine.impl.cmd.DeployCmd.execute(DeployCmd.java:59)
   at org.activiti.engine.impl.cmd.DeployCmd.execute(DeployCmd.java:31)
   at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)
   at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)
   at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)
   at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
   at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)
   at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
   at org.activiti.engine.impl.RepositoryServiceImpl.deploy(RepositoryServiceImpl.java:54)
   at org.activiti.engine.impl.repository.DeploymentBuilderImpl.deploy(DeploymentBuilderImpl.java:106)
   at com.pm.pdm.process.impl.activiti.init.ProcessUpdater.deploy(ProcessUpdater.java:86)
   at com.pm.pdm.service.process.ProcessImportProcessor.doImport(ProcessImportProcessor.java:35)
   at com.pm.pdm.service.impexp.ImportExportServiceImpl.importObjects(ImportExportServiceImpl.java:90)
   at com.pm.pdm.service.impexp.ImportExportServiceImpl.importObjectsFromUri(ImportExportServiceImpl.java:125)
   … 43 more
Caused by: org.hibernate.exception.GenericJDBCException: Invalid column type: 1111
   at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)
   at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
   at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
   at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)
   at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
   at com.sun.proxy.$Proxy93.setNull(Unknown Source)
   at org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:15)
   at org.apache.ibatis.executor.parameter.DefaultParameterHandler.setParameters(DefaultParameterHandler.java:73)
   at org.apache.ibatis.executor.statement.PreparedStatementHandler.parameterize(PreparedStatementHandler.java:61)
   at org.apache.ibatis.executor.statement.RoutingStatementHandler.parameterize(RoutingStatementHandler.java:43)
   at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:56)
   at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:40)
   at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:94)
   at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:72)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:59)
   … 64 more
Caused by: java.sql.SQLException: Invalid column type: 1111
   at oracle.jdbc.driver.OracleStatement.getInternalType(OracleStatement.java:3916)
   at oracle.jdbc.driver.OraclePreparedStatement.setNullCritical(OraclePreparedStatement.java:4541)
   at oracle.jdbc.driver.OraclePreparedStatement.setNull(OraclePreparedStatement.java:4523)
   at oracle.jdbc.driver.OraclePreparedStatementWrapper.setNull(OraclePreparedStatementWrapper.java:1281)
   at com.jolbox.bonecp.PreparedStatementHandle.setNull(PreparedStatementHandle.java:884)
   at sun.reflect.GeneratedMethodAccessor71.invoke(Unknown Source)
   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)
   … 75 more
06-Jun-2014 17:32:46 org.apache.catalina.core.ApplicationContext log

[tunney]

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

[jbarrez]

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?