nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Exception while running Vacation Request flow

vishals

Hi,

I am getting the following exception when i am running the Vacation Request flow. Also i would like to give a context along with this regarding my application. I am current using activiti-emgine as a jar in my spring application and am developing functionality where in i am using following operations formService.submitStartFormData & formService.submitTaskFormData to carry out the workflow activities. The exception occurs on execution of method formService.submitTaskFormData (not the first time, but on the second loop as the user adjust his days and resends it to his manager and then the manager tries to confirm the adjusted request, in the context of vacation request flow).

Exception:
org.apache.ibatis.exceptions.TooManyResultsException: Expected one result (or null) to be returned by selectOne(), but found: 2
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:42)
   at org.activiti.engine.impl.db.DbSqlSession.selectOne(DbSqlSession.java:175)
   at org.activiti.engine.impl.db.DbHistorySession.findHistoricActivityInstance(DbHistorySession.java:76)
   at org.activiti.engine.impl.history.HistoricFormPropertyEntity.<init>(HistoricFormPropertyEntity.java:45)
   at org.activiti.engine.impl.cmd.SubmitTaskFormCmd.execute(SubmitTaskFormCmd.java:63)
   at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:22)
   at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:37)
   at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)
   at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
   at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)
   at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
   at org.activiti.engine.impl.FormServiceImpl.submitTaskFormData(FormServiceImpl.java:64)
   at org.mkcl.insyncflow.controller.WorkflowController.submitUserTask(WorkflowController.java:196)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
   at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:427)
   at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:415)
   at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:788)
   at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:717)
   at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)
   at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:113)
   at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:366)
   at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
   at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
   at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:97)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
   at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:100)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
   at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:78)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
   at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
   at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:35)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
   at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
   at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
   at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
   at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:167)
   at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
   at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
   at java.lang.Thread.run(Thread.java:680)

Please let me know the solution, if this a bug or if am making any mistake. Thanks

WorkflowController.java.zip

Find more posts tagged with

Comments

frederikherema1

Hi,

Thanks for reporting this bug. I've created an issue for this problem and It will be fixed in 5.3.

http://jira.codehaus.org/browse/ACT-621

ben11

I am having a similar error with Activiti 5.3:

2011-03-12 16:56:15,545 [http-8093-3] ERROR interceptor.CommandContext&nbsp; - Error while closing command context<br>org.apache.ibatis.exceptions.TooManyResultsException: Expected one result (or null) to be returned by selectOne(), but found: 2<br> at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:42)<br> at org.activiti.engine.impl.db.DbSqlSession.selectOne(DbSqlSession.java:179)<br> at org.activiti.engine.impl.db.DbRepositorySession.findDeployedLatestProcessDefinitionByKey(DbRepositorySession.java:168)<br> at org.activiti.engine.impl.cmd.StartProcessInstanceCmd.execute(StartProcessInstanceCmd.java:52)<br> at org.activiti.engine.impl.cmd.StartProcessInstanceCmd.execute(StartProcessInstanceCmd.java:29)<br> at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)<br> at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)<br> at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)<br> at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)<br> at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)<br> at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)<br> at org.activiti.engine.impl.RuntimeServiceImpl.startProcessInstanceByKey(RuntimeServiceImpl.java:49)<br> at org.activiti.engine.RuntimeService$startProcessInstanceByKey.call(Unknown Source)<br> at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)<br> at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)<br> at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:128)<br> at org.grails.activiti.ActivitiService.startProcess(ActivitiService.groovy:37)<br> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<br> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br> at java.lang.reflect.Method.invoke(Method.java:597)<br> at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)<br> at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)<br> at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)<br> at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)<br> at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)<br> at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:970)<br> at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)<br> at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)<br> at org.codehaus.groovy.runtime.callsite.PogoMetaClassSite.callCurrent(PogoMetaClassSite.java:66)<br> at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(CallSiteArray.java:44)<br> at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:141)<br> at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:149)<br> at ActivitiGrailsPlugin$_addActivitiMethods_closure7_closure29.doCall(ActivitiGrailsPlugin.groovy:128)<br> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<br> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br> at java.lang.reflect.Method.invoke(Method.java:597)<br> at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)<br> at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)<br> at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)<br> at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)<br> at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)<br> at groovy.lang.Closure.call(Closure.java:282)<br> at groovy.lang.Closure.call(Closure.java:295)<br> at org.codehaus.groovy.runtime.DefaultGroovyMethods.with(DefaultGroovyMethods.java:168)<br> at org.codehaus.groovy.runtime.dgm$719.invoke(Unknown Source)<br> at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite$PogoMetaMethodSiteNoUnwrapNoCoerce.invoke(PogoMetaMethodSite.java:307)<br> at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite.call(PogoMetaMethodSite.java:63)<br> at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)<br> at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)<br> at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:124)<br> at ActivitiGrailsPlugin$_addActivitiMethods_closure7.doCall(ActivitiGrailsPlugin.groovy:126)<br> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<br> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br> at java.lang.reflect.Method.invoke(Method.java:597)<br> at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)<br> at org.codehaus.groovy.runtime.metaclass.ClosureMetaMethod.invoke(ClosureMetaMethod.java:80)<br> at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)<br> at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)<br> at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)<br> at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)<br> at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1003)<br> at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)<br> at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)<br> at org.codehaus.groovy.runtime.callsite.PogoMetaClassSite.callCurrent(PogoMetaClassSite.java:66)<br> at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(CallSiteArray.java:44)<br> at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:141)<br> at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:149)<br> at testWorkflow.TestWorkflowController$_closure2.doCall(TestWorkflowController.groovy:17)<br> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<br> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br> at java.lang.reflect.Method.invoke(Method.java:597)<br> at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite$PogoCachedMethodSite.invoke(PogoMetaMethodSite.java:225)<br> at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite.callCurrent(PogoMetaMethodSite.java:51)<br> at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(CallSiteArray.java:44)<br> at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:141)<br> at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:149)<br> at testWorkflow.TestWorkflowController$_closure2.doCall(TestWorkflowController.groovy)<br> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<br> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br> at java.lang.reflect.Method.invoke(Method.java:597)<br> at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)<br> at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)<br> at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)<br> at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)<br> at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)<br> at groovy.lang.Closure.call(Closure.java:282)<br> at groovy.lang.Closure.call(Closure.java:277)<br> at org.codehaus.groovy.grails.web.servlet.mvc.SimpleGrailsControllerHelper.handleAction(SimpleGrailsControllerHelper.java:368)<br> at org.codehaus.groovy.grails.web.servlet.mvc.SimpleGrailsControllerHelper.executeAction(SimpleGrailsControllerHelper.java:232)<br> at org.codehaus.groovy.grails.web.servlet.mvc.SimpleGrailsControllerHelper.handleURI(SimpleGrailsControllerHelper.java:190)<br> at org.codehaus.groovy.grails.web.servlet.mvc.SimpleGrailsControllerHelper.handleURI(SimpleGrailsControllerHelper.java:129)<br> at org.codehaus.groovy.grails.web.servlet.mvc.SimpleGrailsController.handleRequest(SimpleGrailsController.java:73)<br> at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)<br> at org.codehaus.groovy.grails.web.servlet.GrailsDispatcherServlet.doDispatch(GrailsDispatcherServlet.java:292)<br> at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)<br> at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)<br> at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:549)<br> at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)<br> at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70)<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70)<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70)<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70)<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)<br> at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)<br> at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)<br> at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)<br> at org.codehaus.groovy.grails.web.util.WebUtils.forwardRequestForUrlMappingInfo(WebUtils.java:298)<br> at org.codehaus.groovy.grails.web.util.WebUtils.forwardRequestForUrlMappingInfo(WebUtils.java:264)<br> at org.codehaus.groovy.grails.web.util.WebUtils.forwardRequestForUrlMappingInfo(WebUtils.java:255)<br> at org.codehaus.groovy.grails.web.mapping.filter.UrlMappingsFilter.doFilterInternal(UrlMappingsFilter.java:183)<br> at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at org.codehaus.groovy.grails.web.sitemesh.GrailsPageFilter.obtainContent(GrailsPageFilter.java:245)<br> at org.codehaus.groovy.grails.web.sitemesh.GrailsPageFilter.doFilter(GrailsPageFilter.java:134)<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at org.codehaus.groovy.grails.web.servlet.filter.GrailsReloadServletFilter.doFilterInternal(GrailsReloadServletFilter.java:104)<br> at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at org.codehaus.groovy.grails.web.servlet.mvc.GrailsWebRequestFilter.doFilterInternal(GrailsWebRequestFilter.java:69)<br> at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at org.codehaus.groovy.grails.web.filters.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:69)<br> at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)<br> at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)<br> at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)<br> at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)<br> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)<br> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)<br> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)<br> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)<br> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)<br> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)<br> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)<br> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)<br> at java.lang.Thread.run(Thread.java:662)<br>2011-03-12 16:56:15,578 [http-8093-3] ERROR errors.GrailsExceptionResolver&nbsp; - Exception occurred when processing request: [GET] /act-test3/testWorkflow/start<br>Stacktrace follows:<br>org.apache.ibatis.exceptions.TooManyResultsException: Expected one result (or null) to be returned by selectOne(), but found: 2<br> at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:42)<br> at org.activiti.engine.impl.db.DbSqlSession.selectOne(DbSqlSession.java:179)<br> at org.activiti.engine.impl.db.DbRepositorySession.findDeployedLatestProcessDefinitionByKey(DbRepositorySession.java:168)<br> at org.activiti.engine.impl.cmd.StartProcessInstanceCmd.execute(StartProcessInstanceCmd.java:52)<br> at org.activiti.engine.impl.cmd.StartProcessInstanceCmd.execute(StartProcessInstanceCmd.java:29)<br> at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)<br> at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)<br> at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)<br> at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)<br> at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)<br> at org.activiti.engine.impl.RuntimeServiceImpl.startProcessInstanceByKey(RuntimeServiceImpl.java:49)<br> at org.activiti.engine.RuntimeService$startProcessInstanceByKey.call(Unknown Source)<br> at org.grails.activiti.ActivitiService.startProcess(ActivitiService.groovy:37)<br> at ActivitiGrailsPlugin$_addActivitiMethods_closure7_closure29.doCall(ActivitiGrailsPlugin.groovy:128)<br> at ActivitiGrailsPlugin$_addActivitiMethods_closure7.doCall(ActivitiGrailsPlugin.groovy:126)<br> at testWorkflow.TestWorkflowController$_closure2.doCall(TestWorkflowController.groovy:17)<br> at testWorkflow.TestWorkflowController$_closure2.doCall(TestWorkflowController.groovy)<br> at java.lang.Thread.run(Thread.java:662)

If anyone can share any insight I'd appreciate it.
-Ben

frederikherema1

Looks like there are 2 process-definitions which the same key who have the same version (and are the latest for that key). Can you check this?

How did you deploy your process-definitions?

ben11

You were right, Frederik. Deleting the database entries and redeploying solved the problem.

I'm using the Activiti plugin for Grails, and am deploying by putting the workflow XML file in the grails-app/conf directory.

Thanks!
-Ben

rufini

Hi

I had the same exception ("Expected one result (or null) to be returned by selectOne(), but found: 2") with Activiti 5.6 in my app.

I found which entries had the same key/version in ACT_RE_PROCDEF:

ID_, CATEGORY_, NAME_, KEY_, VERSION_, DEPLOYMENT_ID_, RESOURCE_NAME_, DGRM_RESOURCE_NAME_, HAS_START_FORM_KEY_<br><br>'myProcess:167:150103', 'Checkout', NULL, 'myProcess', '167', '150101', 'c:\path1\myProcess.bpmn20.xml', NULL, '0'<br>'myProcess:167:150203', 'Checkout', NULL, 'myProcess', '167', '150201', 'c:\path2\different\myProcess.bpmn20.xml', NULL, '0'<br>

As you can see, there are 2 different paths because it's running in 2 computers.

To fix the issue, I just deleted one entry [removing also the constrain with ACT_RU_TASK.proc_def_id_]

Now I'm trying hard to reproduce the bug but I can't.

How can I be sure that a new version number will be generated each time it runs?. Any advice, or theory on how could this happend?

Thanks!
rufini

rahulbabarit

Hi All,

I am facing similar issue while using activiti 5.5

org.apache.ibatis.exceptions.TooManyResultsException: Expected one result (or null) to be returned by selectOne(), but found: 2
org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:44)
org.activiti.engine.impl.db.DbSqlSession.selectOne(DbSqlSession.java:191)
org.activiti.engine.impl.persistence.entity.ProcessDefinitionManager.findLatestProcessDefinitionByKey(ProcessDefinitionManager.java:32)
org.activiti.engine.impl.bpmn.deployer.BpmnDeployer.deploy(BpmnDeployer.java:111)
org.activiti.engine.impl.persistence.deploy.DeploymentCache.deploy(DeploymentCache.java:37)
org.activiti.engine.impl.persistence.entity.DeploymentManager.insertDeployment(DeploymentManager.java:39)
org.activiti.engine.impl.cmd.DeployCmd.execute(DeployCmd.java:57)
org.activiti.engine.impl.cmd.DeployCmd.execute(DeployCmd.java:30)
org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)
org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)
org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
org.activiti.engine.impl.RepositoryServiceImpl.deploy(RepositoryServiceImpl.java:43)
org.activiti.engine.impl.repository.DeploymentBuilderImpl.deploy(DeploymentBuilderImpl.java:105)
com.vit.cms.workflow.WorkflowManager.<init>(WorkflowManager.java:29)
com.vit.cms.ui.servlet.BeginReleaseServlet.processRequest(BeginReleaseServlet.java:64)
com.vit.cms.ui.servlet.BeginReleaseServlet.doPost(BeginReleaseServlet.java:116)
javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
com.vit.cms.ui.filter.AccessControlFilter.doFilter(AccessControlFilter.java:52)
com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119)
com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55)

I appreciate your suggestions and advice.

Thanks,
Rahul Babar

frankee787

I too had the same error. Got it fixed after deleting one record.

I believe its a bug and extremely hard to reproduce. Seems like occured when the process was deployed from two machines at nearly the same time.

Regards,
Franklin

hamed

Hi
I have this issue with activiti5.8. In my opinion, it would be good to prevent the deployment of duplicate record instead of getting exception ! ?

ingo_ri

The deployment of the same process is already blocked by the org.activiti.engine.impl.cmd.DeployCmd if the deployment doesn't differ (check the source code for more details). Is there a difference in your deployments?

The only way to set the version of a process definition to a value that already exists in the database, is getting it from the deployment cache.

Kind Regards, Ingo

shardt

This problem still persists in version 5.8.
We do deploy the engine in two separate applications at the same time with the same @Singleton @Startup EJB in a JBoss 7 via a cli-script.
There seems to be a high probability that the engine starts up at the exact same time.
As an effect the database table ACT_RE_PROCDEF contains duplicate entries of processes with the same id and version.
If both applications are deployed with a delay the problem does not occur.

The engine is configured via createProcessEngineConfigurationFromResourceDefault.
activiti.cfg.xml contains:

<br>&nbsp;&nbsp; <bean id="transactionManager" class="org.springframework.transaction.jta.JtaTransactionManager"><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <property name="transactionManagerName" value="java:jboss/TransactionManager" /><br>&nbsp;&nbsp;&nbsp; </bean><br>&nbsp;&nbsp;&nbsp; <bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration"><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <property name="dataSourceJndiName" value="java:jboss/datasources/datasource.name" /><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <property name="transactionManager" ref="transactionManager" /><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <property name="transactionsExternallyManaged" value="true" /><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <property name="databaseSchemaUpdate" value="true" /><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <property name="mailServerHost" value="mail " /><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <property name="mailServerPort" value="25" /><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <property name="deploymentResources" value="classpath:/diagrams/*.bpmn20.xml" /><br>&nbsp;&nbsp;&nbsp; </bean><br>

It uses the same resources in booth applications.
(This is only an interims implementation and not for production, but it produces the problem.)

database table ACT_RE_PROCDEF with duplicate entries:

<br>ID_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CATEGORY_&nbsp;&nbsp; NAME_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; KEY_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VERSION_&nbsp; DEPLOYMENT_ID_<br>Prototype_flow_activiti:10:2008&nbsp; http://&hellip;&nbsp; prototype_flow_activiti&nbsp; Prototype_flow_activiti&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2001<br>Prototype_flow_activiti:10:2108&nbsp; http://&hellip;&nbsp; prototype_flow_activiti&nbsp; Prototype_flow_activiti&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2101<br>

trademak

Hi,

In a clustered environment it's not a good idea to use the autodeploy feature on more than 1 Activiti instance.
Would it work for you to have the autodeploy feature only active on 1 instance?

Best regards,

goekan-t

Hi,
we are running Activiti 5.5 and had the same Problem in our production system. (Additional info: We are using the SpringAutoDeployment. So the bug http://jira.codehaus.org/browse/ACT-736 affects the deployment.)
I agree with Franklin: "Seems like occured when the process was deployed from two machines at nearly the same time." The problem occured when four servers where rebooted at the same time.
It ended up that none of the applications started sucessfully!

As written in http://forums.activiti.org/en/viewtopic.php?f=6&t=2207&p=9360 the solution can be a unique constraint because the engine acts like there is one.
ALTER TABLE `ACT_RE_PROCDEF` ADD UNIQUE INDEX `KEY_VERSION` (`KEY_` ASC, `VERSION_` ASC) ;By adding this only the instance that wants to insert the duplicate will fail to start.

Is it possible to add this to the next release?

Regards,
Tobi

spanko

Hi,

we are also hit by this problem using Activiti 5.9, and I was wondering if it is possible to delegate the version increment using a DB sequence. I saw that this code is executed to perform the version increment (taken from org.activiti.engine.impl.bpmn.deployer.BpmnDeployer):

<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ProcessDefinitionEntity latestProcessDefinition = processDefinitionManager.findLatestProcessDefinitionByKey(processDefinition.getKey());<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (latestProcessDefinition != null) {<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; processDefinitionVersion = latestProcessDefinition.getVersion() + 1;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } else {<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; processDefinitionVersion = 1;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<br>

If the increment of the version would simply done by a DB sequence, this would ensure that at least the version is incremented every time during a deployment, even if two instances are started almost simultaneously (which happens in our case). Of course the versions would no longer be consecutive (and not even start at "1"), but at least it would be ensured that they are increasing. Since DB sequences (at least in PostgresQL) are not rolled back even in failure cases and access to a sequence is atomic, there would be no collision.

WDYT?

Regards

Sven

frederikherema1

Sven,

Since not all DB's we support, have sequences, this approach isn't generic enough to implement in the engine. As Tijs said, it's not a good idea to use automatic resource-deployment on a cluster. But the solution Tobi suggested with a database-constraint on key and version should prevent any double-inserts.

https://jira.codehaus.org/browse/ACT-1280

satheesh1

HI

I have same error referred above: Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngine': FactoryBean threw exception on object creation; nested exception is org.apache.ibatis.exceptions.TooManyResultsException: Expected one result (or null) to be returned by selectOne(), but found: 2

i found 9 process to have duplicate records in ACT_RE_PROCDEF.
I updated the VERSION_ of the duplicate records to 0, since this is production version i was not allowed to delete the records.

I did select the max version and modified the process belongs to that version, is this correct approach?

i have totally 12 process defenitions but i see only 9 of the procdef KEY_ with max VERSION_ - what is happening to remaining process?

the app is deployed in 2 tomcat servers. one of the server is already running second one faces issues. After updating the duplicate record VERSION_ i tried to restart the tomcat servers and i am still getting the same error. Is it cached somewhere? i deleted the webapps and Catalina/localhost app folders before starting the server. still i get the same error, pls advise.

using Activiti 5.10

Thanks
Satheesh