Odoo Help

Welcome!

This community 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.

0

How can I properly delete a Workflow ?

v7
By
Bonnet Denis
on 2/6/13, 10:14 AM 2,094 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).

1
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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

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