cancel
Showing results for 
Search instead for 
Did you mean: 

Undeploy workflow fails to foreign key constraints

cafeguy
Champ in-the-making
Champ in-the-making
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_`))
2 REPLIES 2

magarcia_sm
Star Contributor
Star Contributor
hi there

We are having the same issue here in alfresco 4.2. Could you let us know if you got to resolve this issue and how?

Thanks a lot in advance

adhi27
Champ in-the-making
Champ in-the-making
because your workflow still running so your workflow can't undeploy