You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ofbiz.apache.org by "monica.das" <mo...@gmail.com> on 2011/03/21 08:55:03 UTC

Error displays while creating a new employment from Human Resources.

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.

Re: Error displays while creating a new employment from Human Resources.

Posted by "monica.das" <mo...@gmail.com>.

Thanks a lot. It works fine.

Regards
Monica

--
View this message in context: http://ofbiz.135035.n4.nabble.com/Error-displays-while-creating-a-new-employment-from-Human-Resources-tp3392849p3392965.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: Error displays while creating a new employment from Human Resources.

Posted by Mike <mz...@gmail.com>.

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 <mo...@gmail.com>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.
>