Undeploy workflow fails to foreign key constraints

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-02-2014 03:12 PM
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_`))
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_`))
Labels:
- Labels:
-
Archive
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-23-2015 03:20 AM
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
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-23-2015 05:07 AM
because your workflow still running so your workflow can't undeploy
