topic Activiti Explorer DB2 comment error in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/activiti-explorer-db2-comment-error/m-p/177078#M130208 <HTML><HEAD></HEAD><BODY><SPAN>Hi </SPAN><BR /><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>Thanks</SPAN><BR /><BR /><SPAN>### Error querying database.&nbsp; 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</SPAN><BR /><SPAN>### The error may exist in org/activiti/db/mapping/entity/Comment.xml</SPAN><BR /><SPAN>### The error may involve org.activiti.engine.impl.persistence.entity.CommentEntity.selectEventsByTaskId-Inline</SPAN><BR /><SPAN>### The error occurred while setting parameters</SPAN><BR /><SPAN>### SQL: select *&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; from ACT_HI_COMMENT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where TASK_ID_ = ?&nbsp;&nbsp;&nbsp;&nbsp; order by TIME_ desc</SPAN><BR /><SPAN>### 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</SPAN><BR /><SPAN>[3/6/15 15:29:49:722 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)</SPAN><BR /><SPAN>[3/6/15 15:29:49:722 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:107)</SPAN><BR /><SPAN>[3/6/15 15:29:49:722 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98)</SPAN><BR /><SPAN>[3/6/15 15:29:49:722 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.selectListWithRawParameter(DbSqlSession.java:422)</SPAN><BR /><SPAN>[3/6/15 15:29:49:722 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:413)</SPAN><BR /><SPAN>[3/6/15 15:29:49:723 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:408)</SPAN><BR /><SPAN>[3/6/15 15:29:49:723 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:389)</SPAN><BR /><SPAN>[3/6/15 15:29:49:723 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.persistence.entity.CommentEntityManager.findEventsByTaskId(CommentEntityManager.java:100)</SPAN><BR /><SPAN>[3/6/15 15:29:49:723 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.cmd.GetTaskEventsCmd.execute(GetTaskEventsCmd.java:37)</SPAN><BR /><SPAN>[3/6/15 15:29:49:723 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.cmd.GetTaskEventsCmd.execute(GetTaskEventsCmd.java:27)</SPAN><BR /><SPAN>[3/6/15 15:29:49:723 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:24)</SPAN><BR /><SPAN>[3/6/15 15:29:49:723 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:57)</SPAN><BR /><SPAN>[3/6/15 15:29:49:723 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47)</SPAN><BR /><SPAN>[3/6/15 15:29:49:723 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)</SPAN><BR /><SPAN>[3/6/15 15:29:49:723 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45)</SPAN><BR /><SPAN>[3/6/15 15:29:49:723 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)</SPAN><BR /><SPAN>[3/6/15 15:29:49:723 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)</SPAN><BR /><SPAN>[3/6/15 15:29:49:723 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35)</SPAN><BR /><SPAN>[3/6/15 15:29:49:723 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.TaskServiceImpl.getTaskEvents(TaskServiceImpl.java:333)</SPAN><BR /><SPAN>[3/6/15 15:29:49:723 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at org.activiti.explorer.ui.task.TaskEventsPanel.addTaskEvents(TaskEventsPanel.java:125)</SPAN><BR /><SPAN>[3/6/15 15:29:49:723 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at org.activiti.explorer.ui.task.TaskEventsPanel.refreshTaskEvents(TaskEventsPanel.java:93)</SPAN><BR /><SPAN>[3/6/15 15:29:49:723 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at org.activiti.explorer.ui.task.TaskEventsPanel.setTaskId(TaskEventsPanel.java:102)</SPAN><BR /><SPAN>[3/6/15 15:29:49:723 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at org.activiti.explorer.ui.task.TaskPage.createDetailComponent(TaskPage.java:133)</SPAN><BR /><SPAN>[3/6/15 15:29:49:723 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at org.activiti.explorer.ui.task.TaskPage$1.valueChange(TaskPage.java:117)</SPAN><BR /><SPAN>[3/6/15 15:29:49:723 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>[3/6/15 15:29:49:723 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)</SPAN><BR /><SPAN>[3/6/15 15:29:49:724 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)</SPAN><BR /><SPAN>[3/6/15 15:29:49:724 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:611)</SPAN><BR /><SPAN>[3/6/15 15:29:49:724 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:510)</SPAN><BR /><SPAN>[3/6/15 15:29:49:724 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;… 59 more</SPAN><BR /><SPAN>[3/6/15 15:29:49:724 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; 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</SPAN><BR /><SPAN>[3/6/15 15:29:49:724 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at com.ibm.db2.jcc.am.cd.a(cd.java:701)</SPAN><BR /><SPAN>[3/6/15 15:29:49:724 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at com.ibm.db2.jcc.am.cd.a(cd.java:60)</SPAN><BR /><SPAN>[3/6/15 15:29:49:724 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at com.ibm.db2.jcc.am.cd.a(cd.java:127)</SPAN><BR /><SPAN>[3/6/15 15:29:49:724 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at com.ibm.db2.jcc.am.ko.c(ko.java:2753)</SPAN><BR /><SPAN>[3/6/15 15:29:49:724 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at com.ibm.db2.jcc.am.ko.d(ko.java:2741)</SPAN><BR /><SPAN>[3/6/15 15:29:49:724 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at com.ibm.db2.jcc.am.ko.a(ko.java:2190)</SPAN><BR /><SPAN>[3/6/15 15:29:49:724 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at com.ibm.db2.jcc.am.lo.a(lo.java:7382)</SPAN><BR /><SPAN>[3/6/15 15:29:49:725 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at com.ibm.db2.jcc.t4.ab.h(ab.java:140)</SPAN><BR /><SPAN>[3/6/15 15:29:49:725 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at com.ibm.db2.jcc.t4.ab.b(ab.java:40)</SPAN><BR /><SPAN>[3/6/15 15:29:49:725 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at com.ibm.db2.jcc.t4.p.a(p.java:32)</SPAN><BR /><SPAN>[3/6/15 15:29:49:725 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at com.ibm.db2.jcc.t4.qb.i(qb.java:135)</SPAN><BR /><SPAN>[3/6/15 15:29:49:725 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at com.ibm.db2.jcc.am.ko.gb(ko.java:2159)</SPAN><BR /><SPAN>[3/6/15 15:29:49:725 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at com.ibm.db2.jcc.am.lo.rc(lo.java:3547)</SPAN><BR /><SPAN>[3/6/15 15:29:49:725 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at com.ibm.db2.jcc.am.lo.b(lo.java:3999)</SPAN><BR /><SPAN>[3/6/15 15:29:49:725 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at com.ibm.db2.jcc.am.lo.hc(lo.java:2744)</SPAN><BR /><SPAN>[3/6/15 15:29:49:725 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at com.ibm.db2.jcc.am.lo.execute(lo.java:2724)</SPAN><BR /><SPAN>[3/6/15 15:29:49:725 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedStatement.java:618)</SPAN><BR /><SPAN>[3/6/15 15:29:49:725 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:56)</SPAN><BR /><SPAN>[3/6/15 15:29:49:725 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:70)</SPAN><BR /><SPAN>[3/6/15 15:29:49:725 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:57)</SPAN><BR /><SPAN>[3/6/15 15:29:49:725 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:259)</SPAN><BR /><SPAN>[3/6/15 15:29:49:725 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:132)</SPAN><BR /><SPAN>[3/6/15 15:29:49:726 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105)</SPAN><BR /><SPAN>[3/6/15 15:29:49:726 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)</SPAN><BR /><SPAN>[3/6/15 15:29:49:726 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104)</SPAN><BR /><SPAN>[3/6/15 15:29:49:726 CST] 0000004e SystemErr&nbsp;&nbsp;&nbsp;&nbsp; R &nbsp;&nbsp;&nbsp;… 86 more</SPAN><BR /><BR /><SPAN>==========activiti-standalone-context.xml ================</SPAN><BR /><SPAN>&lt;?xml version="1.0" encoding="UTF-8"?&gt;</SPAN><BR /><SPAN>&lt;beans xmlns="</SPAN><A href="http://www.springframework.org/schema/beans" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/beans</A><SPAN>"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;xmlns:xsi="</SPAN><A href="http://www.w3.org/2001/XMLSchema-instance" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema-instance</A><SPAN>" xmlns:context="</SPAN><A href="http://www.springframework.org/schema/context" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/context</A><SPAN>"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;xmlns:tx="</SPAN><A href="http://www.springframework.org/schema/tx" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/tx</A><SPAN>" xmlns:jee="</SPAN><A href="http://www.springframework.org/schema/jee" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/jee</A><SPAN>"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;xsi:schemaLocation="</SPAN><A href="http://www.springframework.org/schema/beans" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/beans</A><SPAN> </SPAN><A href="http://www.springframework.org/schema/beans/spring-beans-3.1.xsd" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/beans/spring-beans-3.1.xsd</A><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><A href="http://www.springframework.org/schema/context" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/context</A><SPAN> </SPAN><A href="http://www.springframework.org/schema/context/spring-context-3.1.xsd" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/context/spring-context-3.1.xsd</A><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><A href="http://www.springframework.org/schema/tx" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/tx</A><SPAN> </SPAN><A href="http://www.springframework.org/schema/tx/spring-tx-3.1.xsd" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/tx/spring-tx-3.1.xsd</A><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><A href="http://www.springframework.org/schema/jee" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/jee</A><SPAN> </SPAN><A href="http://www.springframework.org/schema/jee/spring-jee-3.1.xsd" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/jee/spring-jee-3.1.xsd</A><SPAN>"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp; &lt;!– This Spring config file is NOT used in Alfresco, as the Activiti engine is wired in a different way there –&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp; &lt;bean id="demoDataGenerator" class="org.activiti.explorer.demo.DemoDataGenerator" init-method="init"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="processEngine" ref="processEngine" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;!– Set following properties to false if certain demo data is not wanted –&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="createDemoUsersAndGroups" value="false" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="createDemoProcessDefinitions" value="false" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="createDemoModels" value="false" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="generateReportData" value="false" /&gt;</SPAN><BR /><SPAN>&nbsp; &lt;/bean&gt;</SPAN><BR /><SPAN>&nbsp; </SPAN><BR /><SPAN>&nbsp; &lt;bean id="dbProperties" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="location" value="classpath:db.properties" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;!– Allow other PropertyPlaceholderConfigurer to run as well –&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="ignoreUnresolvablePlaceholders" value="true" /&gt;</SPAN><BR /><SPAN>&nbsp; &lt;/bean&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN> &lt;jee:jndi-lookup id="dataSource-activiti" jndi-name="jdbc/activitiDb" resource-ref="true"/&gt;</SPAN><BR /><BR /><SPAN>&nbsp; &lt;bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"&gt;</SPAN><BR /><SPAN>&nbsp; &nbsp;&nbsp;&nbsp;&lt;property name="dataSource" ref="dataSource-activiti" /&gt;</SPAN><BR /><SPAN>&nbsp; &lt;/bean&gt;</SPAN><BR /><SPAN>&nbsp; </SPAN><BR /><SPAN>&nbsp; &lt;bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration"&gt;</SPAN><BR /><SPAN>&nbsp; &nbsp;&nbsp;&nbsp;&lt;property name="dataSource" ref="dataSource-activiti" /&gt;</SPAN><BR /><SPAN>&nbsp; &nbsp;&nbsp;&nbsp;&lt;property name="transactionManager" ref="transactionManager" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="databaseSchemaUpdate" value="false" /&gt;</SPAN><BR /><SPAN>&nbsp; &nbsp;&nbsp;&nbsp;&lt;property name="jpaHandleTransaction" value="false" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="jpaCloseEntityManager" value="false" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="jobExecutorActivate" value="false" /&gt;&nbsp;&nbsp;&nbsp;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="enableDatabaseEventLogging" value="false" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="customFormTypes"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;list&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;bean class="org.activiti.explorer.form.UserFormType"/&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;bean class="org.activiti.explorer.form.ProcessDefinitionFormType"/&gt; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;bean class="org.activiti.explorer.form.MonthFormType"/&gt;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/list&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>&nbsp; &lt;/bean&gt;</SPAN><BR /><SPAN>&nbsp; </SPAN><BR /><SPAN>&nbsp; &lt;bean id="processEngine" class="org.activiti.spring.ProcessEngineFactoryBean" destroy-method="destroy"&gt;</SPAN><BR /><SPAN>&nbsp; &nbsp;&nbsp;&nbsp;&lt;property name="processEngineConfiguration" ref="processEngineConfiguration" /&gt;</SPAN><BR /><SPAN>&nbsp; &lt;/bean&gt;</SPAN><BR /><SPAN>&nbsp; </SPAN><BR /><SPAN>&nbsp; &lt;bean id="repositoryService" factory-bean="processEngine" factory-method="getRepositoryService" /&gt;</SPAN><BR /><SPAN>&nbsp; &lt;bean id="runtimeService" factory-bean="processEngine" factory-method="getRuntimeService" /&gt;</SPAN><BR /><SPAN>&nbsp; &lt;bean id="taskService" factory-bean="processEngine" factory-method="getTaskService" /&gt;</SPAN><BR /><SPAN>&nbsp; &lt;bean id="historyService" factory-bean="processEngine" factory-method="getHistoryService" /&gt;</SPAN><BR /><SPAN>&nbsp; &lt;bean id="managementService" factory-bean="processEngine" factory-method="getManagementService" /&gt;</SPAN><BR /><SPAN>&nbsp; &lt;bean id="identityService" factory-bean="processEngine" factory-method="getIdentityService" /&gt;</SPAN><BR /><SPAN>&nbsp; </SPAN><BR /><SPAN>&nbsp; &lt;bean id="activitiLoginHandler" class="org.activiti.explorer.ui.login.DefaultLoginHandler"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="identityService" ref="identityService" /&gt;</SPAN><BR /><SPAN>&nbsp; &lt;/bean&gt;</SPAN><BR /><SPAN>&nbsp; </SPAN><BR /><SPAN>&lt;/beans&gt;</SPAN><BR /></BODY></HTML> Fri, 06 Mar 2015 21:50:31 GMT praveenasurapan 2015-03-06T21:50:31Z Activiti Explorer DB2 comment error https://connect.hyland.com/t5/alfresco-archive/activiti-explorer-db2-comment-error/m-p/177078#M130208 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.pro Fri, 06 Mar 2015 21:50:31 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-explorer-db2-comment-error/m-p/177078#M130208 praveenasurapan 2015-03-06T21:50:31Z Re: Activiti Explorer DB2 comment error https://connect.hyland.com/t5/alfresco-archive/activiti-explorer-db2-comment-error/m-p/177079#M130209 <HTML><HEAD></HEAD><BODY><SPAN>This is not caused by Activiti but the configuration of the database:</SPAN><BR /><A href="http://db2-vignettes.blogspot.ro/2013/07/a-temporary-table-could-not-be-created.html" rel="nofollow noopener noreferrer">http://db2-vignettes.blogspot.ro/2013/07/a-temporary-table-could-not-be-created.html</A><BR /><A href="http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0004975.html" rel="nofollow noopener noreferrer">http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0004975.html</A></BODY></HTML> Mon, 09 Mar 2015 20:58:17 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-explorer-db2-comment-error/m-p/177079#M130209 vasile_dirla 2015-03-09T20:58:17Z Re: Activiti Explorer DB2 comment error https://connect.hyland.com/t5/alfresco-archive/activiti-explorer-db2-comment-error/m-p/177080#M130210 <HTML><HEAD></HEAD><BODY><SPAN>Thanks Vasile.</SPAN><BR /><BR /><SPAN>We increased our page size and tablespace size to 8k and it worked.</SPAN></BODY></HTML> Tue, 10 Mar 2015 15:27:36 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-explorer-db2-comment-error/m-p/177080#M130210 praveenasurapan 2015-03-10T15:27:36Z