Error displays while creating a new employment from Human Resources.

[monica.das]

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

[Mike Z]

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.

On Mon, Mar 21, 2011 at 12:55 AM, monica.das <[hidden email]>wrote:

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

[monica.das]

Thanks a lot. It works fine.

Regards
Monica