error when i delete the deployment

[nbklot3]

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 violation: "ACT_FK_TASK_PROCDEF: PUBLIC.ACT_RU_TASK FOREIGN KEY(PROC_DEF_ID_) REFERENCES PUBLIC.ACT_RE_PROCDEF(ID_)"; SQL statement:
   delete from ACT_RE_PROCDEF where DEPLOYMENT_ID_ = ? [23003-132]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)
    at org.h2.message.DbException.get(DbException.java:167)
    at org.h2.message.DbException.get(DbException.java:144)
    at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:374)
    at org.h2.constraint.ConstraintReferential.checkRowRefTable(ConstraintReferential.java:391)
    at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:271)
    at org.h2.table.Table.fireConstraints(Table.java:766)
    at org.h2.table.Table.fireAfterRow(Table.java:783)
    at org.h2.command.dml.Delete.update(Delete.java:79)
    at org.h2.command.CommandContainer.update(CommandContainer.java:70)
    at org.h2.command.Command.executeUpdate(Command.java:198)
    at org.h2.server.TcpServerThread.process(TcpServerThread.java:298)
    at org.h2.server.TcpServerThread.run(TcpServerThread.java:135)
    at java.lang.Thread.run(Unknown Source)
  
   ### The error may involve org.activiti.persistence.deleteProcessDefinitionsByDeploymentId-Inline
   ### The error occurred while setting parameters
   ### Cause: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "ACT_FK_TASK_PROCDEF: PUBLIC.ACT_RU_TASK FOREIGN KEY(PROC_DEF_ID_) REFERENCES PUBLIC.ACT_RE_PROCDEF(ID_)"; SQL statement:
   delete from ACT_RE_PROCDEF where DEPLOYMENT_ID_ = ? [23003-132]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)
    at org.h2.message.DbException.get(DbException.java:167)
    at org.h2.message.DbException.get(DbException.java:144)
    at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:374)
    at org.h2.constraint.ConstraintReferential.checkRowRefTable(ConstraintReferential.java:391)
    at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:271)
    at org.h2.table.Table.fireConstraints(Table.java:766)
    at org.h2.table.Table.fireAfterRow(Table.java:783)
    at org.h2.command.dml.Delete.update(Delete.java:79)
    at org.h2.command.CommandContainer.update(CommandContainer.java:70)
    at org.h2.command.Command.executeUpdate(Command.java:198)
    at org.h2.server.TcpServerThread.process(TcpServerThread.java:298)
    at org.h2.server.TcpServerThread.run(TcpServerThread.java:135)
    at java.lang.Thread.run(Unknown Source)
  
Thanks,
Arun

[jbarrez]

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'.

[nbklot3]

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

[jbarrez]

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

[frederikherema1]

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

[nbklot3]

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