I tried it with trunk and it seems to work. It also looks like you can
create an employee by using party with role type "Employee". Try that.
> 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.
>