AnsweredAssumed Answered

error when i delete the deployment

Question asked by nbklot3 on Mar 30, 2011
Latest reply on Apr 4, 2011 by 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

Outcomes