c2c-oerpscenario team mailing list archive

[Coco <753187@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

- 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".

** Affects: openobject-addons
     Importance: Undecided
         Status: New

-- 
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 Modules (addons):
  New

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".