topic View details page broken on alfresco Using CallActiviti to call another workflow in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/view-details-page-broken-on-alfresco-using-callactiviti-to-call/m-p/282484#M235614 <HTML><HEAD></HEAD><BODY><SPAN>Hi All,</SPAN><BR /><BR /><SPAN>Having an issue when I try to make use of callActiviti. </SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />&lt;callActivity id="sjsActionCallActiviti" name="Call activity - Sjs Action" calledElement="sjsWorkflow"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;extensionElements&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;activiti:in sourceExpression="${edtrmwf_requiredGroupAssignee}" target="edtrmwf_requiredGroupAssignee"&gt;&lt;/activiti:in&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;activiti:in sourceExpression="${bpm_package}" target="bpm_package"&gt;&lt;/activiti:in&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;activiti:in sourceExpression="${bpm_workflowDescription}" target="bpm_workflowDescription"&gt;&lt;/activiti:in&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;activiti:out sourceExpression="${bpm_package}" target="bpm_package"&gt;&lt;/activiti:out&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/extensionElements&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;/callActivity&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></CODE></PRE><BR /><BR /><SPAN>If you run the workflows as standalone workflows they work just fine.The issue at hand is presented when you actually try to invoke another workflow using callActiviti</SPAN><BR /><BR /><SPAN>Using callACtiviti workflow 1 calls workflow 2. At this point when workflow 2 is executed two tasks are created: the Start Task/Event as well as the following task after the start event task. If you attempt to view the Workflow 2 Details page, under the "Current Tasks" table, there are 2 active tasks:</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>the startTask (start1234) and (following1235) task which is the task coming after the start event/task. </SPAN><BR /><BR /><SPAN>At this point you can still view the details of the Workflow 2. Completing the next Task (1235) and attempting to view the Workflow details page, an error is thrown: "Failure"</SPAN><BR /><BR /><SPAN>Below is the log information following the error:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />message": "07260017 Wrapped Exception (with status template): Query return 3 results instead of max 1",<BR />"exception": "org.springframework.extensions.webscripts.WebScriptException - 07260017 Wrapped Exception (with status template): Query return 3 results instead of max 1",<BR />"callstack": [<BR /> <BR />&nbsp;&nbsp;&nbsp; "",<BR />&nbsp;&nbsp;&nbsp; "org.activiti.engine.ActivitiException: Query return 3 results instead of max 1",<BR />&nbsp;&nbsp;&nbsp; "org.activiti.engine.impl.AbstractQuery.executeSingleResult(AbstractQuery.java:161)",<BR />&nbsp;&nbsp;&nbsp; "org.activiti.engine.impl.AbstractQuery.execute(AbstractQuery.java:140)",<BR />&nbsp;&nbsp;&nbsp; "org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)",<BR />&nbsp;&nbsp;&nbsp; "org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)",<BR />&nbsp;&nbsp;&nbsp; "org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)",<BR />&nbsp;&nbsp;&nbsp; "org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)",<BR />&nbsp;&nbsp;&nbsp; "org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)",<BR />&nbsp;&nbsp;&nbsp; "org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)",<BR />&nbsp;&nbsp;&nbsp; "org.activiti.engine.impl.AbstractQuery.singleResult(AbstractQuery.java:103)",<BR />&nbsp;&nbsp;&nbsp; "org.alfresco.repo.workflow.activiti.properties.ActivitiPropertyConverter.getStartVariables(ActivitiPropertyConverter.java:500)",<BR />&nbsp;&nbsp;&nbsp; "org.alfresco.repo.workflow.activiti.properties.ActivitiPropertyConverter.getStartTaskProperties(ActivitiPropertyConverter.java:439)",<BR />&nbsp;&nbsp;&nbsp; "org.alfresco.repo.workflow.activiti.ActivitiTypeConverter.getVirtualStartTask(ActivitiTypeConverter.java:429)",<BR />&nbsp;&nbsp;&nbsp; "org.alfresco.repo.workflow.activiti.ActivitiTypeConverter.getVirtualStartTask(ActivitiTypeConverter.java:382)",<BR />&nbsp;&nbsp;&nbsp; "org.alfresco.repo.workflow.activiti.ActivitiWorkflowEngine.getStartTask(ActivitiWorkflowEngine.java:2158)",<BR />&nbsp;&nbsp;&nbsp; "org.alfresco.repo.workflow.WorkflowServiceImpl.getStartTask(WorkflowServiceImpl.java:691)",<BR />&nbsp;&nbsp;&nbsp; "sun.reflect.GeneratedMethodAccessor1413.invoke(Unknown Source)",<BR />&nbsp;&nbsp;&nbsp; "sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)",<BR />&nbsp;&nbsp;&nbsp; "java.lang.reflect.Method.invoke(Method.java:597)",<BR />&nbsp;&nbsp;&nbsp; "org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)",<BR />&nbsp;&nbsp;&nbsp; "org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)",<BR />&nbsp;&nbsp;&nbsp; "org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)",<BR />&nbsp;&nbsp;&nbsp; "org.alfresco.repo.security.permissions.impl.AlwaysProceedMethodInterceptor.invoke(AlwaysProceedMethodInterceptor.java:34)",<BR />&nbsp;&nbsp;&nbsp; "org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)",<BR />&nbsp;&nbsp;&nbsp; "org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:46)",<BR />&nbsp;&nbsp;&nbsp; "org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)",<BR />&nbsp;&nbsp;&nbsp; "org.alfresco.repo.audit.AuditMethodInterceptor.proceedWithAudit(AuditMethodInterceptor.java:245)",<BR />&nbsp;&nbsp;&nbsp; "org.alfresco.repo.audit.AuditMethodInterceptor.proceed(AuditMethodInterceptor.java:211)",<BR />&nbsp;&nbsp;&nbsp; "org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:164)",<BR />&nbsp;&nbsp;&nbsp; "org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)",<BR />&nbsp;&nbsp;&nbsp; "org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)",<BR />&nbsp;&nbsp;&nbsp; "org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)",<BR />&nbsp;&nbsp;&nbsp; "org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)",<BR />&nbsp;&nbsp;&nbsp; "com.sun.proxy.$Proxy365.getStartTask(Unknown Source)",<BR />&nbsp;&nbsp;&nbsp; "org.alfresco.repo.web.scripts.workflow.WorkflowModelBuilder.buildDetailed(WorkflowModelBuilder.java:305)",<BR />&nbsp;&nbsp;&nbsp; "org.alfresco.repo.web.scripts.workflow.WorkflowInstanceGet.buildModel(WorkflowInstanceGet.java:60)",<BR />&nbsp;&nbsp;&nbsp; "org.alfresco.repo.web.scripts.workflow.AbstractWorkflowWebscript.executeImpl(AbstractWorkflowWebscript.java:80)",<BR />&nbsp;&nbsp;&nbsp; "org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:64)",<BR />&nbsp;&nbsp;&nbsp; "org.alfresco.repo.web.scripts.RepositoryContainer$2.execute(RepositoryContainer.java:410)",<BR />&nbsp;&nbsp;&nbsp; "org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)",<BR />&nbsp;&nbsp;&nbsp; "org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:479)",<BR />&nbsp;&nbsp;&nbsp; "org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:517)",<BR />&nbsp;&nbsp;&nbsp; "org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:333)",<BR />&nbsp;&nbsp;&nbsp; "org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:377)",<BR />&nbsp;&nbsp;&nbsp; "org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:209)",<BR />&nbsp;&nbsp;&nbsp; "org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:118)",<BR />&nbsp;&nbsp;&nbsp; "javax.servlet.http.HttpServlet.service(HttpServlet.java:717)",<BR />&nbsp;&nbsp;&nbsp; "org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)",<BR />&nbsp;&nbsp;&nbsp; "org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)",<BR />&nbsp;&nbsp;&nbsp; "org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:61)",<BR />&nbsp;&nbsp;&nbsp; "org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)",<BR />&nbsp;&nbsp;&nbsp; "org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)",<BR />&nbsp;&nbsp;&nbsp; "org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)",<BR />&nbsp;&nbsp;&nbsp; "org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)",<BR />&nbsp;&nbsp;&nbsp; "org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)",<BR />&nbsp;&nbsp;&nbsp; "org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)",<BR />&nbsp;&nbsp;&nbsp; "org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)",<BR />&nbsp;&nbsp;&nbsp; "org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:183)",<BR />&nbsp;&nbsp;&nbsp; "org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)",<BR />&nbsp;&nbsp;&nbsp; "org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:95)",<BR />&nbsp;&nbsp;&nbsp; "org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)",<BR />&nbsp;&nbsp;&nbsp; "org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)",<BR />&nbsp;&nbsp;&nbsp; "org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)",<BR />&nbsp;&nbsp;&nbsp; "org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)",<BR />&nbsp;&nbsp;&nbsp; "org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)",<BR />&nbsp;&nbsp;&nbsp; "org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)",<BR />&nbsp;&nbsp;&nbsp; "org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)",<BR />&nbsp;&nbsp;&nbsp; "org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)",<BR />&nbsp;&nbsp;&nbsp; "org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:599)",<BR />&nbsp;&nbsp;&nbsp; "org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:451)",<BR />&nbsp;&nbsp;&nbsp; "java.lang.Thread.run(Thread.java:662)",<BR />&nbsp;&nbsp;&nbsp; "org.springframework.extensions.webscripts.WebScriptException: 07260017 Wrapped Exception (with status template): Query return 3 results instead of max 1",<BR />&nbsp;&nbsp;&nbsp; "org.springframework.extensions.webscripts.AbstractWebScript.createStatusException(AbstractWebScript.java:1050)"<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></CODE></PRE><BR /><BR /><BR /><SPAN>The above error is only thrown when you attempt to view the Workflow 2 Details Page. You can view the (workflow 1) details page at anytime with no issues.</SPAN><BR /><BR /><SPAN>EDIT:</SPAN><BR /><BR /><SPAN>After further debuging I was able to pinpoint the code where the issue is taking place. I may be wrong but the error occurs at this piece of code.</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />package org.alfresco.repo.workflow.activiti.properties;<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>ActivitiPropertyConverter.java</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR /><BR />&nbsp;&nbsp;&nbsp; /**<BR />&nbsp;&nbsp;&nbsp;&nbsp; * @param historicProcessInstance<BR />&nbsp;&nbsp;&nbsp;&nbsp; * @return<BR />&nbsp;&nbsp;&nbsp;&nbsp; */<BR />&nbsp;&nbsp;&nbsp; public Map&lt;String, Object&gt; getStartVariables(HistoricProcessInstance historicProcessInstance)<BR />&nbsp;&nbsp;&nbsp; {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // Get historic variable values for start-event<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; HistoricActivityInstance startEvent = activitiUtil.getHistoryService()<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .createHistoricActivityInstanceQuery()<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .processInstanceId(historicProcessInstance.getId())<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .activityId(historicProcessInstance.getStartActivityId())<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .singleResult();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Map&lt;String, Object&gt; variables = getHistoricActivityVariables(startEvent.getId());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return variables;<BR />&nbsp;&nbsp;&nbsp; }<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></CODE></PRE><BR /><BR /><BR /><SPAN>Sincerely,</SPAN><BR /><SPAN>/Ed</SPAN><BR /></BODY></HTML> Wed, 28 Aug 2013 20:44:39 GMT root 2013-08-28T20:44:39Z View details page broken on alfresco Using CallActiviti to call another workflow https://connect.hyland.com/t5/alfresco-archive/view-details-page-broken-on-alfresco-using-callactiviti-to-call/m-p/282484#M235614 Hi All,Having an issue when I try to make use of callActiviti. &lt;callActivity id="sjsActionCallActiviti" name="Call activity - Sjs Action" calledElement="sjsWorkflow"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;extensionElements&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;activiti:in sourceExpression="${edtrmwf_requiredGroupAssignee}" target="edtrmwf_requi Wed, 28 Aug 2013 20:44:39 GMT https://connect.hyland.com/t5/alfresco-archive/view-details-page-broken-on-alfresco-using-callactiviti-to-call/m-p/282484#M235614 root 2013-08-28T20:44:39Z Re: View details page broken on alfresco Using CallActiviti to call another workflow https://connect.hyland.com/t5/alfresco-archive/view-details-page-broken-on-alfresco-using-callactiviti-to-call/m-p/282485#M235615 <HTML><HEAD></HEAD><BODY><SPAN>Alfresco is working in a fix for Version of Alfresco Enterprise 4.1.6 / 4.2. Do not know the status on the Community Edition.</SPAN><BR /><BR /><SPAN>/Ed</SPAN></BODY></HTML> Fri, 13 Sep 2013 19:29:56 GMT https://connect.hyland.com/t5/alfresco-archive/view-details-page-broken-on-alfresco-using-callactiviti-to-call/m-p/282485#M235615 root 2013-09-13T19:29:56Z