AnsweredAssumed Answered

Undeploy workflow fails to foreign key constraints

Question asked by cafeguy on Jul 2, 2014
Latest reply on Nov 23, 2015 by adhi27
Hi,
  I'm trying to undeploy workflows using "undeploy definitiion name <myworkflow>", and it's throwing me a bunch of foreign key constraint errors.  I haven't found anything like this on google yet.  Has anyone seen this?  Could it be because there are some pending workflows associated with these definitions?

org.apache.ibatis.exceptions.PersistenceException:
### Error updating database.  Cause: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`alfresco`.`act_ru_task`, CONSTRAINT `ACT_FK_TASK_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`))
### The error may involve org.activiti.engine.impl.persistence.entity.ProcessDefinitionEntity.deleteProcessDefinitionsByDeploymentId-Inline
### The error occurred while setting parameters
### Cause: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`alfresco`.`act_ru_task`, CONSTRAINT `ACT_FK_TASK_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`))

Outcomes