Odoo Help


How can I properly delete a Workflow ?

Bonnet Denis
on 2/6/13, 10:14 AM 2,975 views

Hello I created a workflow and I deleted him. This workflow has to create a meeting object when a project.task.work object is create. But now (workflow is delete) when I create a project.task.work object I have an error message on the log file(in French, I'm sorry):

IntegrityError: ERREUR:  une instruction insert ou update sur la table « wkf_instance » viole la contrainte de clé étrangère « wkf_instance_wkf_id_fkey »
DÉTAIL : La clé (wkf_id)=(10) n'est pas présente dans la table « wkf ».

It's normal I deleted this workflow, but why the program still search him?

thanks for help (and sorry for my English).

Thibaut DIRLIK
On 2/7/13, 9:44 AM

If I remember correctly, wkf_instance is a table which contain a row per object associated to a workflow. It seems that it tries to create an entry which references the workflow you removed.

So the question is why ? Could you give us the full query which generates this error, and could you cgeck in the database that your workflow has correctly been removed ?

I've already checked that the entry has been removed and she is. This is the query : 'insert into wkfinstance (restype,resid,uid,wkfid) values (%s,%s,%s,%s) RETURNING id', (restype,resid,uid,wkf_id)

Bonnet Denis
on 2/7/13, 11:21 AM

Did you restarted your server siince you deleted the workflow ?

Thibaut DIRLIK
on 2/8/13, 4:17 AM

No, but i just restart now and it's working. Thanks a lot.

Bonnet Denis
on 2/8/13, 5:17 AM

Might be a cache-related issue.

Thibaut DIRLIK
on 2/8/13, 9:23 AM

I think so.

Bonnet Denis
on 2/8/13, 10:04 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 2/6/13, 10:14 AM
Seen: 2975 times
Last updated: 3/16/15, 8:10 AM