topic hi, i tried to undeploy a workflow using 'undeploy definition<definitionid>' and it shows the following error message: in Alfresco Forum

hi, i tried to undeploy a workflow using 'undeploy definition' and it shows the following error message:

klotilda — Wed, 06 Sep 2017 14:49:57 GMT

org.apache.ibatis.exceptions.PersistenceException: ### Error updating database. Cause: org.postgresql.util.PSQLException: ERROR: update or delete on table "act_re_procdef" violates foreign key constraint "act_fk_exe_procdef" on table "act_ru_execution" Detail: Key (id_)=(fredy1:1:2112) is still

Re: hi, i tried to undeploy a workflow using 'undeploy definition' and it shows the following error message:

douglascrp — Wed, 06 Sep 2017 18:16:33 GMT

Well, it seems you still have some instances of that workflow being executed.

If you want to undeploy it, you need to delete the workflow instances before.

You can do this with the following command:

delete all workflows imeanit

But be careful with it, as it will delete ALL the instances, for ALL the process definitions.

Re: hi, i tried to undeploy a workflow using 'undeploy definition' and it shows the following error message:

klotilda — Wed, 06 Sep 2017 19:05:27 GMT

is there a way to delete only the instances of a certain workflow, not all of them?

Re: hi, i tried to undeploy a workflow using 'undeploy definition' and it shows the following error message:

douglascrp — Sat, 09 Sep 2017 01:09:43 GMT

You can execute the following commands:

use definition [<workflowDefId>]

This will make the specif definition the "current" one

Then you can use this to list all the instances for the current process definition:

show workflows

And finally, using the instances IDs, you can execute:

delete workflow <workflowId>