topic Recommendations requested since H2 throws exception in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/recommendations-requested-since-h2-throws-exception/m-p/178437#M131567 <HTML><HEAD></HEAD><BODY><SPAN>Hi All,</SPAN><BR /><BR /><SPAN>I have been using Activiti for a while now and love it.&nbsp; I have been running it against a MySQL DB which works well.&nbsp; I have recently tried to use an in-memory H2 database for speeding up my processes.&nbsp; However, I am getting occasional exceptions.</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE> <BR />org.apache.ibatis.exceptions.PersistenceException:<BR />Error querying database. Cause: org.h2.jdbc.JdbcSQLException: Table "ACT_RE_PROCDEF" not found; SQL statement:<BR />select *<BR />from ACT_RE_PROCDEF <BR />where KEY_ = ? and<BR />VERSION_ = (select max(VERSION_) from ACT_RE_PROCDEF where KEY_ = ?) [42102-181]<BR />The error may exist in org/activiti/db/mapping/entity/ProcessDefinition.xml<BR />The error may involve org.activiti.engine.impl.persistence.entity.ProcessDefinitionEntity.selectLatestProcessDefinitionByKey<BR />The error occurred while executing a query<BR />SQL: select * from ACT_RE_PROCDEF where KEY_ = ? and VERSION_ = (select max(VERSION_) from ACT_RE_PROCDEF where KEY_ = ?)<BR />Cause: org.h2.jdbc.JdbcSQLException: Table "ACT_RE_PROCDEF" not found; SQL statement:<BR />select *<BR />from ACT_RE_PROCDEF <BR />where KEY_ = ? and<BR />VERSION_ = (select max(VERSION_) from ACT_RE_PROCDEF where KEY_ = ?) [42102-181]<BR />at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)<BR />at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104)<BR />at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95)<BR />at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:59)<BR />at org.activiti.engine.impl.db.DbSqlSession.selectOne(DbSqlSession.java:308)<BR />at org.activiti.engine.impl.persistence.entity.ProcessDefinitionEntityManager.findLatestProcessDefinitionByKey(ProcessDefinitionEntityManager.java:38)<BR />at org.activiti.engine.impl.persistence.deploy.DeploymentManager.findDeployedLatestProcessDefinitionByKey(DeploymentManager.java:62)<BR />at org.activiti.engine.impl.cmd.StartProcessInstanceCmd.execute(StartProcessInstanceCmd.java:64)<BR />at org.activiti.engine.impl.cmd.StartProcessInstanceCmd.execute(StartProcessInstanceCmd.java:36)<BR />at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)<BR />at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:61)<BR />at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)<BR />at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)<BR />at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)<BR />at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)<BR />at org.activiti.engine.impl.RuntimeServiceImpl.startProcessInstanceByKey(RuntimeServiceImpl.java:62)<BR />at com.presidioHealth.ppsImportLibrary.document.service.ExternalEMREventListener.onApplicationEvent(ExternalEMREventListener.java:94)<BR />at com.presidioHealth.ppsImportLibrary.document.service.ExternalEMREventListener.onApplicationEvent(ExternalEMREventListener.java:26)<BR />at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:98)<BR />at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:333)<BR />at com.presidioHealth.ppsIntegrationLibrary.endpoint.inbound.ProcessInboundEMRMessage.execute(ProcessInboundEMRMessage.java:56)<BR />at sun.reflect.GeneratedMethodAccessor227.invoke(Unknown Source)<BR />at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<BR />at java.lang.reflect.Method.invoke(Method.java:606)<BR />at org.springframework.expression.spel.support.ReflectiveMethodExecutor.execute(ReflectiveMethodExecutor.java:63)<BR />at org.springframework.expression.spel.ast.MethodReference.getValueInternal(MethodReference.java:95)<BR />at org.springframework.expression.spel.ast.MethodReference.access$000(MethodReference.java:44)<BR />at org.springframework.expression.spel.ast.MethodReference$MethodValueRef.getValue(MethodReference.java:258)<BR />at org.springframework.expression.spel.ast.CompoundExpression.getValueInternal(CompoundExpression.java:84)<BR />at org.springframework.expression.spel.ast.SpelNodeImpl.getTypedValue(SpelNodeImpl.java:114)<BR />at org.springframework.expression.spel.standard.SpelExpression.getValue(SpelExpression.java:111)<BR />at org.springframework.integration.util.AbstractExpressionEvaluator.evaluateExpression(AbstractExpressionEvaluator.java:159)<BR />at org.springframework.integration.util.MessagingMethodInvokerHelper.processInternal(MessagingMethodInvokerHelper.java:268)<BR />at org.springframework.integration.util.MessagingMethodInvokerHelper.process(MessagingMethodInvokerHelper.java:142)<BR />at org.springframework.integration.handler.MethodInvokingMessageProcessor.processMessage(MethodInvokingMessageProcessor.java:75)<BR />at org.springframework.integration.handler.ServiceActivatingHandler.handleRequestMessage(ServiceActivatingHandler.java:71)<BR />at org.springframework.integration.handler.AbstractReplyProducingMessageHandler.handleMessageInternal(AbstractReplyProducingMessageHandler.java:170)<BR />at org.springframework.integration.handler.AbstractMessageHandler.handleMessage(AbstractMessageHandler.java:78)<BR />at org.springframework.integration.dispatcher.BroadcastingDispatcher.invokeHandler(BroadcastingDispatcher.java:160)<BR />at org.springframework.integration.dispatcher.BroadcastingDispatcher.dispatch(BroadcastingDispatcher.java:142)<BR />at org.springframework.integration.channel.AbstractSubscribableChannel.doSend(AbstractSubscribableChannel.java:77)<BR />at org.springframework.integration.channel.AbstractMessageChannel.send(AbstractMessageChannel.java:255)<BR />at org.springframework.integration.channel.AbstractMessageChannel.send(AbstractMessageChannel.java:223)<BR />at org.springframework.messaging.core.GenericMessagingTemplate.doSend(GenericMessagingTemplate.java:109)<BR />at org.springframework.messaging.core.GenericMessagingTemplate.doSend(GenericMessagingTemplate.java:44)<BR />at org.springframework.messaging.core.AbstractMessageSendingTemplate.send(AbstractMessageSendingTemplate.java:94)<BR />at org.springframework.integration.endpoint.SourcePollingChannelAdapter.handleMessage(SourcePollingChannelAdapter.java:110)<BR />at org.springframework.integration.endpoint.AbstractPollingEndpoint.doPoll(AbstractPollingEndpoint.java:205)<BR />at org.springframework.integration.endpoint.AbstractPollingEndpoint.access$000(AbstractPollingEndpoint.java:55)<BR />at org.springframework.integration.endpoint.AbstractPollingEndpoint$1.call(AbstractPollingEndpoint.java:149)<BR />at org.springframework.integration.endpoint.AbstractPollingEndpoint$1.call(AbstractPollingEndpoint.java:146)<BR />at org.springframework.integration.endpoint.AbstractPollingEndpoint$Poller$1.run(AbstractPollingEndpoint.java:284)<BR />at org.springframework.integration.util.ErrorHandlingTaskExecutor$1.run(ErrorHandlingTaskExecutor.java:52)<BR />at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:50)<BR />at org.springframework.integration.util.ErrorHandlingTaskExecutor.execute(ErrorHandlingTaskExecutor.java:49)<BR />at org.springframework.integration.endpoint.AbstractPollingEndpoint$Poller.run(AbstractPollingEndpoint.java:278)<BR />at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)<BR />at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81)<BR />at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)<BR />at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)<BR />at java.util.concurrent.FutureTask.run(FutureTask.java:166)<BR />at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)<BR />at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)<BR />at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)<BR />at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)<BR />at java.lang.Thread.run(Thread.java:724)<BR />Caused by: org.h2.jdbc.JdbcSQLException: Table "ACT_RE_PROCDEF" not found; SQL statement:<BR />select *<BR />from ACT_RE_PROCDEF <BR />where KEY_ = ? and<BR />VERSION_ = (select max(VERSION_) from ACT_RE_PROCDEF where KEY_ = ?) [42102-181]<BR />at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)<BR />at org.h2.message.DbException.get(DbException.java:179)<BR />at org.h2.message.DbException.get(DbException.java:155)<BR />at org.h2.command.Parser.readTableOrView(Parser.java:5227)<BR />at org.h2.command.Parser.readTableFilter(Parser.java:1221)<BR />at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1860)<BR />at org.h2.command.Parser.parseSelectSimple(Parser.java:1969)<BR />at org.h2.command.Parser.parseSelectSub(Parser.java:1854)<BR />at org.h2.command.Parser.parseSelectUnion(Parser.java:1675)<BR />at org.h2.command.Parser.parseSelect(Parser.java:1663)<BR />at org.h2.command.Parser.parsePrepared(Parser.java:433)<BR />at org.h2.command.Parser.parse(Parser.java:305)<BR />at org.h2.command.Parser.parse(Parser.java:277)<BR />at org.h2.command.Parser.prepareCommand(Parser.java:242)<BR />at org.h2.engine.Session.prepareLocal(Session.java:446)<BR />at org.h2.engine.Session.prepareCommand(Session.java:388)<BR />at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1189)<BR />at org.h2.jdbc.JdbcPreparedStatement.&lt;init&gt;(JdbcPreparedStatement.java:72)<BR />at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:277)<BR />at com.jolbox.bonecp.ConnectionHandle.prepareStatement(ConnectionHandle.java:820)<BR />at sun.reflect.GeneratedMethodAccessor39.invoke(Unknown Source)<BR />at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<BR />at java.lang.reflect.Method.invoke(Method.java:606)<BR />at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:240)<BR />at com.sun.proxy.$Proxy70.prepareStatement(Unknown Source)<BR />at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:72)<BR />at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:82)<BR />at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:54)<BR />at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:70)<BR />at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:56)<BR />at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267)<BR />at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:141)<BR />at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105)<BR />at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)<BR />at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:101)<BR />… 64 more<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>I deployed this server over 1 day ago and its been working well.&nbsp; This afternoon, I got a string of these exceptions.&nbsp; I don't know what is causing this.&nbsp; Is there a setting that I need to create to make H2 more reliable?</SPAN><BR /><BR /><SPAN>Here is my question.</SPAN><BR /><BR /><SPAN>All of my activity workflows are atomic.&nbsp; There are no wait-states.&nbsp; Therefore, I really don't need them to be persisted to disk for later execution.&nbsp; I want them to run as fast as possible.&nbsp; I do need the history since I need the values of process variables after the process finishes.&nbsp; So, after I get the variables, I delete the history.</SPAN><BR /><BR /><SPAN>In your experience, what is the best method/configuration for a server that executes workflows simultaneously.&nbsp; All of this is embedded in Tomcat running my Java application using Spring.</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><SPAN>Tom</SPAN><BR /></BODY></HTML> Fri, 19 Sep 2014 23:09:26 GMT mrbahr2003 2014-09-19T23:09:26Z Recommendations requested since H2 throws exception https://connect.hyland.com/t5/alfresco-archive/recommendations-requested-since-h2-throws-exception/m-p/178437#M131567 Hi All,I have been using Activiti for a while now and love it.&nbsp; I have been running it against a MySQL DB which works well.&nbsp; I have recently tried to use an in-memory H2 database for speeding up my processes.&nbsp; However, I am getting occasional exceptions. org.apache.ibatis.exceptions.PersistenceExcep Fri, 19 Sep 2014 23:09:26 GMT https://connect.hyland.com/t5/alfresco-archive/recommendations-requested-since-h2-throws-exception/m-p/178437#M131567 mrbahr2003 2014-09-19T23:09:26Z Re: Recommendations requested since H2 throws exception https://connect.hyland.com/t5/alfresco-archive/recommendations-requested-since-h2-throws-exception/m-p/178438#M131568 <HTML><HEAD></HEAD><BODY><SPAN>Hi Tom,</SPAN><BR /><BR /><SPAN>It's related to a H2 setting:</SPAN><BR /><BR /><A href="http://stackoverflow.com/questions/5763747/h2-in-memory-database-table-not-found" rel="nofollow noopener noreferrer">http://stackoverflow.com/questions/5763747/h2-in-memory-database-table-not-found</A><BR /><BR /><SPAN>In our tests we use the following database URL:</SPAN><BR /><BR /><SPAN>jdbc:h2:mem:activiti;DB_CLOSE_DELAY=1000</SPAN><BR /><BR /><SPAN>You can disable history via the process engine configuration. You can read about it in the user guide.</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Sat, 20 Sep 2014 19:58:45 GMT https://connect.hyland.com/t5/alfresco-archive/recommendations-requested-since-h2-throws-exception/m-p/178438#M131568 trademak 2014-09-20T19:58:45Z