AnsweredAssumed Answered

Problem - Table ACT_RE_PROCDEF not found

Question asked by waldi666 on Sep 29, 2011
Latest reply on Oct 17, 2011 by ftr
Hi,

i am running aciviti in version 5.7 with spring integration and inmemory h2 database access. The application starts fine -
the activiti engine runs up without errors. I can use the application for a while without problems, the workflow will be
executed without problems.

After a time the activiti engine runs in a PersistenceException: 
——————————————————————————–
5219571 [qtp18481629-28] INFO  de.xxx.ActivitiWorkflowManager - Starting workflow: cfg_wfm_001.bpmn20.xml
5219806 [qtp18481629-28] ERROR org.activiti.engine.impl.interceptor.CommandContext - Error while closing command context
org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: org.h2.jdbc.JdbcSQLException: Table "ACT_RE_PROCDEF" not found; SQL statement:
select PD.*
      
    from ACT_RE_PROCDEF PD
     WHERE  PD.KEY_ = ? [42102-160]
### The error may exist in org/activiti/db/mapping/entity/ProcessDefinition.xml
### The error may involve org.activiti.engine.impl.persistence.entity.ProcessDefinitionEntity.selectProcessDefinitionsByQueryCriteria
### The error occurred while executing a query
### SQL: select PD.*             from ACT_RE_PROCDEF PD      WHERE  PD.KEY_ = ?
### Cause: org.h2.jdbc.JdbcSQLException: Table "ACT_RE_PROCDEF" not found; SQL statement:
select PD.*
      
    from ACT_RE_PROCDEF PD
     WHERE  PD.KEY_ = ? [42102-160]
   at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)
——————————————————————————–

What can be happen ?

My activit context configuration file:
——————————————————————————–
   <tx:annotation-driven transaction-manager="transactionManager" />

   <!– In-memory database for now –>
   <bean id="dataSource"
      class="org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy">
      <property name="targetDataSource">
         <bean class="org.springframework.jdbc.datasource.SimpleDriverDataSource">
            <property name="driverClass" value="org.h2.Driver" />
            <property name="url" value="jdbc:h2:mem:activiti;DB_CLOSE_DELAY=1000" />
            <property name="username" value="sa" />
            <property name="password" value="" />
         </bean>
      </property>
   </bean>

   <bean id="transactionManager"
      class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
      <property name="dataSource" ref="dataSource" />
   </bean>

   <bean id="activitiProcessEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration">
      <property name="databaseType" value="h2" />
      <property name="dataSource" ref="dataSource" />
      <property name="transactionManager" ref="transactionManager" />
      <property name="databaseSchemaUpdate" value="true" />
      <property name="jobExecutorActivate" value="false" />
   </bean>

   <bean id="activitiProcessEngine" class="org.activiti.spring.ProcessEngineFactoryBean">
      <property name="processEngineConfiguration" ref="activitiProcessEngineConfiguration" />
   </bean>

   <bean id="activitiRepositoryService" factory-bean="activitiProcessEngine"
      factory-method="getRepositoryService" />
   <bean id="activitiRuntimeService" factory-bean="activitiProcessEngine"
      factory-method="getRuntimeService" />
   <bean id="activitiTaskService" factory-bean="activitiProcessEngine"
      factory-method="getTaskService" />
   <bean id="activitiHistoryService" factory-bean="activitiProcessEngine"
      factory-method="getHistoryService" />
   <bean id="activitiManagementService" factory-bean="activitiProcessEngine"
      factory-method="getManagementService" />



——————————————————————————–

Many thanks for helping
Heiko

Outcomes