Odoo Help


Delete User

Rex Thain
on 3/14/13, 10:21 AM 6,872 views

I created a new user. Input just the User name and Login field. Then attempted to delete the user and received this error message:

Integrity Error

The operation cannot be completed, probably due to the following: - deletion: you may be trying to delete a record while other records still reference it - creation/update: a mandatory field is not correctly set

[object with reference: Note Stage - note.stage]

Is it not possible to ever delete a user? Or is this a bug? Using V7 on Unbuntu 12.04


Ray Carnes

--Ray Carnes--
| 9 7 9
Keyport, United States
--Ray Carnes--

Senior ERP Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0 and 11.0.

Completed Odoo Functional and Technical Training.

Functional Areas:

  • CRM/Sales

  • Inventory

  • Manufacturing

  • Accounting

  • Purchasing

Major Skills:

  • Business Process Reengineering

  • Efficiency Consulting

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

I am a skilled Communicator and I only take the serious things seriously!

Ray Carnes
On 3/28/13, 7:00 PM

You can't delete a record in OpenERP that is referred to by another record.

You can't delete a Customer referred to by a Sale. You can't delete a Product referred to by a Stock Move.

This is part of the referential integrity of the database (and of the ERP).

OpenERP supports the concept of INACTIVE on many record types (like products and users) so that you can 'remove' these records from showing up but keep them in the system so the referring record is still valid.


Parth Gajjar

--Parth Gajjar--

| 3 3 5
Ahmadabad, India
--Parth Gajjar--
Parth Gajjar
On 3/14/13, 10:32 AM

In note.stage object you have reference of This user. By means you use this user in note.stage so that record which used this user as reference in note.stage object. Delete that first. Then delete User.

It is possible to delete a user.

Example : Create new user, save it, and delete it without use it in any record.

Hope this will help

Thank you for the quick response. How would I delete the record in note.stage? Must this be done through the database or is there a user interface? Thanks

Rex Thain
on 3/14/13, 10:41 AM

I Don't know why you getting error, i created user and add his reference in note.stage and then also i can delete that user ....

By the way for delete note.stage record login with that user and go in this menu Messaging/Organizer/Notes and delete the column created by that user

Parth Gajjar
on 3/15/13, 2:23 AM
Rex Thain
On 3/28/13, 5:54 PM

I must have had a problem the permissions on my installation. I reinstalled OpenERP on fresh Ubuntu installation and no more problem.

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 3/14/13, 10:21 AM
Seen: 6872 times
Last updated: 3/16/15, 8:10 AM