topic HistoryServiceTest, 2 results instead of max 1 in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/historyservicetest-2-results-instead-of-max-1/m-p/204793#M157923 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>I'm having an issue using the HistoryServiceTest class from the book. When I run this class, I get this error of the JUnit tests:</SPAN><BR /><BR /><SPAN>JUnit test error:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />org.activiti.engine.ActivitiException: Query return 2 results instead of max 1<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.AbstractQuery.executeSingleResult(AbstractQuery.java:162)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.AbstractQuery.execute(AbstractQuery.java:141)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:24)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:57)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.AbstractQuery.singleResult(AbstractQuery.java:104)<BR />&nbsp;&nbsp;&nbsp;at BookOrderHistoryTest.startAndComplete(BookOrderHistoryTest.java:33)<BR />&nbsp;&nbsp;&nbsp;at BookOrderHistoryTest.queryHistoricInstances(BookOrderHistoryTest.java:44)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47)<BR />&nbsp;&nbsp;&nbsp;at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)<BR />&nbsp;&nbsp;&nbsp;at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44)<BR />&nbsp;&nbsp;&nbsp;at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.test.ActivitiRule$1.evaluate(ActivitiRule.java:126)<BR />&nbsp;&nbsp;&nbsp;at org.junit.rules.RunRules.evaluate(RunRules.java:20)<BR />&nbsp;&nbsp;&nbsp;at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:271)<BR />&nbsp;&nbsp;&nbsp;at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:70)<BR />&nbsp;&nbsp;&nbsp;at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50)<BR />&nbsp;&nbsp;&nbsp;at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238)<BR />&nbsp;&nbsp;&nbsp;at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63)<BR />&nbsp;&nbsp;&nbsp;at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236)<BR />&nbsp;&nbsp;&nbsp;at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53)<BR />&nbsp;&nbsp;&nbsp;at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229)<BR />&nbsp;&nbsp;&nbsp;at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)<BR />&nbsp;&nbsp;&nbsp;at org.junit.runners.ParentRunner.run(ParentRunner.java:309)<BR />&nbsp;&nbsp;&nbsp;at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)<BR />&nbsp;&nbsp;&nbsp;at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)<BR />&nbsp;&nbsp;&nbsp;at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459)<BR />&nbsp;&nbsp;&nbsp;at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:675)<BR />&nbsp;&nbsp;&nbsp;at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382)<BR />&nbsp;&nbsp;&nbsp;at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192)<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></CODE></PRE><BR /><BR /><SPAN>Does any one have an idea?</SPAN><BR /><BR /><SPAN>Here is the XML and the HistoryServiceTest:</SPAN><BR /><BR /><SPAN>bookorder.bpmn20.xml</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />&lt;?xml version="1.0" encoding="UTF-8"?&gt;<BR />&lt;definitions xmlns="<A href="http://www.omg.org/spec/BPMN/20100524/MODEL" rel="nofollow noopener noreferrer">http://www.omg.org/spec/BPMN/20100524/MODEL</A>" xmlns:xsi="<A href="http://www.w3.org/2001/XMLSchema-instance" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema-instance</A>" xmlns:xsd="<A href="http://www.w3.org/2001/XMLSchema" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema</A>" xmlns:activiti="<A href="http://activiti.org/bpmn" rel="nofollow noopener noreferrer">http://activiti.org/bpmn</A>" xmlns:bpmndi="<A href="http://www.omg.org/spec/BPMN/20100524/DI" rel="nofollow noopener noreferrer">http://www.omg.org/spec/BPMN/20100524/DI</A>" xmlns:omgdc="<A href="http://www.omg.org/spec/DD/20100524/DC" rel="nofollow noopener noreferrer">http://www.omg.org/spec/DD/20100524/DC</A>" xmlns:omgdi="<A href="http://www.omg.org/spec/DD/20100524/DI" rel="nofollow noopener noreferrer">http://www.omg.org/spec/DD/20100524/DI</A>" typeLanguage="<A href="http://www.w3.org/2001/XMLSchema" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema</A>" expressionLanguage="<A href="http://www.w3.org/1999/XPath" rel="nofollow noopener noreferrer">http://www.w3.org/1999/XPath</A>" targetNamespace="<A href="http://www.bpmnwithactiviti.org" rel="nofollow noopener noreferrer">http://www.bpmnwithactiviti.org</A>"&gt;<BR />&nbsp; &lt;process id="bookorder" name="Order book" isExecutable="true"&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;startEvent id="startevent1" name="Start"&gt;&lt;/startEvent&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;sequenceFlow id="sequenceflow1" name="Validate order" sourceRef="startevent1" targetRef="scripttask1"&gt;&lt;/sequenceFlow&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;scriptTask id="scripttask1" name="Validate order" scriptFormat="groovy" activiti:autoStoreVariables="false"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;script&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;out:println "validating order for isbn " + isbn;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/script&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;/scriptTask&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;sequenceFlow id="sequenceflow2" name="Sending to sales" sourceRef="scripttask1" targetRef="usertask1"&gt;&lt;/sequenceFlow&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;userTask id="usertask1" name="Work on order" activiti:candidateGroups="Sales"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;documentation&gt;book order user task&lt;/documentation&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;/userTask&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;sequenceFlow id="sequenceflow3" name="Ending process" sourceRef="usertask1" targetRef="endevent1"&gt;&lt;/sequenceFlow&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;endEvent id="endevent1" name="End"&gt;&lt;/endEvent&gt;<BR />&nbsp; &lt;/process&gt;<BR />&nbsp; &lt;bpmndi:BPMNDiagram id="BPMNDiagram_bookorder"&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;bpmndi:BPMNPlane bpmnElement="bookorder" id="BPMNPlane_bookorder"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;bpmndi:BPMNShape bpmnElement="startevent1" id="BPMNShape_startevent1"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;omgdc:Bounds height="35.0" width="35.0" x="30.0" y="74.0"&gt;&lt;/omgdc:Bounds&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/bpmndi:BPMNShape&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;bpmndi:BPMNShape bpmnElement="scripttask1" id="BPMNShape_scripttask1"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;omgdc:Bounds height="60.0" width="100.0" x="190.0" y="49.0"&gt;&lt;/omgdc:Bounds&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/bpmndi:BPMNShape&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;bpmndi:BPMNShape bpmnElement="usertask1" id="BPMNShape_usertask1"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;omgdc:Bounds height="60.0" width="100.0" x="420.0" y="49.0"&gt;&lt;/omgdc:Bounds&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/bpmndi:BPMNShape&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;bpmndi:BPMNShape bpmnElement="endevent1" id="BPMNShape_endevent1"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;omgdc:Bounds height="35.0" width="35.0" x="710.0" y="74.0"&gt;&lt;/omgdc:Bounds&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/bpmndi:BPMNShape&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;bpmndi:BPMNEdge bpmnElement="sequenceflow1" id="BPMNEdge_sequenceflow1"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;omgdi:waypoint x="65.0" y="91.0"&gt;&lt;/omgdi:waypoint&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;omgdi:waypoint x="190.0" y="79.0"&gt;&lt;/omgdi:waypoint&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;bpmndi:BPMNLabel&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;omgdc:Bounds height="14.0" width="68.0" x="91.0" y="65.0"&gt;&lt;/omgdc:Bounds&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/bpmndi:BPMNLabel&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/bpmndi:BPMNEdge&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;bpmndi:BPMNEdge bpmnElement="sequenceflow2" id="BPMNEdge_sequenceflow2"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;omgdi:waypoint x="290.0" y="79.0"&gt;&lt;/omgdi:waypoint&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;omgdi:waypoint x="262.0" y="78.0"&gt;&lt;/omgdi:waypoint&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;omgdi:waypoint x="420.0" y="79.0"&gt;&lt;/omgdi:waypoint&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;bpmndi:BPMNLabel&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;omgdc:Bounds height="14.0" width="80.0" x="300.0" y="79.0"&gt;&lt;/omgdc:Bounds&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/bpmndi:BPMNLabel&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/bpmndi:BPMNEdge&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;bpmndi:BPMNEdge bpmnElement="sequenceflow3" id="BPMNEdge_sequenceflow3"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;omgdi:waypoint x="520.0" y="79.0"&gt;&lt;/omgdi:waypoint&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;omgdi:waypoint x="710.0" y="91.0"&gt;&lt;/omgdi:waypoint&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;bpmndi:BPMNLabel&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;omgdc:Bounds height="14.0" width="75.0" x="600.0" y="89.0"&gt;&lt;/omgdc:Bounds&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/bpmndi:BPMNLabel&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/bpmndi:BPMNEdge&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;/bpmndi:BPMNPlane&gt;<BR />&nbsp; &lt;/bpmndi:BPMNDiagram&gt;<BR />&lt;/definitions&gt;<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></CODE></PRE><BR /><BR /><SPAN>HistoryServiceTest.class</SPAN><BR /><PRE class="language-java line-numbers"><CODE><BR />package org.bpmnwithactiviti.chapter4.api;<BR /><BR />import static org.junit.Assert.assertEquals;<BR />import static org.junit.Assert.assertNotNull;<BR />import static org.junit.Assert.assertTrue;<BR /><BR />import java.util.HashMap;<BR />import java.util.List;<BR />import java.util.Map;<BR /><BR />import org.activiti.engine.HistoryService;<BR />import org.activiti.engine.RuntimeService;<BR />import org.activiti.engine.TaskService;<BR />import org.activiti.engine.history.HistoricActivityInstance;<BR />import org.activiti.engine.history.HistoricDetail;<BR />import org.activiti.engine.history.HistoricProcessInstance;<BR />import org.activiti.engine.history.HistoricVariableUpdate;<BR />import org.activiti.engine.task.Task;<BR />import org.activiti.engine.test.ActivitiRule;<BR />import org.activiti.engine.test.Deployment;<BR />import org.bpmnwithactiviti.common.AbstractTest;<BR />import org.junit.Rule;<BR />import org.junit.Test;<BR /><BR />public class HistoryServiceTest extends AbstractTest {<BR />&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;@Rule <BR />&nbsp;&nbsp;&nbsp;public ActivitiRule activitiRule = new ActivitiRule("activiti.cfg-mem-fullhistory.xml");<BR />&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;private String startAndComplete() {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;RuntimeService runtimeService = activitiRule.getRuntimeService();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Map&lt;String, Object&gt; variableMap = new HashMap&lt;String, Object&gt;();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variableMap.put("isbn", "123456");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;String processInstanceID = runtimeService.startProcessInstanceByKey("bookorder", variableMap).getId();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TaskService taskService = activitiRule.getTaskService();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Task task = taskService.createTaskQuery().taskCandidateGroup("sales").singleResult();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variableMap = new HashMap&lt;String, Object&gt;();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variableMap.put("extraInfo", "Extra information");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variableMap.put("isbn", "654321");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;taskService.complete(task.getId(), variableMap);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return processInstanceID;<BR />&nbsp;&nbsp;&nbsp;}<BR />&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;@Test<BR />&nbsp;&nbsp;&nbsp;@Deployment(resources={"chapter4/bookorder.bpmn20.xml"})<BR />&nbsp;&nbsp;&nbsp;public void queryHistoricInstances() {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;String processInstanceID = startAndComplete();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HistoryService historyService = activitiRule.getHistoryService();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HistoricProcessInstance historicProcessInstance = historyService.createHistoricProcessInstanceQuery()<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.processInstanceId(processInstanceID)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.singleResult();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;assertNotNull(historicProcessInstance);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;assertEquals(processInstanceID, historicProcessInstance.getId());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;System.out.println("history process with definition id " + historicProcessInstance.getProcessDefinitionId() +<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;", started at " + historicProcessInstance.getStartTime() + <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;", ended at " + historicProcessInstance.getEndTime() +<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;", duration was " + historicProcessInstance.getDurationInMillis());<BR />&nbsp;&nbsp;&nbsp;}<BR />&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;@Test<BR />&nbsp;&nbsp;&nbsp;@Deployment(resources={"chapter4/bookorder.bpmn20.xml"})<BR />&nbsp;&nbsp;&nbsp;public void queryHistoricActivities() {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;startAndComplete();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HistoryService historyService = activitiRule.getHistoryService();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;List&lt;HistoricActivityInstance&gt; activityList = historyService.createHistoricActivityInstanceQuery().list();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;assertEquals(3, activityList.size());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for (HistoricActivityInstance historicActivityInstance : activityList) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;assertNotNull(historicActivityInstance.getActivityId());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;System.out.println("history activity " + historicActivityInstance.getActivityName() +<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;", type " + historicActivityInstance.getActivityType() +<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;", starttime " + historicActivityInstance.getStartTime() +<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;", endtime " + historicActivityInstance.getEndTime() +<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;", duration was " + historicActivityInstance.getDurationInMillis());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<BR />&nbsp;&nbsp;&nbsp;}<BR /><BR />&nbsp;&nbsp;&nbsp;@Test<BR />&nbsp;&nbsp;&nbsp;@Deployment(resources={"chapter4/bookorder.bpmn20.xml"})<BR />&nbsp;&nbsp;&nbsp;public void queryHistoricVariableUpdates() {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;startAndComplete();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HistoryService historyService = activitiRule.getHistoryService();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;List&lt;HistoricDetail&gt; historicVariableUpdateList = historyService.createHistoricDetailQuery().variableUpdates().list();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;assertNotNull(historicVariableUpdateList);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;assertEquals(3, historicVariableUpdateList.size());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for (HistoricDetail historicDetail : historicVariableUpdateList) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;assertTrue(historicDetail instanceof HistoricVariableUpdate);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HistoricVariableUpdate historicVariableUpdate = (HistoricVariableUpdate) historicDetail;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;assertNotNull(historicVariableUpdate.getExecutionId());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;System.out.println("historic variable update, revision " + historicVariableUpdate.getRevision() +<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;", variable type name " + historicVariableUpdate.getVariableTypeName() +<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;", variable name " + historicVariableUpdate.getVariableName() +<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;", Variable value '" + historicVariableUpdate.getValue()+"'");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<BR />&nbsp;&nbsp;&nbsp;}<BR />}<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></CODE></PRE><BR /><BR /><SPAN>AbstractTest class</SPAN><BR /><PRE class="language-java line-numbers"><CODE><BR />package org.bpmnwithactiviti.common;<BR /><BR />import java.util.logging.Handler;<BR />import java.util.logging.LogManager;<BR />import java.util.logging.Logger;<BR /><BR />//import org.activiti.engine.impl.util.LogUtil;<BR />import org.junit.BeforeClass;<BR />import org.slf4j.*;<BR />import org.slf4j.bridge.SLF4JBridgeHandler;<BR /><BR />public abstract class AbstractTest {<BR />&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;@BeforeClass<BR />&nbsp;&nbsp;&nbsp;public static void routeLoggingToSlf4j() {<BR />&nbsp;&nbsp;&nbsp;//&nbsp;&nbsp;&nbsp;LogUtil.readJavaUtilLoggingConfigFromClasspath();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Logger rootLogger = LogManager.getLogManager().getLogger("");&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Handler[] handlers = rootLogger.getHandlers();&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for (int i = 0; i &lt; handlers.length; i++) {&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;rootLogger.removeHandler(handlers<EM>);&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SLF4JBridgeHandler.install();<BR />&nbsp;&nbsp;&nbsp;}<BR /><BR />}<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></EM></CODE></PRE><BR /><BR /><SPAN>Thanks in advance.</SPAN></BODY></HTML> Mon, 01 Sep 2014 08:59:01 GMT tc1 2014-09-01T08:59:01Z HistoryServiceTest, 2 results instead of max 1 https://connect.hyland.com/t5/alfresco-archive/historyservicetest-2-results-instead-of-max-1/m-p/204793#M157923 Hello,I'm having an issue using the HistoryServiceTest class from the book. When I run this class, I get this error of the JUnit tests:JUnit test error<IMG id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />rg.activiti.engine.ActivitiException: Query return 2 results instead of max 1&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.AbstractQuery.executeSingleResult(Abstr Mon, 01 Sep 2014 08:59:01 GMT https://connect.hyland.com/t5/alfresco-archive/historyservicetest-2-results-instead-of-max-1/m-p/204793#M157923 tc1 2014-09-01T08:59:01Z Re: HistoryServiceTest, 2 results instead of max 1 https://connect.hyland.com/t5/alfresco-archive/historyservicetest-2-results-instead-of-max-1/m-p/204794#M157924 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>could you post </SPAN><CODE>BookOrderHistoryTest</CODE><SPAN> class?</SPAN><BR /><BR /><SPAN>Regards</SPAN><BR /><SPAN>Martin</SPAN></BODY></HTML> Tue, 02 Sep 2014 04:46:31 GMT https://connect.hyland.com/t5/alfresco-archive/historyservicetest-2-results-instead-of-max-1/m-p/204794#M157924 martin_grofcik 2014-09-02T04:46:31Z