Passa al contenuto
Menu
È necessario essere registrati per interagire con la community.
La domanda è stata contrassegnata
3 Risposte
1697 Visualizzazioni

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! 😊

Avatar
Abbandona

I'm currently facing the same issue :)

Risposta migliore

Hi,


In Odoo CRM, the error you’re seeing when trying to delete a stage (crm.stage) comes from a foreign key constraint (crm_lead_stage_id_fkey), meaning at least one record still references that stage. This can happen even if no active leads use it, since archived leads, sales teams (pipelines), or default configurations may still link to it. To resolve, you should first search for all leads including archived ones, check sales teams to see if the stage is still assigned, and confirm it isn’t set as a default. The safest practice is to archive the stage instead of deleting it, especially in production, to preserve database integrity and historical data. Deletion should only be done if you’re absolutely sure nothing references it.


Hope it helps

Avatar
Abbandona
Risposta migliore

Facing the same issue here.

Avatar
Abbandona
Risposta migliore

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.

Avatar
Abbandona
Autore

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

Post correlati Risposte Visualizzazioni Attività
2
ago 25
1611
1
set 24
1849
1
giu 22
3509
0
set 17
3560
1
set 16
5379