Passa al contenuto
Menu
È necessario essere registrati per interagire con la community.
La domanda è stata contrassegnata
1 Rispondi
5415 Visualizzazioni

I'm now getting a "Odoo Warning"   "Integrity Error - duplicate key value violates unique constraint "account_invoice_line_pkey" DETAIL: Key (id)=(46) already exists.

This was when I clicked the "Update" button on a new invoice for Tax.    It happened prior when I just tried to Save the Invoice.    As far as I can tell looking in the database there shouldn't be any ID=46 already.

Pressing save I get a new error:    "wkf_instance_pkey"  DETAIL: Key (id)=(43) already exists.

If I press Save again I get the following:  "wkf_instance_pkey" DETAIL Key (id)=(44) already exists.


What's going on and how should I get this fixed?


Avatar
Abbandona
Autore Risposta migliore

Not sure why this happened, but the solution was to keep clicking on the SAVE button until the ID incremented enough to be able to save.    Could have been that we restored over existing data and the indexes were off.

Avatar
Abbandona
Post correlati Risposte Visualizzazioni Attività
1
dic 24
4636
0
nov 24
1888
2
lug 24
3839
0
apr 24
2437
3
mar 24
4105