topic Activiti-Process details are not saving in database in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/activiti-process-details-are-not-saving-in-database/m-p/182854#M135984 <HTML><HEAD></HEAD><BODY><SPAN>Hello team,</SPAN><BR /><BR /><SPAN>I am working on running simple BPMN flow through actviti. I am able to execute script and service tasks.</SPAN><BR /><SPAN>But the process details are not getting saved to db .</SPAN><BR /><SPAN>Below are my files.</SPAN><BR /><SPAN>activiti.cfg-mem-fullhistory.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;&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>"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&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>&nbsp;&nbsp; </SPAN><A href="http://www.springframework.org/schema/beans/spring-beans.xsd" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/beans/spring-beans.xsd</A><SPAN>"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp; </SPAN><BR /><SPAN>&lt;bean id="dataSource"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;class="org.springframework.jdbc.datasource.SimpleDriverDataSource"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="driverClass" value="org.h2.Driver" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="url" value="jdbc:h2:mem:activiti;DB_CLOSE_DELAY=-1;MVCC=TRUE" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="username" value="sa" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="password" value="" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&lt;/bean&gt;</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&lt;bean id="transactionManager"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;class="org.springframework.jdbc.datasource.DataSourceTransactionManager"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="dataSource" ref="dataSource" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&lt;/bean&gt;</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&lt;bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;depends-on="dataSource,transactionManager"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="databaseType" value="h2" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="dataSource" ref="dataSource" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="transactionManager" ref="transactionManager" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="databaseSchemaUpdate" value="true" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;!– property name="databaseSchemaUpdate" value="create-drop" /–&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="jobExecutorActivate" value="false" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="history" value="none" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="deploymentResources" value="classpath*:activiti/*.bpmn" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&lt;/bean&gt;</SPAN><BR /><BR /><SPAN>&lt;/beans&gt;</SPAN><BR /><BR /><SPAN>Test file.</SPAN><BR /><SPAN>public class LoanRequestTest&nbsp; {&nbsp;&nbsp;&nbsp;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;</SPAN><BR /><SPAN>&nbsp; @Rule </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;public ActivitiRule activitiRule = new ActivitiRule("activiti.cfg-mem-fullhistory.xml");</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;@Test</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;@Deployment(resources={"diagrams\\loanrequest_firstpart.bpmn20.xml"})</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;public void creditCheckTrue() {</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Map&lt;String, Object&gt; processVariables = new HashMap&lt;String, Object&gt;();</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;processVariables.put("creditCheckOk", true);</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;processVariables.put("name", "Miss Piggy");</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;processVariables.put("income", 100l);</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;processVariables.put("loanAmount", 10l);</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;processVariables.put("emailAddress", "miss.piggy@localhost");</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;activitiRule.getRuntimeService().startProcessInstanceByKey(</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "loanrequest", processVariables);</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;List&lt;HistoricDetail&gt; historyVariables = activitiRule.getHistoryService()//This object is coming null</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .createHistoricDetailQuery()</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .variableUpdates()</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .orderByVariableName()</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .asc()</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .list();</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;assertNotNull(historyVariables);</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;assertEquals(0, historyVariables.size());</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HistoricVariableUpdate loanAppUpdate = ((HistoricVariableUpdate) historyVariables.get(0));</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;assertEquals("loanApplication", loanAppUpdate.getVariableName());</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;LoanApplication la = (LoanApplication) loanAppUpdate.getValue();</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;assertEquals(true, la.isCreditCheckOk()); </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;}</SPAN><BR /><SPAN>}</SPAN><BR /><BR /><SPAN>When the processes will be saved in database.</SPAN><BR /></BODY></HTML> Thu, 19 Mar 2015 09:08:44 GMT sudhakarkamat 2015-03-19T09:08:44Z Activiti-Process details are not saving in database https://connect.hyland.com/t5/alfresco-archive/activiti-process-details-are-not-saving-in-database/m-p/182854#M135984 Hello team,I am working on running simple BPMN flow through actviti. I am able to execute script and service tasks.But the process details are not getting saved to db .Below are my files.activiti.cfg-mem-fullhistory.xml&lt;?xml version="1.0" encoding="UTF-8"?&gt;&lt;beans xmlns="http://www.springfra Thu, 19 Mar 2015 09:08:44 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-process-details-are-not-saving-in-database/m-p/182854#M135984 sudhakarkamat 2015-03-19T09:08:44Z Re: Activiti-Process details are not saving in database https://connect.hyland.com/t5/alfresco-archive/activiti-process-details-are-not-saving-in-database/m-p/182855#M135985 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>try changing </SPAN><BR /><BR /><SPAN>&lt;code&gt;</SPAN><BR /><SPAN>@Deployment(resources={"diagrams\\loanrequest_firstpart.bpmn20.xml"})</SPAN><BR /><SPAN>&lt;/code&gt;</SPAN><BR /><BR /><SPAN>in </SPAN><BR /><BR /><SPAN>&lt;code&gt;</SPAN><BR /><SPAN>@Deployment(resources = { "diagrams/loanrequest_firstpart.bpmn20.xml" })</SPAN><BR /><SPAN>&lt;/code&gt;</SPAN><BR /><BR /><SPAN>Regards,</SPAN><BR /><BR /><SPAN>Yvo</SPAN><BR /></BODY></HTML> Thu, 19 Mar 2015 13:18:55 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-process-details-are-not-saving-in-database/m-p/182855#M135985 yvoswillens 2015-03-19T13:18:55Z