topic ACT_RU* tables in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/act-ru-tables/m-p/63015#M39441 <HTML><HEAD></HEAD><BODY><SPAN>My understanding is that the ACT_RU tables are populated with in flight processes and they are moved to ACT_HI tables once the process is done. But For some reason, I can not see the records for in flight processes in ACT_RU tables, though I can see them in the history tables once the process is complete. Below is the configuration extract </SPAN><BR /><BR /><BR /><BR /><SPAN>&nbsp; &nbsp;&nbsp;&nbsp;&lt;bean class="org.springframework.jdbc.datasource.DriverManagerDataSource"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;id="dataSource1"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="driverClassName" value="com.mysql.jdbc.Driver" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="url" value="jdbc:mysql://127.0.0.1:3306/activiti" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="username" value="activiti" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="password" value="activiti" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&lt;/bean&gt;</SPAN><BR /><SPAN>&nbsp; </SPAN><BR /><SPAN> &nbsp;&nbsp;&nbsp;&lt;bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;p:entityManagerFactory-ref="entityManagerFactory" /&gt;</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&lt;bean id="entityManagerFactory"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;p:dataSource-ref="dataSource1" p<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />ersistenceUnitName="SEMHIEDataStore"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="jpaVendorAdapter"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/property&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&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; &lt;property name="deploymentResources" value="classpath*:hieActiviti.bpmn20.xml" /&gt; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="databaseType" value="MySQL" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="dataSource" ref="dataSource1" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="transactionManager" ref="transactionManager" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="databaseSchemaUpdate" value="true" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="jobExecutorActivate" value="false" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="mailServerHost" value="mail.cns-inc.com" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="mailServerPort" value="25" /&gt;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp; &lt;/bean&gt;</SPAN><BR /><SPAN>&nbsp; </SPAN><BR /><SPAN>&nbsp; &lt;bean id="processEngine" class="org.activiti.spring.ProcessEngineFactoryBean"&gt;</SPAN><BR /><SPAN>&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 /><BR /><BR /><BR /><BR /><BR /><SPAN>Not sure if I am missing some configuration. Any help is highly appreciated.</SPAN></BODY></HTML> Fri, 10 Jun 2011 15:23:17 GMT amareshkulkarni 2011-06-10T15:23:17Z ACT_RU* tables https://connect.hyland.com/t5/alfresco-archive/act-ru-tables/m-p/63015#M39441 My understanding is that the ACT_RU tables are populated with in flight processes and they are moved to ACT_HI tables once the process is done. But For some reason, I can not see the records for in flight processes in ACT_RU tables, though I can see them in the history tables once the process is com Fri, 10 Jun 2011 15:23:17 GMT https://connect.hyland.com/t5/alfresco-archive/act-ru-tables/m-p/63015#M39441 amareshkulkarni 2011-06-10T15:23:17Z Re: ACT_RU* tables https://connect.hyland.com/t5/alfresco-archive/act-ru-tables/m-p/63016#M39442 <HTML><HEAD></HEAD><BODY><SPAN>Data is only committed to the ru tables if you have a waitstate (e.g. a usertask). If you do not have these, the ru tables will never be populated and data only shows up in the hi tables</SPAN></BODY></HTML> Sun, 12 Jun 2011 08:06:59 GMT https://connect.hyland.com/t5/alfresco-archive/act-ru-tables/m-p/63016#M39442 ronald_van_kuij 2011-06-12T08:06:59Z