Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
v7
1 Odgovori
6692 Prikazi
Avatar
Bonnet Denis

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).

Avatar
Opusti
Avatar
Thibaut DIRLIK
Best Answer

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 ?

Avatar
Opusti
Bonnet Denis
Avtor

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)

Thibaut DIRLIK

Did you restarted your server siince you deleted the workflow ?

Bonnet Denis
Avtor

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

Thibaut DIRLIK

Might be a cache-related issue.

Bonnet Denis
Avtor

I think so.

Related Posts Odgovori Prikazi Aktivnost
How to add a "Delete" button on the popup form?
v7
Avatar
Avatar
1
avg. 25
4874
Minimum Lot Charge For Sales Order Line Items
v7
Avatar
0
dec. 24
9867
Record Rule to allow a User to update their own Employee object without belonging to Officer group Solved
v7
Avatar
Avatar
Avatar
Avatar
3
sep. 24
22192
How to activate the Technical Features? Solved
v7
Avatar
Avatar
Avatar
Avatar
Avatar
5
dec. 24
53726
Way to only allow a specific DB to be the default? Solved
v7
Avatar
Avatar
Avatar
Avatar
Avatar
4
jul. 24
11006