Activiti Explorer DB2 comment error

[praveenasurapan]

Hi

I am currently getting the below error, when I log into activiti-explorer 5.16.3 version. I switched the database in activiti-standalone-context.xml to db2. I don't get this error when I use SQL server. Please see my activiti-standalone-context.xml contents pasted below. I also emptied out db.properties, which had h2 related info. Please help.

Thanks

### Error querying database.  Cause: com.ibm.db2.jcc.am.SqlException: A temporary table could not be created because there is no available system temporary table space that has a compatible page size.. SQLCODE=-1585, SQLSTATE=54048, DRIVER=3.65.102
### The error may exist in org/activiti/db/mapping/entity/Comment.xml
### The error may involve org.activiti.engine.impl.persistence.entity.CommentEntity.selectEventsByTaskId-Inline
### The error occurred while setting parameters
### SQL: select *      from ACT_HI_COMMENT      where TASK_ID_ = ?     order by TIME_ desc
### Cause: com.ibm.db2.jcc.am.SqlException: A temporary table could not be created because there is no available system temporary table space that has a compatible page size.. SQLCODE=-1585, SQLSTATE=54048, DRIVER=3.65.102
[3/6/15 15:29:49:722 CST] 0000004e SystemErr     R    at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
[3/6/15 15:29:49:722 CST] 0000004e SystemErr     R    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:107)
[3/6/15 15:29:49:722 CST] 0000004e SystemErr     R    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98)
[3/6/15 15:29:49:722 CST] 0000004e SystemErr     R    at org.activiti.engine.impl.db.DbSqlSession.selectListWithRawParameter(DbSqlSession.java:422)
[3/6/15 15:29:49:722 CST] 0000004e SystemErr     R    at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:413)
[3/6/15 15:29:49:723 CST] 0000004e SystemErr     R    at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:408)
[3/6/15 15:29:49:723 CST] 0000004e SystemErr     R    at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:389)
[3/6/15 15:29:49:723 CST] 0000004e SystemErr     R    at org.activiti.engine.impl.persistence.entity.CommentEntityManager.findEventsByTaskId(CommentEntityManager.java:100)
[3/6/15 15:29:49:723 CST] 0000004e SystemErr     R    at org.activiti.engine.impl.cmd.GetTaskEventsCmd.execute(GetTaskEventsCmd.java:37)
[3/6/15 15:29:49:723 CST] 0000004e SystemErr     R    at org.activiti.engine.impl.cmd.GetTaskEventsCmd.execute(GetTaskEventsCmd.java:27)
[3/6/15 15:29:49:723 CST] 0000004e SystemErr     R    at org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:24)
[3/6/15 15:29:49:723 CST] 0000004e SystemErr     R    at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:57)
[3/6/15 15:29:49:723 CST] 0000004e SystemErr     R    at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47)
[3/6/15 15:29:49:723 CST] 0000004e SystemErr     R    at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)
[3/6/15 15:29:49:723 CST] 0000004e SystemErr     R    at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45)
[3/6/15 15:29:49:723 CST] 0000004e SystemErr     R    at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)
[3/6/15 15:29:49:723 CST] 0000004e SystemErr     R    at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)
[3/6/15 15:29:49:723 CST] 0000004e SystemErr     R    at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35)
[3/6/15 15:29:49:723 CST] 0000004e SystemErr     R    at org.activiti.engine.impl.TaskServiceImpl.getTaskEvents(TaskServiceImpl.java:333)
[3/6/15 15:29:49:723 CST] 0000004e SystemErr     R    at org.activiti.explorer.ui.task.TaskEventsPanel.addTaskEvents(TaskEventsPanel.java:125)
[3/6/15 15:29:49:723 CST] 0000004e SystemErr     R    at org.activiti.explorer.ui.task.TaskEventsPanel.refreshTaskEvents(TaskEventsPanel.java:93)
[3/6/15 15:29:49:723 CST] 0000004e SystemErr     R    at org.activiti.explorer.ui.task.TaskEventsPanel.setTaskId(TaskEventsPanel.java:102)
[3/6/15 15:29:49:723 CST] 0000004e SystemErr     R    at org.activiti.explorer.ui.task.TaskPage.createDetailComponent(TaskPage.java:133)
[3/6/15 15:29:49:723 CST] 0000004e SystemErr     R    at org.activiti.explorer.ui.task.TaskPage$1.valueChange(TaskPage.java:117)
[3/6/15 15:29:49:723 CST] 0000004e SystemErr     R    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[3/6/15 15:29:49:723 CST] 0000004e SystemErr     R    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
[3/6/15 15:29:49:724 CST] 0000004e SystemErr     R    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
[3/6/15 15:29:49:724 CST] 0000004e SystemErr     R    at java.lang.reflect.Method.invoke(Method.java:611)
[3/6/15 15:29:49:724 CST] 0000004e SystemErr     R    at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:510)
[3/6/15 15:29:49:724 CST] 0000004e SystemErr     R    … 59 more
[3/6/15 15:29:49:724 CST] 0000004e SystemErr     R Caused by: com.ibm.db2.jcc.am.SqlException: A temporary table could not be created because there is no available system temporary table space that has a compatible page size.. SQLCODE=-1585, SQLSTATE=54048, DRIVER=3.65.102
[3/6/15 15:29:49:724 CST] 0000004e SystemErr     R    at com.ibm.db2.jcc.am.cd.a(cd.java:701)
[3/6/15 15:29:49:724 CST] 0000004e SystemErr     R    at com.ibm.db2.jcc.am.cd.a(cd.java:60)
[3/6/15 15:29:49:724 CST] 0000004e SystemErr     R    at com.ibm.db2.jcc.am.cd.a(cd.java:127)
[3/6/15 15:29:49:724 CST] 0000004e SystemErr     R    at com.ibm.db2.jcc.am.ko.c(ko.java:2753)
[3/6/15 15:29:49:724 CST] 0000004e SystemErr     R    at com.ibm.db2.jcc.am.ko.d(ko.java:2741)
[3/6/15 15:29:49:724 CST] 0000004e SystemErr     R    at com.ibm.db2.jcc.am.ko.a(ko.java:2190)
[3/6/15 15:29:49:724 CST] 0000004e SystemErr     R    at com.ibm.db2.jcc.am.lo.a(lo.java:7382)
[3/6/15 15:29:49:725 CST] 0000004e SystemErr     R    at com.ibm.db2.jcc.t4.ab.h(ab.java:140)
[3/6/15 15:29:49:725 CST] 0000004e SystemErr     R    at com.ibm.db2.jcc.t4.ab.b(ab.java:40)
[3/6/15 15:29:49:725 CST] 0000004e SystemErr     R    at com.ibm.db2.jcc.t4.p.a(p.java:32)
[3/6/15 15:29:49:725 CST] 0000004e SystemErr     R    at com.ibm.db2.jcc.t4.qb.i(qb.java:135)
[3/6/15 15:29:49:725 CST] 0000004e SystemErr     R    at com.ibm.db2.jcc.am.ko.gb(ko.java:2159)
[3/6/15 15:29:49:725 CST] 0000004e SystemErr     R    at com.ibm.db2.jcc.am.lo.rc(lo.java:3547)
[3/6/15 15:29:49:725 CST] 0000004e SystemErr     R    at com.ibm.db2.jcc.am.lo.b(lo.java:3999)
[3/6/15 15:29:49:725 CST] 0000004e SystemErr     R    at com.ibm.db2.jcc.am.lo.hc(lo.java:2744)
[3/6/15 15:29:49:725 CST] 0000004e SystemErr     R    at com.ibm.db2.jcc.am.lo.execute(lo.java:2724)
[3/6/15 15:29:49:725 CST] 0000004e SystemErr     R    at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedStatement.java:618)
[3/6/15 15:29:49:725 CST] 0000004e SystemErr     R    at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:56)
[3/6/15 15:29:49:725 CST] 0000004e SystemErr     R    at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:70)
[3/6/15 15:29:49:725 CST] 0000004e SystemErr     R    at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:57)
[3/6/15 15:29:49:725 CST] 0000004e SystemErr     R    at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:259)
[3/6/15 15:29:49:725 CST] 0000004e SystemErr     R    at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:132)
[3/6/15 15:29:49:726 CST] 0000004e SystemErr     R    at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105)
[3/6/15 15:29:49:726 CST] 0000004e SystemErr     R    at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)
[3/6/15 15:29:49:726 CST] 0000004e SystemErr     R    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104)
[3/6/15 15:29:49:726 CST] 0000004e SystemErr     R    … 86 more

==========activiti-standalone-context.xml ================
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
   xmlns:tx="http://www.springframework.org/schema/tx" xmlns:jee="http://www.springframework.org/schema/jee"
   xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.1.xsd
       http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.1.xsd
       http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.1.xsd
       http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-3.1.xsd">
      
  <!– This Spring config file is NOT used in Alfresco, as the Activiti engine is wired in a different way there –>
      
  <bean id="demoDataGenerator" class="org.activiti.explorer.demo.DemoDataGenerator" init-method="init">
    <property name="processEngine" ref="processEngine" />
   
    <!– Set following properties to false if certain demo data is not wanted –>
    <property name="createDemoUsersAndGroups" value="false" />
    <property name="createDemoProcessDefinitions" value="false" />
    <property name="createDemoModels" value="false" />
    <property name="generateReportData" value="false" />
  </bean>
 
  <bean id="dbProperties" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
    <property name="location" value="classpath:db.properties" />
    <!– Allow other PropertyPlaceholderConfigurer to run as well –>
    <property name="ignoreUnresolvablePlaceholders" value="true" />
  </bean>
   
<jee:jndi-lookup id="dataSource-activiti" jndi-name="jdbc/activitiDb" resource-ref="true"/>

  <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
     <property name="dataSource" ref="dataSource-activiti" />
  </bean>
 
  <bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration">
     <property name="dataSource" ref="dataSource-activiti" />
     <property name="transactionManager" ref="transactionManager" />
    <property name="databaseSchemaUpdate" value="false" />
     <property name="jpaHandleTransaction" value="false" />
    <property name="jpaCloseEntityManager" value="false" />
    <property name="jobExecutorActivate" value="false" />   
    <property name="enableDatabaseEventLogging" value="false" />
    <property name="customFormTypes">
      <list>
        <bean class="org.activiti.explorer.form.UserFormType"/>
        <bean class="org.activiti.explorer.form.ProcessDefinitionFormType"/>
        <bean class="org.activiti.explorer.form.MonthFormType"/>  
      </list>
    </property>
  </bean>
 
  <bean id="processEngine" class="org.activiti.spring.ProcessEngineFactoryBean" destroy-method="destroy">
     <property name="processEngineConfiguration" ref="processEngineConfiguration" />
  </bean>
 
  <bean id="repositoryService" factory-bean="processEngine" factory-method="getRepositoryService" />
  <bean id="runtimeService" factory-bean="processEngine" factory-method="getRuntimeService" />
  <bean id="taskService" factory-bean="processEngine" factory-method="getTaskService" />
  <bean id="historyService" factory-bean="processEngine" factory-method="getHistoryService" />
  <bean id="managementService" factory-bean="processEngine" factory-method="getManagementService" />
  <bean id="identityService" factory-bean="processEngine" factory-method="getIdentityService" />
 
  <bean id="activitiLoginHandler" class="org.activiti.explorer.ui.login.DefaultLoginHandler">
    <property name="identityService" ref="identityService" />
  </bean>
 
</beans>

[vasile_dirla]

This is not caused by Activiti but the configuration of the database:
http://db2-vignettes.blogspot.ro/2013/07/a-temporary-table-could-not-be-created.html
http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c000...

[praveenasurapan]

Thanks Vasile.

We increased our page size and tablespace size to 8k and it worked.