duplicate key value violates unique constraint

Question

Good day,
after removal of a module, i cant install a new module and i get the following message:
The operation cannot be completed: duplicate key value violates unique constraint "res_partner_pkey"
DETAIL:  Key (id)=(113) already exists.

So ive tried to figure out how to fix it including
ALTER SEQUENCE res_partner_id_seq RESTART WITH 300;

Is there anyone that can possibly tell me what im supposed to check or change to changes it so a new module will start on a different index?

Thank you!

Cybrosys Techno Solutions Pvt.Ltd · Answer

Hi,
Identify the conflict:
You need to determine why there is a conflict
with the value 113 in the "id" column. This could be due to a previous
record that wasn't properly removed or some other issue. You should find
out which record has an "id" of 113.
Resolve the conflict:
Once
you've identified the conflicting record, you'll need to decide how to
resolve it. You might need to delete the conflicting record if it's no
longer needed or update it to have a different "id" value.
Restart the sequen

Post Terkait	Replies	Tampilan
DeprecationWarning: The longpolling-port is a deprecated alias to the gevent-port option, please use the latter Diselesaikan odoo16features	5 Sep 25	25283
How to Add wizard under print button inside the form view. odoo16features	3 Agu 25	3854
How to add @api.onchange in _get_view() method odoo 16 odoo16features	1 Mei 25	3751
get all partners which are internal users or portal users odoo16 odoo16features	1 Apr 25	4605
How to add decoration color green with bold to a record with a single conditon odoo16features	1 Apr 25	5426

Pertanyaan ini telah diberikan tanda

Menikmati diskusi? Jangan hanya membaca, ikuti!