Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
1 Odpowiedz
1267 Widoki

Hello everyone,

I’m currently facing an issue in Odoo CRM. I have a many2one field called stage_id in the crm.lead model, which is linked to the crm.stage model. I want to delete a specific stage from the crm.stage model as it is no longer needed. However, when I try to delete it, I encounter the following error:

Validation Error: The operation cannot be completed: another model requires the record being deleted. If possible, archive it instead.

Model: Lead/Opportunity (crm.lead)

Constraint: crm_lead_stage_id_fkey

I’ve checked, and there are no leads currently using this stage (active or archived). I’ve also verified that the stage isn’t set as the default in any pipeline or automation rules.

Has anyone encountered this issue before? Is there a way to resolve it without breaking database integrity? Any advice or guidance would be greatly appreciated!

Thank you! 😊

Awatar
Odrzuć

I'm currently facing the same issue :)

Najlepsza odpowiedź

Since the stage_id​ field from crm.stage​ is also linked to the crm.activity.report​ model, it is likely that this connection is preventing you from deleting the stage directly. The foreign key constraint enforces that no crm.activity.report​ records are referencing the stage you are trying to delete.

Awatar
Odrzuć
Autor

Thank you for responding, I checked the 'crm.activity.report' model and there was nothing referencing this stage.

Powiązane posty Odpowiedzi Widoki Czynność
0
mar 25
894
1
wrz 24
1559
1
cze 22
3188
0
wrz 17
3360
1
wrz 16
5175