Hi All, I am using apache-ofbiz-10.04 stable version. The following error displays when creating a new employment from Human Resources.
ERROR: Could not complete the Create Employment [file:/E:/ofbiz10.04_lsvn/apache-ofbiz-10.04/applications/humanres/script/org/ofbiz/humanres/HumanResServices.xml#createEmployment] process [problem creating the newEntity value: Error while inserting: [GenericEntity:Employment][createdStamp,2011-03-21 13:28:40.105(java.sql.Timestamp)][createdTxStamp,2011-03-21 13:28:39.995(java.sql.Timestamp)][fromDate,2011-04-01 13:28:36.495(java.sql.Timestamp)][lastUpdatedStamp,2011-03-21 13:28:40.105(java.sql.Timestamp)][lastUpdatedTxStamp,2011-03-21 13:28:39.995(java.sql.Timestamp)][partyIdFrom,Company(java.lang.String)][partyIdTo,10000(java.lang.String)][roleTypeIdFrom,INTERNAL_ORGANIZATIO(java.lang.String)][roleTypeIdTo,EMPLOYEE(java.lang.String)][terminationReasonId,null()][terminationTypeId,null()][thruDate,null()] (SQL Exception while executing the following:INSERT INTO OFBIZ.EMPLOYMENT (ROLE_TYPE_ID_FROM, ROLE_TYPE_ID_TO, PARTY_ID_FROM, PARTY_ID_TO, FROM_DATE, THRU_DATE, TERMINATION_REASON_ID, TERMINATION_TYPE_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'EMPLOYMENT' caused a violation of foreign key constraint 'EMPLMNT_TPTRL' for key (10000,EMPLOYEE). The statement has been rolled back.))] Any help will be appreciated. Thanks Monica -- View this message in context: http://ofbiz.135035.n4.nabble.com/Error-displays-while-creating-a-new-employment-from-Human-Resources-tp3392849p3392849.html Sent from the OFBiz - User mailing list archive at Nabble.com.
