c2c-oerpscenario team mailing list archive

["Azazahmed Saiyed \(OpenERP\)" <753187@xxxxxxxxxxxxxxxxxx>]

** Project changed: openobject-addons => openobject-server

** Changed in: openobject-server
   Importance: Undecided => Low

** Changed in: openobject-server
       Status: New => Confirmed

** Changed in: openobject-server
     Assignee: (unassigned) => OpenERP's Framework R&D (openerp-dev-framework)

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/753187

Title:
  hr.employee cannot add category to employee

Status in OpenERP Server:
  Confirmed

Bug description:
  - Create a new category of employee
  Open an employee form, add the category and save the employee form. 

  ------------------------------------------------------------------------------------------------------------

  The GTK client gives a 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: Employee Category - hr.employee.category]

  ------------------------------------------------------------------------------------------------------------

  The server (6.1-dev) log gives :

  ERROR:db.cursor:bad query: insert into employee_category_rel (emp_id,category_id) values (27, 1)
  Traceback (most recent call last):
    File "/usr/lib/openerp/trunk/server/openerp/sql_db.py", line 131, in execute
      res = self._obj.execute(query, params)
  IntegrityError: insert or update on table "employee_category_rel" violates foreign key constraint "employee_category_rel_emp_id_fkey"
  DETAIL:  Key (emp_id)=(27) is not present in table "hr_employee_category".