error when i delete the deployment

nbklot3 — Wed, 30 Mar 2011 18:15:05 GMT

Hi,I tried to delete the previous deployments I did and it is throwing below error. Let me know if I'm missing anything. Thanks for your help!02300002 Wrapped Exception (with status template): ### Error updating database. Cause: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violat

Re: error when i delete the deployment

jbarrez — Fri, 01 Apr 2011 09:27:01 GMT

It appears that you are deleting a process definition that still has runtime data.

If you also want to remove the runtime data when deleting a deployment, you should use the deleteDeployment(id, cascade) method, where cascade is set to 'true'.

Re: error when i delete the deployment

nbklot3 — Fri, 01 Apr 2011 14:59:51 GMT

I tried using the delete cascade option in the Deployments page of activiti-probe. Still getting some error -

FINE: Parsing activity usertask4
Apr 1, 2011 10:56:11 AM org.activiti.engine.impl.bpmn.parser.BpmnParse createActivityOnScope
FINE: Parsing activity endevent2
Apr 1, 2011 10:56:11 AM org.activiti.engine.impl.bpmn.deployer.BpmnDeployer deploy
INFO: Processing resource MTest/pom.xml
Apr 1, 2011 10:56:11 AM org.activiti.engine.impl.bpmn.deployer.BpmnDeployer deploy
INFO: Processing resource MTest/src/main/resources/diagrams/HelloWorld.bpmn20.xml
Apr 1, 2011 10:56:11 AM org.activiti.engine.impl.bpmn.parser.BpmnParse parseDefinitionsAttributes
INFO: XMLSchema currently not supported as typeLanguage
Apr 1, 2011 10:56:11 AM org.activiti.engine.impl.bpmn.parser.BpmnParse parseDefinitionsAttributes
INFO: XPath currently not supported as expressionLanguage
Apr 1, 2011 10:56:11 AM org.activiti.engine.impl.bpmn.parser.BpmnParse parseProcess
FINE: Parsing process helloworld
Apr 1, 2011 10:56:11 AM org.activiti.engine.impl.bpmn.parser.BpmnParse createActivityOnScope
FINE: Parsing activity startevent2
Apr 1, 2011 10:56:11 AM org.activiti.engine.impl.bpmn.parser.BpmnParse createActivityOnScope
FINE: Parsing activity usertask3
Apr 1, 2011 10:56:11 AM org.activiti.engine.impl.bpmn.parser.BpmnParse createActivityOnScope
FINE: Parsing activity usertask4
Apr 1, 2011 10:56:11 AM org.activiti.engine.impl.bpmn.parser.BpmnParse createActivityOnScope
FINE: Parsing activity endevent2
Apr 1, 2011 10:56:11 AM org.activiti.engine.impl.bpmn.deployer.BpmnDeployer deploy
INFO: Processing resource MTest/target/classes/diagrams/HelloWorld.activiti
Apr 1, 2011 10:56:11 AM org.activiti.engine.impl.bpmn.deployer.BpmnDeployer deploy
INFO: Processing resource MTest/.project
Apr 1, 2011 10:56:11 AM org.activiti.engine.impl.bpmn.deployer.BpmnDeployer deploy
INFO: Processing resource MTest/src/test/resources/activiti.cfg.xml
Apr 1, 2011 10:56:11 AM org.activiti.engine.impl.bpmn.deployer.BpmnDeployer deploy
INFO: Processing resource MTest/src/main/resources/request.form
Apr 1, 2011 10:56:11 AM org.activiti.engine.impl.bpmn.deployer.BpmnDeployer deploy
INFO: Processing resource MTest/src/main/resources/diagrams/HelloWorld.png
Apr 1, 2011 10:56:11 AM org.activiti.engine.impl.bpmn.deployer.BpmnDeployer deploy
INFO: Processing resource MTest/target/classes/request.form
Apr 1, 2011 10:56:11 AM org.activiti.engine.impl.bpmn.deployer.BpmnDeployer deploy
INFO: Processing resource MTest/.classpath
Apr 1, 2011 10:56:11 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.findProcessDefinitionByDeploymentAndKey(DbRepositorySession.java:160)
at org.activiti.engine.impl.bpmn.deployer.BpmnDeployer.deploy(BpmnDeployer.java:131)
at org.activiti.engine.impl.db.DbRepositorySession.deploy(DbRepositorySession.java:65)
at org.activiti.engine.impl.db.DbRepositorySession.resolveProcessDefinition(DbRepositorySession.java:195)
at org.activiti.engine.impl.db.DbRepositorySession.findDeployedProcessDefinitionById(DbRepositorySession.java:184)
at org.activiti.engine.impl.runtime.ExecutionEntity.ensureProcessDefinitionInitialized(ExecutionEntity.java:603)
at org.activiti.engine.impl.runtime.ExecutionEntity.getProcessDefinition(ExecutionEntity.java:588)
at org.activiti.engine.impl.runtime.ExecutionEntity.ensureActivityInitialized(ExecutionEntity.java:655)
at org.activiti.engine.impl.runtime.ExecutionEntity.getActivity(ExecutionEntity.java:648)
at org.activiti.engine.impl.runtime.ExecutionEntity.getActivity(ExecutionEntity.java:69)
at org.activiti.engine.impl.pvm.runtime.AtomicOperationDeleteCascadeFireActivityEnd.getScope(AtomicOperationDeleteCascadeFireActivityEnd.java:28)
at org.activiti.engine.impl.pvm.runtime.AbstractEventAtomicOperation.execute(AbstractEventAtomicOperation.java:29)
at org.activiti.engine.impl.interceptor.CommandContext.performOperation(CommandContext.java:64)
at org.activiti.engine.impl.runtime.ExecutionEntity.performOperation(ExecutionEntity.java:505)
at org.activiti.engine.impl.pvm.runtime.AtomicOperationDeleteCascade.execute(AtomicOperationDeleteCascade.java:31)
at org.activiti.engine.impl.interceptor.CommandContext.performOperation(CommandContext.java:64)
at org.activiti.engine.impl.runtime.ExecutionEntity.performOperation(ExecutionEntity.java:505)
at org.activiti.engine.impl.runtime.ExecutionEntity.deleteCascade(ExecutionEntity.java:314)
at org.activiti.engine.impl.db.DbRuntimeSession.deleteProcessInstance(DbRuntimeSession.java:63)
at org.activiti.engine.impl.db.DbRepositorySession.deleteProcessInstances(DbRepositorySession.java:103)
at org.activiti.engine.impl.db.DbRepositorySession.deleteDeployment(DbRepositorySession.java:89)
at org.activiti.engine.impl.cmd.DeleteDeploymentCmd.execute(DeleteDeploymentCmd.java:36)
at org.activiti.engine.impl.cmd.DeleteDeploymentCmd.execute(DeleteDeploymentCmd.java:22)
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.deleteDeployment(RepositoryServiceImpl.java:55)
at org.activiti.rest.api.repository.DeploymentsDeletePost.executeWebScript(DeploymentsDeletePost.java:46)
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 10:56:11 AM org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext rollback
FINE: firing event rolling back…
Apr 1, 2011 10:56:11 AM org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext rollback
FINE: rolling back ibatis sql session…
Apr 1, 2011 10:56:11 AM org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext rollback

Re: error when i delete the deployment

jbarrez — Mon, 04 Apr 2011 06:51:21 GMT

Seems like there are two process definitions with the same version. I've read other posts also mentioning this. I'll look into it.

Re: error when i delete the deployment

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

See http://forums.activiti.org/en/viewtopic.php?f=10&t=1408&p=5950#p5950 -> same issue I guess?

Re: error when i delete the deployment

nbklot3 — Mon, 04 Apr 2011 15:50:34 GMT

yes, the issues are related I guess. BTW, I posted both the topics

topic Re: error when i delete the deployment in Alfresco Archive

error when i delete the deployment

Re: error when i delete the deployment

Re: error when i delete the deployment

Re: error when i delete the deployment

Re: error when i delete the deployment

Re: error when i delete the deployment