topic Re: error when I deploy a bar file in Alfresco Archive

error when I deploy a bar file

nbklot3 — Wed, 30 Mar 2011 18:22:52 GMT

Hi,I generated bar file from eclipse designer (generate deployment artifacts) and tried to deploy it activiti probe. I get the below error -Expected one result (or null) to be returned by selectOne(), but found: 2I have also attached the bar file with this post. Thanks for your Help.Arun

Re: error when I deploy a bar file

frederikherema1 — Thu, 31 Mar 2011 05:15:09 GMT

Can you post the full stacktrace you see in tomcat log?

Re: error when I deploy a bar file

nbklot3 — Fri, 01 Apr 2011 15:02:02 GMT

Here is the full tomcat log -

FINE: Parsing activity endevent2
Apr 1, 2011 11:01:12 AM org.activiti.engine.impl.bpmn.deployer.BpmnDeployer deploy
INFO: Processing resource request.form
Apr 1, 2011 11:01:12 AM org.activiti.engine.impl.interceptor.CommandContext close
SEVERE: 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.findLatestProcessDefinitionByKey(DbRepositorySession.java:164)
at org.activiti.engine.impl.bpmn.deployer.BpmnDeployer.deploy(BpmnDeployer.java:105)
at org.activiti.engine.impl.db.DbRepositorySession.deploy(DbRepositorySession.java:65)
at org.activiti.engine.impl.cmd.DeployCmd.execute(DeployCmd.java:53)
at org.activiti.engine.impl.cmd.DeployCmd.execute(DeployCmd.java:30)
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.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
at org.activiti.engine.impl.RepositoryServiceImpl.deploy(RepositoryServiceImpl.java:43)
at org.activiti.engine.impl.repository.DeploymentBuilderImpl.deploy(DeploymentBuilderImpl.java:103)
at org.activiti.rest.api.repository.DeploymentPost.executeWebScript(DeploymentPost.java:44)
at org.activiti.rest.util.ActivitiWebScript.executeImpl(ActivitiWebScript.java:68)
at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:64)
at org.springframework.extensions.webscripts.PresentationContainer.executeScript(PresentationContainer.java:69)
at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:333)
at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:189)
at org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:118)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
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:619)
Apr 1, 2011 11:01:12 AM org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext rollback
FINE: firing event rolling back…
Apr 1, 2011 11:01:12 AM org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext rollback
FINE: rolling back ibatis sql session…
Apr 1, 2011 11:01:12 AM org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext rollback
FINE: firing event rolled back…
Apr 1, 2011 11:01:12 AM org.activiti.engine.impl.interceptor.LogInterceptor execute
FINE: — DeployCmd finished ——————————————————–
Apr 1, 2011 11:01:12 AM org.activiti.engine.impl.interceptor.LogInterceptor execute
FINE:

Re: error when I deploy a bar file

frederikherema1 — Mon, 04 Apr 2011 06:53:21 GMT

Looks like it is related to http://forums.activiti.org/en/viewtopic.php?f=10&t=1407. Joram is looking into it.

Re: error when I deploy a bar file

jbarrez — Mon, 04 Apr 2011 07:18:44 GMT

The error is thrown when there are multiple process definitions with the same version in the database.

I took your process, and tried to deploy it 5 times through Probe, and each time it succeeds.
So I'm unable to reproduce it. Can you describe how to do it (using Activiti 5.4)?

Re: error when I deploy a bar file

nbklot3 — Tue, 05 Apr 2011 14:45:44 GMT

Hi,

Please start few instances of the process and accept one of them with user Kermit. and then try deploying or try deleting the previously deployed process. I get error in either case.

Re: error when I deploy a bar file

jbarrez — Wed, 06 Apr 2011 07:56:41 GMT

I started a few process instances, and completed the form (something about database and submit query)… when I delete the deployment by cascade in the Probe UI, all processes are deleted without seeing any exception ….

Re: error when I deploy a bar file

giga_zhang — Wed, 30 May 2012 09:05:38 GMT

Here is the full tomcat log -

FINE: Parsing activity endevent2
Apr 1, 2011 11:01:12 AM org.activiti.engine.impl.bpmn.deployer.BpmnDeployer deploy
INFO: Processing resource request.form
Apr 1, 2011 11:01:12 AM org.activiti.engine.impl.interceptor.CommandContext close
SEVERE: 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.findLatestProcessDefinitionByKey(DbRepositorySession.java:164)
at org.activiti.engine.impl.bpmn.deployer.BpmnDeployer.deploy(BpmnDeployer.java:105)
at org.activiti.engine.impl.db.DbRepositorySession.deploy(DbRepositorySession.java:65)
at org.activiti.engine.impl.cmd.DeployCmd.execute(DeployCmd.java:53)
at org.activiti.engine.impl.cmd.DeployCmd.execute(DeployCmd.java:30)
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.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
at org.activiti.engine.impl.RepositoryServiceImpl.deploy(RepositoryServiceImpl.java:43)
at org.activiti.engine.impl.repository.DeploymentBuilderImpl.deploy(DeploymentBuilderImpl.java:103)
at org.activiti.rest.api.repository.DeploymentPost.executeWebScript(DeploymentPost.java:44)
at org.activiti.rest.util.ActivitiWebScript.executeImpl(ActivitiWebScript.java:68)
at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:64)
at org.springframework.extensions.webscripts.PresentationContainer.executeScript(PresentationContainer.java:69)
at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:333)
at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:189)
at org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:118)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
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:619)
Apr 1, 2011 11:01:12 AM org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext rollback
FINE: firing event rolling back…
Apr 1, 2011 11:01:12 AM org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext rollback
FINE: rolling back ibatis sql session…
Apr 1, 2011 11:01:12 AM org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext rollback
FINE: firing event rolled back…
Apr 1, 2011 11:01:12 AM org.activiti.engine.impl.interceptor.LogInterceptor execute
FINE: — DeployCmd finished ——————————————————–
Apr 1, 2011 11:01:12 AM org.activiti.engine.impl.interceptor.LogInterceptor execute
FINE:

The error is thrown when there are multiple process definitions with the same id in the database.
check the id property in you bpmn file.there must be have two file with the same id.