error when i delete the deployment

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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