#64821 Incident ID:15645 - Foreign key error saving new employee

open
nobody
None
5
2011-09-12
2011-09-12
omfgppc
No

Description:

Get the following db error saving a new employee record:

ERROR: duplicate key value violates unique constraint "emp_emp_number_key"
QPSQL: Unable to create query
INSERT INTO emp ( emp_code, emp_number, emp_active, emp_cntct_id, emp_warehous_id, emp_mgr_emp_id, emp_wage_type, emp_wage, emp_wage_curr_id, emp_wage_period, emp_dept_id, emp_shift_id, emp_notes, emp_image_id, emp_extrate, emp_extrate_period, emp_startdate, emp_name) VALUES ( 'TTOYS', '', TRUE, 1, NULL, NULL, 'H', 0, 1, 'H', NULL, NULL, '', NULL, 0, 'H', NULL, 'Tremendous Toys Incorporated') RETURNING emp_id;

Steps to reproduce:

Open TTOYS CRM account
Select Employee flag
Select Employee button
On Employee screen, select the SAVE button
See error

Additional information

For the entire bug information, please visit

http://www.xtuple.org/xtincident/view/bugs/15645

Discussion


Log in to post a comment.