topic Re: Exception while running Vacation Request flow in Alfresco Archive

Exception while running Vacation Request flow

vishals — Fri, 11 Feb 2011 12:11:44 GMT

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 operat

Re: Exception while running Vacation Request flow

frederikherema1 — Fri, 11 Feb 2011 14:31:29 GMT

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

Re: Exception while running Vacation Request flow

ben11 — Sun, 13 Mar 2011 03:25:43 GMT

I am having a similar error with Activiti 5.3:

2011-03-12 16:56:15,545 [http-8093-3] ERROR interceptor.CommandContext  - Error while closing command context
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:179)
 at org.activiti.engine.impl.db.DbRepositorySession.findDeployedLatestProcessDefinitionByKey(DbRepositorySession.java:168)
 at org.activiti.engine.impl.cmd.StartProcessInstanceCmd.execute(StartProcessInstanceCmd.java:52)
 at org.activiti.engine.impl.cmd.StartProcessInstanceCmd.execute(StartProcessInstanceCmd.java:29)
 at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)
 at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)
 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.RuntimeServiceImpl.startProcessInstanceByKey(RuntimeServiceImpl.java:49)
 at org.activiti.engine.RuntimeService$startProcessInstanceByKey.call(Unknown Source)
 at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
 at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)
 at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:128)
 at org.grails.activiti.ActivitiService.startProcess(ActivitiService.groovy:37)
 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.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)
 at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)
 at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)
 at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
 at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
 at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:970)
 at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
 at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
 at org.codehaus.groovy.runtime.callsite.PogoMetaClassSite.callCurrent(PogoMetaClassSite.java:66)
 at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(CallSiteArray.java:44)
 at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:141)
 at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:149)
 at ActivitiGrailsPlugin$_addActivitiMethods_closure7_closure29.doCall(ActivitiGrailsPlugin.groovy:128)
 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.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)
 at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)
 at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)
 at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
 at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
 at groovy.lang.Closure.call(Closure.java:282)
 at groovy.lang.Closure.call(Closure.java:295)
 at org.codehaus.groovy.runtime.DefaultGroovyMethods.with(DefaultGroovyMethods.java:168)
 at org.codehaus.groovy.runtime.dgm$719.invoke(Unknown Source)
 at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite$PogoMetaMethodSiteNoUnwrapNoCoerce.invoke(PogoMetaMethodSite.java:307)
 at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite.call(PogoMetaMethodSite.java:63)
 at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
 at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)
 at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:124)
 at ActivitiGrailsPlugin$_addActivitiMethods_closure7.doCall(ActivitiGrailsPlugin.groovy:126)
 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.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)
 at org.codehaus.groovy.runtime.metaclass.ClosureMetaMethod.invoke(ClosureMetaMethod.java:80)
 at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)
 at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)
 at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
 at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
 at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1003)
 at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
 at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
 at org.codehaus.groovy.runtime.callsite.PogoMetaClassSite.callCurrent(PogoMetaClassSite.java:66)
 at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(CallSiteArray.java:44)
 at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:141)
 at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:149)
 at testWorkflow.TestWorkflowController$_closure2.doCall(TestWorkflowController.groovy:17)
 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.codehaus.groovy.runtime.callsite.PogoMetaMethodSite$PogoCachedMethodSite.invoke(PogoMetaMethodSite.java:225)
 at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite.callCurrent(PogoMetaMethodSite.java:51)
 at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(CallSiteArray.java:44)
 at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:141)
 at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:149)
 at testWorkflow.TestWorkflowController$_closure2.doCall(TestWorkflowController.groovy)
 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.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)
 at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)
 at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)
 at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
 at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
 at groovy.lang.Closure.call(Closure.java:282)
 at groovy.lang.Closure.call(Closure.java:277)
 at org.codehaus.groovy.grails.web.servlet.mvc.SimpleGrailsControllerHelper.handleAction(SimpleGrailsControllerHelper.java:368)
 at org.codehaus.groovy.grails.web.servlet.mvc.SimpleGrailsControllerHelper.executeAction(SimpleGrailsControllerHelper.java:232)
 at org.codehaus.groovy.grails.web.servlet.mvc.SimpleGrailsControllerHelper.handleURI(SimpleGrailsControllerHelper.java:190)
 at org.codehaus.groovy.grails.web.servlet.mvc.SimpleGrailsControllerHelper.handleURI(SimpleGrailsControllerHelper.java:129)
 at org.codehaus.groovy.grails.web.servlet.mvc.SimpleGrailsController.handleRequest(SimpleGrailsController.java:73)
 at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
 at org.codehaus.groovy.grails.web.servlet.GrailsDispatcherServlet.doDispatch(GrailsDispatcherServlet.java:292)
 at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
 at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)
 at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:549)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70)
 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.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
 at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
 at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
 at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
 at org.codehaus.groovy.grails.web.util.WebUtils.forwardRequestForUrlMappingInfo(WebUtils.java:298)
 at org.codehaus.groovy.grails.web.util.WebUtils.forwardRequestForUrlMappingInfo(WebUtils.java:264)
 at org.codehaus.groovy.grails.web.util.WebUtils.forwardRequestForUrlMappingInfo(WebUtils.java:255)
 at org.codehaus.groovy.grails.web.mapping.filter.UrlMappingsFilter.doFilterInternal(UrlMappingsFilter.java:183)
 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.codehaus.groovy.grails.web.sitemesh.GrailsPageFilter.obtainContent(GrailsPageFilter.java:245)
 at org.codehaus.groovy.grails.web.sitemesh.GrailsPageFilter.doFilter(GrailsPageFilter.java:134)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.codehaus.groovy.grails.web.servlet.filter.GrailsReloadServletFilter.doFilterInternal(GrailsReloadServletFilter.java:104)
 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.codehaus.groovy.grails.web.servlet.mvc.GrailsWebRequestFilter.doFilterInternal(GrailsWebRequestFilter.java:69)
 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.codehaus.groovy.grails.web.filters.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:69)
 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.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
 at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
 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:191)
 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:293)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
 at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
 at java.lang.Thread.run(Thread.java:662)
2011-03-12 16:56:15,578 [http-8093-3] ERROR errors.GrailsExceptionResolver  - Exception occurred when processing request: [GET] /act-test3/testWorkflow/start
Stacktrace follows:
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:179)
 at org.activiti.engine.impl.db.DbRepositorySession.findDeployedLatestProcessDefinitionByKey(DbRepositorySession.java:168)
 at org.activiti.engine.impl.cmd.StartProcessInstanceCmd.execute(StartProcessInstanceCmd.java:52)
 at org.activiti.engine.impl.cmd.StartProcessInstanceCmd.execute(StartProcessInstanceCmd.java:29)
 at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)
 at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)
 at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)
 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.RuntimeServiceImpl.startProcessInstanceByKey(RuntimeServiceImpl.java:49)
 at org.activiti.engine.RuntimeService$startProcessInstanceByKey.call(Unknown Source)
 at org.grails.activiti.ActivitiService.startProcess(ActivitiService.groovy:37)
 at ActivitiGrailsPlugin$_addActivitiMethods_closure7_closure29.doCall(ActivitiGrailsPlugin.groovy:128)
 at ActivitiGrailsPlugin$_addActivitiMethods_closure7.doCall(ActivitiGrailsPlugin.groovy:126)
 at testWorkflow.TestWorkflowController$_closure2.doCall(TestWorkflowController.groovy:17)
 at testWorkflow.TestWorkflowController$_closure2.doCall(TestWorkflowController.groovy)
 at java.lang.Thread.run(Thread.java:662)

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

Re: Exception while running Vacation Request flow

frederikherema1 — Mon, 14 Mar 2011 06:58:10 GMT

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?

Re: Exception while running Vacation Request flow

ben11 — Mon, 14 Mar 2011 18:32:52 GMT

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

Re: Exception while running Vacation Request flow

rufini — Wed, 10 Aug 2011 17:38:52 GMT

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_

'myProcess:167:150103', 'Checkout', NULL, 'myProcess', '167', '150101', 'c:\path1\myProcess.bpmn20.xml', NULL, '0'
'myProcess:167:150203', 'Checkout', NULL, 'myProcess', '167', '150201', 'c:\path2\different\myProcess.bpmn20.xml', NULL, '0'

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

Re: Exception while running Vacation Request flow

rahulbabarit — Tue, 16 Aug 2011 05:42:19 GMT

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

Re: Exception while running Vacation Request flow

frankee787 — Mon, 19 Sep 2011 09:15:38 GMT

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

Re: Exception while running Vacation Request flow

hamed — Mon, 02 Jan 2012 07:22:34 GMT

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 ! ?

Re: Exception while running Vacation Request flow

ingo_ri — Mon, 02 Jan 2012 17:56:52 GMT

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

Re: Exception while running Vacation Request flow

shardt — Fri, 06 Jan 2012 10:38:06 GMT

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:


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

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:


ID_                              CATEGORY_   NAME_                    KEY_                     VERSION_  DEPLOYMENT_ID_
Prototype_flow_activiti:10:2008  http://…  prototype_flow_activiti  Prototype_flow_activiti  10        2001
Prototype_flow_activiti:10:2108  http://…  prototype_flow_activiti  Prototype_flow_activiti  10        2101

Re: Exception while running Vacation Request flow

trademak — Mon, 09 Jan 2012 08:19:16 GMT

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,

Re: Exception while running Vacation Request flow

goekan-t — Mon, 09 Jan 2012 09:54:55 GMT

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

Re: Exception while running Vacation Request flow

spanko — Tue, 03 Jul 2012 15:23:05 GMT

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):


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

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

Re: Exception while running Vacation Request flow

frederikherema1 — Wed, 04 Jul 2012 06:57:42 GMT

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

Re: Exception while running Vacation Request flow

satheesh1 — Thu, 11 Dec 2014 21:24:09 GMT

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